How do I create a new query in VBA and save it to an Access Db?

geoaerocfi

Guest

Posts: n/a

3rd Aug 2008

I am trying to replace an exitsting query in a MS-Access 2007 database with
one that I've created in VBA code. I already know how to delete or rename
existing queries, but can't find any functions that create a new query.

« Update with Do Until rsTable.EOF allways leave one record "behind" | TEXT FORMAT IN BODY OF EMAIL USING SENDOBJECT »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
With a Query in Access 2007, How can I Create This Query	Terry	Microsoft Access	3	29th Apr 2010 05:43 PM
create Access .mdb template, save and reuse under different name	Arcee	Microsoft Access Database Table Design	12	18th May 2009 12:07 PM
Create/Save Query on the Fly	=?Utf-8?B?RWQgQXJkemluc2tp?=	Microsoft Access Queries	2	29th Oct 2004 08:05 PM
Programatically Create/Save a Query...	James Hunter Ross	Microsoft Access Queries	4	25th Jan 2004 08:53 PM
Query reformats on save in Access 2003 query builder	Mark	Microsoft Access Queries	2	1st Dec 2003 04:57 PM