Submit Button (1 Viewer)

[Zholt]

I need to create a button that will run several query's and macros simultainiously.

Thanks Zac

 

[Kiwiman]

Howzit

In design view of your form, add a command buttona and use the wzard to run a macro (under miscellaneous) i think. Select the macro you want to run.

In the selected macro, you can add other commands to run other macros \ queries, or you can add it in code to the generated vb.

 

[missinglinq]

Just be aware that Access will do just that, run them simultaneously! If any of the queries are dependent on any the preceding queries,for example, you may run into problems, because QueryB will run before QueryA has finished running. This can be usually be worked around by inserting a

DoEvents

command between running each query/macro.

 

[Zholt]

Somebody told me that you cannot run multiple queries also i an a total n00b with code

 

[Zholt]

Missing, where do i put the do events in the macro fields?

 

[Zholt]

Please could you reply this needs to be completed by tomorrow

Thanks Zac