Forum Discussion
Regarding macros and function in Microsoft access
Hi, I have created one function in Microsoft access and I am trying to run that function using autoexec macro, but I am getting the error as shown below even if I am using the same function name tha...
It does indeed say that and I'm guilty of explicit declarations whenever possible.
Incidentally, when Option Explicit was added to the OP function I was not able to get the code to compile.
The following line of code was flagged.
DoCmd.DeleteObject Table, "data"
It compiled when changed to:
DoCmd.DeleteObject acTable, "data"
I don't recall seeing the naming conventions of the Function and Module.
That can result in the same exact error message.
By chance, did the OP name the Function the same name as the Module?
Incidentally, when Option Explicit was added to the OP function I was not able to get the code to compile.
The following line of code was flagged.
DoCmd.DeleteObject Table, "data"
It compiled when changed to:
DoCmd.DeleteObject acTable, "data"
I don't recall seeing the naming conventions of the Function and Module.
That can result in the same exact error message.
By chance, did the OP name the Function the same name as the Module?
After intentionally naming the Function and Module the same exact name and running the Autoexec macro I was able to force the same error message as OP.
Assuming the OP has the same issue, it should throw Error 2425.
