Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to creat a Macros
- Thread starter Parula
- Start date
tlbroadbent
MIS
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."
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question