Microsoft® Access® 2010 VBA Programming Inside Out
Written by Andrew Couch (Developer of MUST)
||You're beyond the basics, so dive right in and customize, automate, and extend Access—using Visual Basic® for Applications (VBA). This supremely organized reference is packed with hundreds of time-saving solutions, troubleshooting tips, and workarounds. It's all muscle and no fluff.
Discover how the experts use VBA to exploit the power of Access—and challenge yourself to new levels of mastery!
- Enhance your application with VBA built-in functions and SQL code
- Use the Access Object Model to work with data in forms and reports
- Manipulate data using SQL, queries, and recordsets with Data Access Objects (DAO)
- Create classes for handling form and control events
- Connect your Access database to different sources of data
- Effectively plan how to upsize an existing Access database to Microsoft SQL Server®
- Dynamically update Microsoft Excel® spreadsheets from the database
- Migrate your Access database directly to the cloud using SQL Azure™
||Corrected Sample Files
Accompanying text on page 28 and in figure 1-43 reference an intentional error
that is supposed to be included in the companion code.
The intentional error in fact does not exist in the companion code.
The intentional error was supposed to be:
If lngPosSpace <>0
|The sample database has now been corrected, my thanks to Tom Fulmer.
In the modRST_TableRecordset() code, the With rst sections have rst.Seek statements.
Shouldn't the rst be omitted ? Also, top quarter of p. 190, the With rst section has an
Inside a With rst....End With block of code you do not need to prefix a recordset operation such as .MoveNext by stating
the name of object for example rst.MoveNext.
At the bottom of page 192 inside the With statement the line rst.MoveNext can also be written .MoveNext and
near the bottom of page 212 the line bk = rst.Bookmark can also be written as bk = .Bookmark
The sample database has now been corrected, my thanks to Robert Lundquist.
Building Access Applications with SQL Server Databases - 9th August 2011
The best way to get an overview of how to develop with an Access application linked to SQL Server
and use the associated tools is to watch someone building solutions. In this session we will
be demonstrating the construction of DSN's, linking tables, views, and using stored procedures
and views in pass-through queries. This will include a discussion of the benefits in using SQL Server Schemas
and Synonyms. Following this we will look at techniques for using local temporary tables, SQL Server
temporary tables and resolving performance issues.
Presenting on behalf of Microsoft at the TechDay in London - 2011
This video will provide an introduction to placing an on-premise SQL Server database into SQL Azure and focus on how existing
Office Applications used for BI and Application Development can continue to function when directly connected to SQL Azure.
We will share our own experiences of assisting companies in moving the data, developing multi tenanted solutions,
managing security and refining the application design.
The companion content on the books website should be used for all downloads of the sample databases. Any updates will be posted in this area.