VBA to save a Query

[Guest]

I am using Office 2003 on Windows XP. Is it possible to create a stored
procedure (or saved query) using ADO? If so, can someone please post example
code?

If not, can someone please post example DAO code to do it?

Thanks a lot.

 

[Granny Spitz via AccessMonster.com]

Is it possible to create a stored
procedure (or saved query) using ADO? If so, can someone please post example
code?

Example code here:

http://groups.google.com/groups?as_...as_usubject=&as_uauthors=&lr=lang_en&safe=off

 

[Kc-Mass]

Something like:

Dim qdfExport As QueryDef

Dim strActive_SQL as String

Dim Db as Database



strActive_SQL = "SELECT * FROM YourTable "

Set db = CurrentDB

Set qdfExport = DB.CreateQueryDef("YourQueryName", strActive_SQL)





Kevin C