Access MVP (2010-2015)


Changing a Label Caption on a Report

If you do Quotes and Invoicing (or Purchase Orders and Invoicing) they generally share the same layout, the only difference being the Label identifying them. Rather than creating to reports you can change the Label Caption depending on which Form you are opening it from.

Step 1

Create the Report and for the Label Caption […]


Data Models

Probably the hardest part of designing a database is constructing normalized tables. Get them wrong and everything else is down hill… you can’t get the Forms to do what you want and the Reports just don’t work. Let’s see if any of these can make your job easier…

Clubs (or Associations)



Grocery List […]


Procedure View vs. Full Module View

While developing you may find yourself in the VB Editor adjusting the Function for a Control or the Form itself. When it opens you have to hunt down where the cursor is flashing, even though you have clicked the After_Update event for a specific control. There’s an easier way…

When you click the Build button […]


Access 2016 Runtime now available

“The Microsoft Access 2016 Runtime enables you to distribute Access 2016 applications to Users who do not have the full version of Access 2016 installed on their computers.”

To download click here…