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

Error Messages

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

Piggy-backing on Access 101 article e:

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.


Here is the article with the fix

http://support.microsoft.com/support/kb/articles/Q194/3/74.ASP

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

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