The Resource Access 2007 VBA programming for dummies, by Joseph C. Stockman and Alan Simpson, (electronic resource)

Access 2007 VBA programming for dummies, by Joseph C. Stockman and Alan Simpson, (electronic resource)

Label
Access 2007 VBA programming for dummies
Title
Access 2007 VBA programming for dummies
Statement of responsibility
by Joseph C. Stockman and Alan Simpson
Creator
Contributor
Subject
Language
eng
Summary
Completely revised, this book includes coverage of basic concepts and general VBA topics for nonprogrammers.; Some of the basic topics covered include modules, procedures, and objects; while more advanced topics are SQL record sets and other programming activities that are unique to Access programming.; Offers practical, ready-to-use solutions to various Access procedures so readers can just drop information into their databases and use it immediately.; Addresses using the Visual Basic Editor; creating a simple VBA program; using VBA with multiple databases; and integrating with other Office a
Member of
Cataloging source
N$T
Dewey number
005.75/65
Index
index present
LC call number
QA76.9.D3
LC item number
S76 2007eb
Literary form
non fiction
Nature of contents
dictionaries
Series statement
  • EBSCO eBooks
  • --For dummies
Target audience
adult
Label
Access 2007 VBA programming for dummies, by Joseph C. Stockman and Alan Simpson, (electronic resource)
Link
http://ezproxy.ae.talonline.ca/login?url=http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=185562
Publication
Copyright
Note
Includes index
Antecedent source
unknown
http://library.link/vocab/branchCode
  • EPLMNA
Carrier category
online resource
Carrier category code
cr
Carrier MARC source
rdacarrier
Color
multicolored
Content category
text
Content type code
txt
Content type MARC source
rdacontent
Contents
Part I Introducing VBA Programming -- Chapter 1 Where VBA Fits In -- Taking a Look at Access -- Understanding VBA -- Seeing Where VBA Lurks -- Finding Out How VBA Works -- Chapter 2 Your VBA Toolkit -- Using the Visual Basic Editor -- Referring to Objects from VBA -- Setting References to Object Libraries -- Using the Object Browser -- Searching the Object Library -- Chapter 3 Jumpstart; Creating a Simple VBA Program -- Creating a Standard Module -- Creating a Procedure -- Understanding Syntax -- Using Existing Code -- Part II VBA Tools and Techniques -- Chapter 4 Understanding Your VBA Building Blocks -- Commenting Your Code -- Understanding VBA Data Types -- Passing Data to Procedures -- Repeating Chunks of Code with Loops -- Making Decisions in VBA Code -- Chapter 5 Controlling Access through VBA -- Understanding Object Models -- Manipulating Properties and Methods -- Chapter 6 Programming Access Forms -- Working with Class Procedures -- Enabling or Disabling Form Controls -- Responding to Form Events -- Changing the Appearance of Objects -- Opening and Closing Forms -- Part III VBA; Recordsets; and SQL -- Chapter 7 The Scoop on SQL and Recordsets -- What the Heck Is SQL?-- Creating Tables from VBA -- Adding Records to a Table -- Changing and Deleting Table Records -- Performing an Action Query on One Record -- Working with Select Queries and Recordsets -- Chapter 8 Putting Recordsets to Work -- Looping through Collections -- Tips on Reading and Modifying Code -- Skipping Over Used Mailing Labels -- Looking at How Skip Labels Works -- Calling a Procedure from an Event -- Part IV Applying VBA in the Real World -- Chapter 9 Creating Your Own Dialog Boxes -- Displaying and Responding to Messages -- Converting Forms to Dialog Boxes -- Creating Custom Combo Boxes -- Creating a Spin Box Control -- Detecting a Right Click -- Chapter 10 Customizing Combo Boxes and List Boxes -- Programming Combo and List Boxes -- Linking Lists -- Linking Lists across Forms -- More Combo Box Tricks -- Chapter 11 Creating Your Own Functions -- The Role of Functions in VBA -- Creating Your Own Functions -- A Proper Case Function -- A Function to Print Check Amounts -- Chapter 12 Testing and Debugging Your Code -- Understanding Compilation and Runtime -- Considering Types of Program Errors -- Conquering Compile Errors -- Dealing with Logical Errors -- Wrestling Runtime Errors -- Part V Reaching Out with VBA -- Chapter 13 Using VBA with Multiple Databases -- Server Microsoft Access -- Importing from External Databases -- Linking to External Data through Code -- Avoiding Multiple Tables and Links -- Creating Recordsets from External Tables -- Importing; Exporting; or Linking to Anything -- Chapter 14 Integrating with Other Office Applications -- Accessing the Object Library -- Sending Mail via Outlook -- Sending Data to Microsoft Word -- Interacting with Microsoft Excel -- Part VI The Part of Tens -- Chapter 15 Ten Commandments of Writing VBA -- Thou Shalt Not Harbor Strange Beliefs about Microsoft Access -- Thou Shalt Not Use VBA Statements in Vain -- Remember to Keep Holy the VBA Syntax
Control code
ocm85854706
Dimensions
unknown
Extent
1 online resource (1 volume).
File format
unknown
Form of item
online
Isbn
9781280741913
Level of compression
unknown
Media category
computer
Media MARC source
rdamedia
Media type code
c
Quality assurance targets
not applicable
http://library.link/vocab/recordID
u1186178
Reformatting quality
unknown
Sound
unknown sound
Specific material designation
remote
System control number
  • (Sirsi) ebs85854706
  • (CaAE) ebs85854706
  • (OCoLC)85854706

Library Locations

    • Stanley A. Milner (Downtown)Borrow it
      7 Sir Winston Churchill Square, Edmonton, AB, T5J 2V4, CA
      53.542897 -113.48975860000002
Processing Feedback ...