How to creat a Macros

[Parula]

IS it always a good idea to creat a Macros for a append queries? If so can you explain how to creat a a macros?

 

[tlbroadbent]

Whether to use Macros to run append queries depends on the requirements. If you append records because of user input on a form, you don't need a macro. You can handle the code in the form.

However, I frequently use macros to run a variety of queries when I want to run an unattended process. For example, I have a database that is used to collect data from a variety of sources. Access is scheduled to run the update macro which runs several queries, macros and some VBA code.

It was not necessary to use macros. Everything could be handled in VBA code but that is the way I've chosen to do this process. Terry

X-) "I don't have a solution, but I admire your problem."