IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 3 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Databases Forum / Different approach is DoCmd.RunSQL
Post #152,627
by rickw
4/26/04 12:48:43 PM
Reply
New Different approach is DoCmd.RunSQL
You can dynamically generate the SQL string, which solves the issue of specifying the name of the output table. If you want you can use the QBE window to generate the SQL for you; just write the query the way you want it and look at the SQL view (same place as design view or data view).
FAQ! We're scrod!
Post #152,653
by jbrabeck
4/26/04 2:46:40 PM
Reply
New How I've got it running
Query 1 does a make table. Get run first.
Query 2 does an append. Same query different parameters, gets run as many times as necessary.

Upon completion, auto export to an excel spreadsheet. Spreadsheet is named "Business Function" + DR TEST + "Start date of test". This spreadsheet is then sent to the Disaster Recovery Center for them to run. (Spreadsheet is schedule of jobs to run during the disaster recovery test).

Seems to work. We are running another test this week. Will see how it goes...
     How do I pass parameters to a Query in Access - (jbrabeck) - (12) - April 19, 2004, 01:11:31 PM EDT
         Re: How do I pass parameters to a Query in Access - (JayMehaffey) - April 19, 2004, 01:40:00 PM EDT
         For *very* simple stuff - (FuManChu) - (7) - April 19, 2004, 02:06:16 PM EDT
             Here's the SQL code. - (jbrabeck) - (4) - April 19, 2004, 03:20:01 PM EDT
                 Reformatting a bit - (ChrisR) - April 19, 2004, 03:53:17 PM EDT
                 Are all of those date parts from a single date? - (FuManChu) - (2) - April 19, 2004, 04:40:43 PM EDT
                     More - (jbrabeck) - (1) - April 19, 2004, 04:55:09 PM EDT
                         Sorry - (JayMehaffey) - April 19, 2004, 05:19:22 PM EDT
             Re: For *very* simple stuff - (andread) - (1) - April 19, 2004, 03:21:26 PM EDT
                 Or "query by form" -NT - (mmoffitt) - April 19, 2004, 04:38:56 PM EDT
         Found a way - (jbrabeck) - April 20, 2004, 02:24:10 PM EDT
         Different approach is DoCmd.RunSQL - (rickw) - (1) - April 26, 2004, 12:48:43 PM EDT
             How I've got it running - (jbrabeck) - April 26, 2004, 02:46:40 PM EDT

All artists are potentially a victim of their desire to be unique.
62 ms