Combo Box working for one user but not another

  • Thread starter Thread starter Amy Adams via AccessMonster.com
  • Start date Start date
A

Amy Adams via AccessMonster.com

I am having a combo box problem with my database. Combo box code is simple:

Private Sub Combo40_AfterUpdate()
Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[PlanID] = " & Str(Me![Combo40])
Me.Bookmark = rs.Bookmark
End Sub

This code is working for one user on their computer, but not for another
user on a different terminal. They are both using MS Access 2000. One
user can use the combo box fine, while another user receives this error msg
"Compile Error: Can't find project or library".

I have compiled database and can use combos fine on my computer. Also both
users are working with the most current database.

Any advice?

Thanks!

Amy
 
Missing library errors usually mean just that. On the PC with the error, open
the code window and click on Tools>References. Look for any marked MISSING.
That PC may not have the same version of a library as your PC. For instance,
they migh thave DAO Object libray 3.5 and you used 3.6.

As a temporary fix, add the latest version of the missing library and
uncheck the missing one.

Long term ifx is to make sure all the service releases are installed on
everyone's PC.
 
Eureka! I figured it out. User needed to check the MS DAO 3.6 in the code
window under references/tools.
 
Back
Top