Pages

▼
Friday, 27 April 2012

Hiding the Navigation Pane with VBA

›
Once you have created an Access Database Application to be used by other people, it may well be important for you to prevent users from gai...
1 comment:
Friday, 30 March 2012

Calculating a Future Date with the DateAdd Function

›
If you read my blog last week you may have seen the sample Lending Library Database that I created to demonstrate a working example of the ...
Friday, 23 March 2012

The DAO Recordset in Action - An Example Lending Library Database

›
Last week I wrote a post on How to Access Data with VBA Code .  Instrumental in this was the use of the DAO Recordset Object.  Through usi...
1 comment:
Friday, 16 March 2012

Accessing Data with VBA Code - Introducing the DAO Recordset

›
This post is all about how we can use VBA code to access the data stored in our database.  By access, I mean, being able to add , find , ed...
Friday, 2 March 2012

Calculating Questionnaire Percentages using a Multi-Level Query

›
Last Saturday I received an interesting question from Ogwang Denis on my Access Tutorial Facebook page. He had created an Access Database ...
Friday, 24 February 2012

Using Calculated Fields in Queries

›
Queries play an important part (in relational database design) in pulling information from different tables together. Consider the Many to ...
Friday, 17 February 2012

More on DoCmd OpenForm: Control Form Opening Part Two

›
Last week I blogged about how to Control Form Opening using the  DoCmd OpenForm  method of VBA.  I covered the DataMode and OpenArgs param...
Friday, 10 February 2012

Control Form Opening: DataMode, OpenArgs, and the DoCmd.OpenForm Method

›
Lets imagine we have an employees form to add and edit our employee records.  The form is accessed via the database switchboard which conta...