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