Question: 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.
'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.