A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Pop-up Box with a reminder



 
 
Thread Tools Display Modes
  #1  
Old March 10th, 2010, 02:08 PM posted to microsoft.public.access.forms
Jessica
external usenet poster
 
Posts: 299
Default Pop-up Box with a reminder

I currently have a form for entry of clients information (OOH Data Entry). In
that form i have two fields one call last physical date and the other last
dental exam. I would like a box to pop-up reminding then to enter the most
current date for the clients last physical and dental exam to the database.
Since they are forgetting to enter the most recent date, we have dates from
07" and a physical and dental should be done every year. How can i do this in
a form? I would really like to use that same reminder for two other fields.
Maybe is possible to have just one pop-up reminding then to update the
following fields. 1. Last Dental 2. Last Physical 3. Does the Client require
ongoing MH Services 4. Does the client receive MH Services. As soon as they
open the form.

  #2  
Old March 10th, 2010, 03:29 PM posted to microsoft.public.access.forms
ghetto_banjo
external usenet poster
 
Posts: 325
Default Pop-up Box with a reminder

here is a very basic message box code:


Msgbox "Please remember to update blah blah blah", vbOkOnly


You could place that code in the Form's On Open Event to pop-up when
the form is opened, or in the On Current Event which would show the
message pop everytime they changed records. Depends on your choice
and how the navigation between records is setup on your form.
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:51 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.