getting a can't find library error on simple code.

[CTOROCK]

I am getting an error message on a form. It says something about not finding a library. I click on help and it says it can not find VEenLR.hlp to help me. The application works on my computer but not on others. The funny thing is that it used to work before all the time. But when I most recently copied a new version from my machine and downloaded it on other peoples computer, it fails and it fails when all I'm doing is this:

Private Sub Form_Open(Cancel As Integer)
DoCmd.Maximize
Txt24Date.Value = Date - 1
Txt48Date.Value = Date - 2
Txt48PDate.Value = Date - 3
Txt24PendingDate.Value = Date - 1
Txt48PendingDate.Value = Date - 2
End Sub

It doesn't know what to do. Anyone suggestions or advice? "The greatest risk, is not taking one."

 

[FancyPrairie]

Check your references for the database. Then ensure that the libraries (dll's, ocx's) exist in the same location on the user's machine.

 

[Redcatcher]

Check out the version of Access under which the mdb file was created and the version of Access on the PC's you are trying to use it on. Are the versions different?

 

[scking]

This is probably the most asked question on Access forums. When you develop and application on a machine your application uses references to object libraries it needs to perform its job. For instance, a dll file contains the functions to allow VBA to function properly. The references are contained in the application. When the application migrates to another machine, or your own machine environment changes, these referenced objects may not be present or be present in a different location on the machine then the application will inform you by the error you have received. The way Microsoft explains it, when Access looks for referenced object when it can't find one, all those libraries which follow the 'MISSING' reference are not used. So it may say it couldn't perform a simple function like a Left$ or whatever.

To correct this simply open a module in design mode, select Tools\References and uncheck the reference listed as 'MISSING'. If for instance the application was developed with a reference to the 'Microsoft Outlook 9.0 Object Library' and you are using it on a system with Outlook 2002 then you would uncheck the reference to 9.0 (which probably doesn't exist on the machine) and browse to 'Microsoft Outlook 10.0 Object Library' which you would then check.

----------------------
scking@arinc.com
Life is filled with lessons.
We are responsible for the
results of the quizzes.
-----------------------