Category Archives: Tutorials

How to check for missing references

How to change a text box to a combo box (Won’t work with Data Access Page)

How to add a table level validation rule

How to add a group sort to an existing report

How to create a custom shortcut menu

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