How to Create a Macro

[krishreddy]

hi guys,
I have three queries. They are TrafficAccident_Append,NameInformation_Append and Delete query.

These queries need to be executed in the following order.

1)TrafficAccident_Append,
2)NameInformation_Append

When the above queries are executed, the information is appended to the corresponding tables. Then
Delete query needs to be executed.

All these 3 queries need to be executed by just one click on the macro created for them.

So cud anyone tell me in step wise how to create a macro in order to execute these 3 queries one by one.

waiting for reply.

 

[MichaelRed]

no one 'really' uses macros. the reasons are easily found searching here, there or most anywhere.

your 'soloution' needs to utilize a 'transaction', which again, can be found ...



MichaelRed

 

[ProgramError]

1 create new macro - in design view

2 in actions colomn combobox select 'openquery'
In the 'query name' combobox at the bottom of the window select the name of query you wish to run.

3 go down to the next row in the action colomn list and do the above (2) for all the queries you wish to run

4 save macro

5 name macro

6 create a control on a form to run the macro using the controls 'on click' event (or use the wizard)


Ian Mayor (UK)
Program Error
Programming is 1% coding, 50% error checking and 49% sweat as your application bombs out in front of the client.

 

[randy700]

Or, as MichaelRed indicated, run the queries from your button click event...

Private Sub cmdButton_Click()
   DoCmd.SetWarnings False
   DoCmd.OpenQuery "TrafficAccident_Append"
   DoCmd.OpenQuery "NameInformation_Append"
   DoCmd.OpenQuery "YourDeleteQuery"
   DoCmd.SetWarnings True
End Sub

Randy

 

[mp9]

If you really must use a macro, consider using a scheduling tool to automate the process, e.g. Handy Access Launcher

http://www22.brinkster.com/accessory/resources/001.shtml

 

[MichaelRed]

randy700 ... That is NOT a transaction. Please refer to the handy and ubiquitous {F1} (a.k.a. Help).




MichaelRed