Message box

  • Thread starter Thread starter Garyj
  • Start date Start date
G

Garyj

Guest
How do I have a message box to pop up automatically 4 days before the scheduled date.

Example:

Scheduled date: 12/31/03
Message pops up: 12/27/03

Can anyone help me
Thank you
 
In order to have code run, it must be triggered by an event. How often do you "start" your Access application? If you start it at least once a day, you can have code at start up check the current date and display the message. If you intend on leaving the database running all the time, then you could also have some code embedded in your other database code that makes a periodic check to find the current date. You could also have your system run some type of batch file when you log on each day to open your Access database to ensure it gets run once a day.
 
Thank you for your reply.

My database will start at least once a day by the users. I tried to have a message popup 4 days before the schedule date but I wasn't sure how to write the date part in the code. Could you help with an example.

Thanks
 
Heres a basic example using a query to find criteria - Without seeing exactly what you want it is hard to write code for you.

Hope this helps

Louchey
 

Attachments

Message Box

I was unable to open your database. I keep getting the message unrecognizeable database. I am running Access 97

Any sugguestions
 
Sorry - I created it in Access 2K !!!!
I'll see if anyone is running 97 @ work.
 
louchey said:
Sorry - I created it in Access 2K !!!!
I'll see if anyone is running 97 @ work.
I'm sure you have the option to save as a previous version
 
Message Box

I tried out your example and it seemed to work OK. But I need that same message to popup automatically through code using the system clock as a referrence. How would I do that?

thanks
 

Users who are viewing this thread

Back
Top Bottom