Aug 16 2007, 02:28 PM
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".
Aug 16 2007, 02:32 PM
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.
Aug 16 2007, 02:56 PM
Is there a code that would close the form after the append is completed?
Aug 16 2007, 03:01 PM
DoCmd.Close acForm, "YourFormName"
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here