Question:
[color red]I'm receiving #Name? error when using the Date() and other common functions when I install my db on another machine. It works OK on my machine.[/color]
'Standard' functions that seem to not work:
TRIM
LEFT
RIGHT
FORMAT
DATE
Reason: libraries on other users' machines may not be referenced properly
The three libraries that should be referenced are:
Visual Basic For Applications
Microsoft Access 8.0 Object Library
Microsoft DAO 3.51 Object Library (version can vary)
Fix:
Either manually reference the standard libraries on that user's machine (see Using Microsoft Access to Refresh a Reference in the article), or copy this simple code from the article and run it with an autoexec macro when the users open the front-end (see Automatically Refreshing References by Using Visual Basic for Applications in the article). It will referece each library properly. I am not a big VBA Programmer and I did this easily. It's simple.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.