Any easy solutions or thoughts?
Do you have the following two line at the top of every module (form and standard)?
Code:
Option Compare Database
Option Explicit
The "Option Explicit" line requires every variable to be declared. In the IDE, you can set an option to automatically add "Option Explicit"...
TOOLS/OPTIONS ...then in the Editor tab, check the 2nd option "Require Variable Declaration". This will only add the line to NEW modules. For existion modules, you will need to manually add the line.
In the declaration statements for "Database" and "Recordset", you should specify the library
Code:
Option Compare Database
Option Explicit
Sub SomeProcedure()
Dim d As DAO.Database
Dim r As DAO.Recordset
'Other code
End Sub