There maybe occasions where you will need to display a message to inform your user's that they must wait for an action or process to be completed.
You may want to display the text "Database Loading" whilst Access initializes a large database, or display the text "Please Wait" whilst Access runs a long query.
To display a status message follow the details below:
If you are using the form as the opening form, prior to your database loading then save the macro as AutoExec, if you are using this to attach to a long query then save the macro as mcr_Test.
Macro Name | Action |
---|---|
mcr_Test | Open Form |
RepaintObject | |
OpenQuery | |
Close |
mcr_Test | Actions |
---|---|
Open Form | |
Form Name | Please Wait |
View | Form |
Data Mode | Read Only |
Window Mode | Normal |
mcr_Test | Actions |
---|---|
RepaintObject | |
Object Type | Form |
Object Name | Please Wait |
mcr_Test | Actions |
---|---|
Open Query | |
Query Name | "Name of Your Query" |
View | Datasheet |
mcr_Test | Actions |
---|---|
Close | |
Object Type | Form |
Object Name | Please Wait |
Save | No |
If you wish this form to be opened as your database is loading, you will name the macro as AutoExec as this is the first thing that runs on opening of the database.