Full Version: MS Access Append Status Box
UtterAccess Forums > Microsoft® Access > Access Forms
Jeremiah32
I have an append query that takes several minutes to complete. Is there a way to display a msgbox saying "Working" and when the append is complete to say "Update Complete".
freakazeud
Hi,
Create a custom form with a label on it that says what you want. Then open the Form before you execute the query and change the label's caption to whatever you want after it has run. You could also then reveal a close button that you had hidden while the query was running.
HTH
Good luck
Jeremiah32
Is there a code that would close the form after the append is completed?
freakazeud
Sure...:
oCmd.Close acForm, "YourFormName"
HTH
Good luck
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.