Message Box In Access Forms

  • Thread starter Thread starter EddiesVoicebox via AccessMonster.com
  • Start date Start date
E

EddiesVoicebox via AccessMonster.com

Hi everyone

Quick question (i hope)
I have a process in one of my forms that populates the fields with various
information using dlookups against a select query. However this takes
anything up to 20 seconds to run (me and SQL dont get on very well at the
moment so im sure this is the long way round but it works). What i would like
is a little pop up box that just says please wait, i dont want any buttons on
it and would like it to remain until say a certain field has been populated.
If people start randomly clicking all over the place it has been known to
start causing problems.

Any help would be greatly appreciated

Regards

EddiesVoicebox
 
Just create a little form containing a label with the appropriate caption.
Set its BorderStyle property to Thin or None. Load it just prior to calling
the query, and unload it just after.

DoCmd.OpenForm "frmPleaseWait"
DoEvents
' Functional code here
DoCmd.Close acForm, "frmPleaseWait"

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
Back
Top