>>>>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
CLARC Services, Inc.
3500 Tamiami Trail
Port Charlotte, FL 33952
www.clarc.com(941) 743-0108
(800) 246-5488