Coding Changed (1 Viewer)

[AnnaFoot]

Hello,

I have recently noticed that the code i used to be able to use:
dim r as recordset
dim q as querydef

can no longer be used and now i have to define all my recordsets and querydefs as objects. I have accessxp, and used to use access97. It is possible that all my previous programming i began in 97, and then upgraded the database and continued in xp. However now, in xp i can't use the recordset or querydef definitions. I have read that using object causes variables to be "bound late" which isn't as efficient, but what is really annoying is that the fill-in capacity where what you are trying to type is guessed no longer works, and i hate typing!!

Have i inadvertently picked something in options, or is this the life of xp?

Anna

 

[sambo]

In your VBA Code Window..
Click on Tools->Reference
Make sure the DAO 3.6 Library is checked.

From now on you will have to Dim your DAO objects like this..

Dim rst As DAO.Recordset, qdf As DAO.Querdef

--- or --

I think you can probably just uncheck Active Data Objects Library from the References Libraries.

For more help read up on the differences between DAO and ADO style programming.