>>>>>I'm a VFP programmer but need to do something quick in Access VBA.
>>>>>
>>>>>I have 2 books that mention how to populate a temporary query or database with a select-sql command. Both of them say to dim db as database or dim qdf as QueryDef. However, neither "database" nor "querydef" is coming up in intellisense, and when I use it anyway it tells me that the user defined type is not found.
>>>>>
>>>>>Please help.
>>>>>TIA
>>>>>Joy
>>>>
>>>>Could you post your code? Perhaps your database and querydef are not being set properly.
>>>
>>>I've gotten it fixed--thanx to all for your help!
>>>
>>>JR
>>
>>Hi,
>>
>>So, how did you fix it?
>>
>>Igor.
>We didn't have many of the needed references (tools/References from a code window), such as Multi-dimensional ActivX Data objects, the ADO 2.1 library, the ActiveXPlugin, the MS Jet & Replication Objects 2.5 library, VBA Extensibility 5.3, etc. Not sure which one actually allowed us to use the commands needed for the SQL population and the database & querydef commands, but it sure made life easier when we added them!
>
>Again, thanks for your help,
>Joy

Hi Joy,

At this point if you would set up reference to Microsoft DAO 3.6 Object Library and move it up, so it stays before reference to Microsoft ActiveX Object Library 2.X , it would help.

Just my 2 cents.