Forum Discussion
Accessing excel files using microsoft access
Hi I am trying to automate excel file using Microsoft access. I am using macros for that, but I am not able to get the required output. I have created one public function in microsoft access and no...
One common reason for that particular error is that there is a missing reference. Does your code compile?
how to check whether my code is getting compiled or not
Open the VBE and select Debug. Then click on "Compile YourDatabaseNameAppearsHere"
If there is a problem, it'll quickly throw an error.
Also look for missing references here:
Any missing or incorrect references will be flagged as "Missing".
George HepworthI have checked and compiled but there is no error and no missing references is there.
- Where is the function located, in a standalone module or in the class module of a form?
If the latter, you'll need to add that form reference as part of the call to the function. Better to have it in a standalone module instead.