Create a macro to run a set of processes

[debsamguru]

Hi,

I have a set of processes that I would like to put into an automated switchboard. The processes are as follows: -
1. Run a make-table query to select a list based on a month.
2. Run a query for each month using the previously created table and another static table.
3. Run a report on this query and save it to a pdf.
4. Run a Word mail merge using this query data as input.

I would like to set up a switchboard that would have each month as a button (or even as a drop-down) which will perform this automatically or as automatically as it can.

I have played with buttons, commands and macros and have managed to do bits of it, but can't seem to bring it all together.

Thanks in advance.

 

[apr pillai]

1. You can create a macro and sequence the actions in the same order in separate rows as you have mentioned.
2. You can place the name of the Macro in the On Click Event Property of the Command Button to Run the Macro when you click the Button.

All the actions you have placed in the Macro one after the other will be exectued in sequence.