Category Archives: Any Access version

Why Excel has a problem when using code in access

When you use code to refer to Excel (and other programs as well) you need to be careful not to use any code that does not refer back to the instantiated application object. If you do so then you will … Continue reading

How to refer to subforms in control sources

In our other tutorial, we saw how you can quickly, and easily refer to subforms within VBA code. Referring to subforms in control sources must take a slightly different tack. Subform syntax is actually fairly simple, but there are quite … Continue reading

How to Use a Table to Exclude Data From a Query

How to use a function in a query

How to use a form reference as criteria in a query

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