I agree with Doug.
It's *really* easy to open any code window, and choose Replace on the Edit
menu to replace:
As Recordset
with:
As DAO.Recordset
As you find other problem declarations, you can then do them as well, e.g.
replace:
As Field
with As DAO.Field
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
news:(E-Mail Removed)...
> Realistically, you should be typing DAO next to the declarations.
>
> Disambiguation is always a good idea.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "ISUTri" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>>I am currently running an update in MS Access 2003 of Access 2000
>> databases. For whatever reason every now and then the VBA Modules
>> reference list will automatically move the Microsoft DAO 3.6 to the
>> bottom of the reference list, breaking the updates. Can anyone tell me
>> why this is happening and what I can do to stop it? Other than typing
>> in DAO.(whatever) next to all of the objects?
>>
>> Thanks for your help
Similar Threads
