• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 6. INTRODUCING ACTIVEX DATA OBJECTS > WORKING WITH QUERIES USING ADO

WORKING WITH QUERIES USING ADO

After working with recordsets, the next important task that will probably be necessary is to be able to manipulate queries from within VBA using ADO. To get started, see how to create a straightforward query and then open a recordset off it.

Creating a New Query

When creating and working with queries, you will use the ADOX Command object's CommandText property off the Catalog object:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint