Access 97 Conversion Error

[WOTRAC]

I've recently developed an Access 2002 database for storing contact details.

However the people I have been developing the database for, use Access 97 SR-1. The actual conversion went correctly and the database will infact open on the clients network, however on the one form (where contact details are stored) i have put several lines of VBA code behind each and every text box. The code looks like this:



Private Sub FirstName_Exit(Cancel As Integer)

If IsNull(FirstName.Value) Then
FirstName.Value = " "
ElseIf FirstName.Value = " " Then
FirstName.Value = " "
Else
FirstName.Value = LTrim(FirstName.Value)

End If
End Sub


This code works fine in Access 2002, but after converting to Access 97 and copying to the clients machine, it errors on the LTrim Function.

The message recieved is: 'Cannot find project or library'

Could anybody suggest a solution to this problem?
Ad

 

[hymn]

try
Check your references for Microsoft3.6 DAO Object Library
Go into some of your code then
Tools/references if it is not there click on it or if there is a missing reference find it and click on it

Hope this helps
Hymn

 

[RickSpr]

LTrim is not a DAO function, so I wouldn't expect that to solve your problem.

LTrim is a VBA function. For Access 97, VBA is in the library VBA332.DLL. It should be the first item in your References list. I'm sure you have "Visual Basic for Applications" there, but it may not be the Access 97 version.


Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein