Project Libraries

[sanders720]

I now have my application working on my PC. When I move to another PC and run it (on the server), Upon trying to do a "docmd.form.requery" I get the error
"Can't find project or library"
DAO 3.6 is loaded. I even unloaded it and reloaded it to the path. What else could be wrong?

Thx,

 

[sandyshoes]

Hi.

What version of Access are you using and is there a reason why you don't just use "me.requery"?

 

[KyleS]

Sanders,
To go off what Sandy asked, if you have Access 2000 (if you're using DAO 3.6 then you should be) then you'll have to change your Declaration statements...

Dim rst as DAO.Recordset versus Dim rst as Recordset, since ADO is the default for Access 2000 the second example will automatically try and create an ADO variable versus a DAO var. Kyle :