Contact US

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.

Students Click Here

Microsoft: Access Other topics FAQ

Error Messages

3075-Function Not Available by GingerR
Posted: 24 Jul 01

Piggy-backing on Access 101 article e:

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:

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)

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.

Here is the article with the fix


In fact it runs so fast that i've never seen the message pop up to the user.....

Note for Access 2000:
The error code is 3085 so you might want to change the If-Then code to:

if Err.Number = 3075 or Err.Number = 3085 Then

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

My Archive

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