Dialog box

[Guest]

Problem:
I have several events that copy data to and from the server - updating
native tables. This may take anywhere from 5 seconds to maybe 1 minute. Is
there a easy way to let the user no what is going on. Something like a
vbExclamation, or a custom form. Maybe it would load a form until access
wasn't busy.

Regards

 

[Frank Stone]

hi,
not sure if it will help you but you might look into using
the access status bar. see this site
http://support.microsoft.com/default.aspx?scid=kb;EN-
US;Q103404
good luck
Frank

 

[Graham R Seach]

Just create a small form containing a single Label control, whose Caption
property = "Working...Please wait."

Open the form before calling the database update, and close it when you've
finished.

I usually set the following form properties:
Scrollbars: Neither
RecordSelectors: No
NavigationButtons: No
DividingLines: No
AutoResize: No
AutoCenter: Yes
BorderStyle: None
ControlBox: No
MinMaxButtons: None
CloseButton: No
WhatsThisButton: No
PopUp: Yes

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia