I don't want the code to keep running.
I want it to wait until all the records in the insert have been processed.
In another part of the app I need to insert the results of the query into a table as I use automation to get access to output a report as a snapshot based on criteria given at...
Im totally lost
Is there something I need to dp to pause my code from executing until my Insert query has finished
the following works - during Debug line by line or if I pop in a msgbox after it.
dont try to validate the Insert into statement - IT DOES WORK
strSQL =
INSERT INTO...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.