Message box

[Garyj]

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

 

[dcx693]

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.

 

[Garyj]

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

 

[louchey]

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

 

[Garyj]

Message Box

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

Any sugguestions

 

[louchey]

Sorry - I created it in Access 2K !!!!
I'll see if anyone is running 97 @ work.

 

[Rich]

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

 

[louchey]

Thanks Rich - I always forget about that.

 

[Garyj]

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