Hi. With regards to the ambiguous name error, sounds like you may have two functions with the same name of fExecuteQuery. Did you name the module Module1?
You called it right. There were two modules with the same code. Now when I trigger Module1 fExecuteQuery....., results in a compile error. user-defined type not defined (these lines are highlighted when the error message dialog appears).
Function fExecuteQuery(strQuery As String, _
Optional intOptions As DAO.RecordsetOptionEnum = dbFailOnError, _
Optional blnReturnAuto As Boolean = False, _
Optional pdb As DAO.Database) As Long)
I got this before when the function isn't defined, but the function exists in Module1. I am looking right at it.