Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 290133 - Last Review: August 11, 2004 - Revision: 1.0
How to create a "Please Wait" message in Access 2002
This article was previously published under Q290133
Moderate: Requires basic macro, coding, and interoperability skills.
For a Microsoft Access 97 version of this article, see
96989Â
(http://kbalertz.com/Feedback.aspx?kbNumber=96989/
)
.
For a Microsoft Access 2000 version of this article, see
209608Â
(http://kbalertz.com/Feedback.aspx?kbNumber=209608/EN-US/
)
.
Sometimes you may want to display a status message to inform users that
they must wait for an action to be completed. For example, you may want to display the text "Please Wait" while Microsoft Access is initializing a database, running a long query, and so on. This article uses the sample database Northwind.mdb to show you how to create a "Please Wait" status message.
To display a status message in Microsoft Access, follow these steps:
- Create the following form that is not based on any table or query:
Form: PleaseWait
---------------------
Caption: TestForm
ScrollBars: Neither
Popup: Yes
Modal: Yes
RecordSelectors: No
NavigationButtons: No
Label
--------------------
Caption: Please Wait
Font Size: 18
- Create the following macro named Test1:
Macro Name Action
------------------------------------
Test1 OpenForm
RepaintObject
OpenQuery
Close
Test1 Actions
-----------------------------------
OpenForm
Form Name: PLEASEWAIT
View: Form
Data Mode: Read Only
Window Mode: Normal
RepaintObject
Object Type: Form
Object Name: PLEASEWAIT
OpenQuery
Query Name: Order Details Extended
View: Datasheet
Close
Object Type: Form
Object Name: PLEASEWAIT
Save: No
- Run the macro. Note that the PleaseWait form opens. As soon as the query is finished processing, the form disappears and the query results appear.
APPLIES TO
- Microsoft Access 2002 Standard Edition
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate