VB COMPILE ERROR! Can't find Project or Library. HELP!!!

[kjenkinz]

I just installed XP and now when I try and run my old VB code is MS Access 2000, I get this error ---->

Can't find Project or Library.

Anyone? How can I fix it?

 

[hymn]

It looks like a reference is missing, Look in your references to see which one is missing

Hope this helps
Hymn

 

[kjenkinz]

Hymn, you were correct, there was a missing reference, but I corrected! Now when I run it, I get a runtime error 3001. It is telling me I have an invalid argument. Impossible, I have run this code every other week for the last three years.

CODE (where it is hanging up)

qd.sql = sql
qd.execute

 

[hymn]

if its old code you might need the "Microsoft DAO Object Library" Reference

Hope this helps
Hymn

 

[kjenkinz]

Thanks again hymn, but I followed your advise, clicked on the Microsoft DAO Object Library 3.6 reference and I even added Dim MyRst as DAO.Recordset to my databse and still the same error.

 

[hymn]

without the full code showing I cant help you it might be better to start a new thread and see if someone else can

Hope this helps
Hymn