 |
|
||||||||||
|
M.A.R.S |
||||||||||
|
This forum is for the sole use of MARS users. ChristianSteven Software will not accept any responsibility for the contents.
|
||
| Return to Website | ||
 First |
 Prev |
 Reply |
 Forum |
Next  |
Last  |
| Viewing Page 1 of 1 (Total Posts: 4) |
| Author | Comment |
Ari Smith
Dec 13, 05 - 12:12 PM |
Multiple Queries / Macros
I need to be able to run multiple queries/macros under a single schedule before I can output any reports. Is there to do this in MARS ? |
|
Mars Support
Dec 13th, 2005 - 12:40 PM |
Re: Multiple Queries / Macros
MARS cannot yet run Macros. My suggestion would be to set up a custom task to run BEFORE the report (you will be presented with this option at the end of the custom task setup). Use the "Execute SQL Script" task and write a standard SQL script to do the database manipulation you require. To see instructions on Custom tasks, click the "How To...Demos" button on the task pane (on the right hand side of the MARS screen) and view the demo on Custom Tasks (item 6). You may also find "Automation Schedules" (item 3) of interest as it gives you further options to "chain" more than one schedule together. |
|
Kieran Wood
Dec 13th, 2005 - 12:59 PM |
Re: Multiple Queries / Macros
To run a Macro you can write a custom action to run msaccess.exe /x [macro] Starts Access and runs the specified macro. Another way to run a macro when you open a database is to use an AutoExec macro. You can set up your Macro to also run your query. Put a delay in the custom action of x seconds to allow the database to load and the macro to run and actions complete before the report actually gets run. Hope this helps 
|
|
Joel Klein
Dec 23rd, 2005 - 4:56 PM |
Re: Multiple Queries / Macros
Download the Latest version of MARS. It now has the ability to run Macros as Custom Actions. |
| First |
Prev |
Reply |
Forum |
Next |
Last |