Hi everyone, here's my problem. I 2

[AndrewWolford]

Hi everyone, here's my problem. I have created a database that uses a lot of VB. It contains some forms, some tables, and a bunch of various functions that I've written. There are about 4 or 5 users of the database and the problem occurs when one of them goes to use it. It works fine on my machine, however when someone else tries to use it on their machine it errors out. Specifically, it errors out when they click the button that converts dates from 20011231 format to 12/31/01 format. For some reason, when their machine runs this function, and it gets to either a "left", "mid", or "right" function it errors out, saying something to the effect of "unrecognized function, Library not recognized or not installed."

Left, Mid, Right functions *should* be built in functions of VB and I do not understand why everyone else's version of Access doesn't understand these build in commands. Is it possible that I have an upgraded version of Access beyone what they have? Is there a way to add various library's to Access? If so, does anyone know what Library I would need to add and where to get it? Our office uses Access 97 on Windows NT. The only thing I can think of is reinstalling Access on their machines... Please help! Thanks,

Andrew

 

[FancyPrairie]

Check the references to make sure they are the same on your machine as the users. If they are, then check to see if the version number of the files referred to in References is the same. Chances are that when you check the references on the users' machines, you will see the ones that are missing.

 

[carmo]

Here is your problem: You are missing the reference library that support these functions. This usually happens with the mid$ left$ and right. In order to add the required reference library, go into the code view of any form. Once you are in the code, click on "Tools" from the file menu. Then choose "References". This will give you a list of the reference libraries that you are currently using. To support these text functions, you must go through the list andmake sure you check off "Visual Basic for Applications" and "Microsoft Visual Basic for Applications". Let me know if this works.

Carmo

 

[AndrewWolford]

Thanks for your quick reply! I've never had to check the references before, how do I do that? Assuming this is the problem, is there a way to "upgrade" their references to what I have?

Again, thanks for your reply,

Andrew

 

[carmo]

ALSO, if there are any checkboxes called "MISSING", make sure that you uncheck them.....and make sure that you repeat the same steps for each client.

Carmo

 

[AndrewWolford]

Thank you both for your replies, I've checked to see what reference libraries are checked on my machine, I'm going to go look to see what every one else has checked now. I have a question about your MISSING comment. I assume that means that a reference library is missing that Access is trying to reference? If I uncheck that box will that mean that any function I've written that uses that reference library will no longer work?

-Andrew