How to set a subform control source by code

How to set a breakpoint in the code window

How to remove lookups at table level

How to show dates in text but sort by number

How to put controls on the tab control

How to Find and/or Change VBA Project Name

Occasionally you may find the need to check to see what your VBA project name is for your database. Typically it can, if named with an Access Reserved Word, cause problems with your code as it will return an error … Continue reading →

How to Create a Multi-Field Index

Easy way to remember how to refer to subforms

Subforms, subforms, subforms… It is a word that generates fear into the sturdiest Access developer. How do you reference a control on a subform? How do you reference a subform to requery it? How do you reference a subform so … Continue reading →

Change Recordsource From a Table to a Query

Are data stored in any particular order in tables?

There is a common misconception amongst Access users that the data is stored in the tables and is stored in the order in which the data has been input. That is a view that is very, very wrong. So, how … Continue reading →