INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Access 101

Receiving "Errors" when using common functions in Access 97 by rhicks
Posted: 5 Jul 00

Question: Access 97
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.

You more than likely have a "Library Reference" problem on the machine giving you the error.
On the problem machine open a module in design view, click the Tools button in Access main tool bar, then choose References. In the References list you will see a checked reference that has "Missing" message attached to it. This is the one causing the error. Uncheck the culprit and the problem should be cleared up.

Most of the time the problem originates from the machine where the Access app is written on. I have found this is commonly caused by someone using non-standard activeX controls and other components that are not basic to Access. If you play with an activeX component then even if you delete it from your application the library reference will still be loaded in the current app unless you uncheck the reference. Thus when you install the app on another machine the result will be a library reference error. Unless you are doing something exotic there normally should be only three references checked. For Access 97 these are:

Visual Basic For Applications
Microsoft Access 8.0 Object Library
Microsoft DAO 3.51 Object Library (version can vary)

If you are doing some things with Excel through Access you will also have an Excel Library check also. If you have others checked they can very well cause a problem if the other machines do not have the libraries registered on them. I hope I have explained this clearly enough. I too have encountered this problem in the past.

Good Luck
RDH

Back to Microsoft: Access Other topics FAQ Index
Back to Microsoft: Access Other topics Forum

My Archive

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close