Recordsets

[moye]

I created a database in access from scratch for my bail bond business. My question is that I can’t get my database to edit recordsets through vba code. When I am setting up my variables (ex. Dim dbs as Database) it won’t come up with database as an option.

But I can create a new database using a wizard and then delete everything out of it (forms, reports, modules, queries) then start over and I can get it to come up with Dim dbs as Database.

So there is something that the wizard is doing that I didn’t do, so if somebody could please help me it would be much appreciated.

 

[jes]

Hi Moye,

All you should need to do is to ensure you references are set up correctly. Through the code window select Tools->References and then check 'Microsoft DAO 3.5 Object Library'.

That should sort it,

Jes

 

[moye]

Thank you so much. That fixed it.