HELP! pop-up reminder form within access

urfriend

Registered User.
Local time
Today, 09:53
Joined
Oct 26, 2012
Messages
21
Hello everybody,
I need to make a pop-up reminder that will open once the user double-clicks the database to open it. That reminder should be related to a certain event that is due soon and this reminder should display a message stating the time remaining for the due date PRIOR to opening the db.
I searched for such code and found one in the following link(without spaces), but it didn't work with me.

h t tp : / / w w w . d a t a b a s e d e v . c o . u k / r e m i n d e r s . h t m l
Is there any chance some one would care enough to help me build it??

THANKS
 
Could you give the condition that it needs to check? Basic idea would be to create an unbound Form with a Label and two buttons Ok and Cancel.. Make the label display the message the user wishes to see.. Make this Form the Default open from Options--> Current Database --> Display Form..
Then on the Form Load method check for the condition, if the condition is not met close the form, else wait for user input i.e. Ok or Cancel.. Make sense?
 
Here is something for you to get started with..
 

Attachments

Well, thanks for your concern
What I need is pretty close to the sample you sent me.

The addition I need is as follows:

There is some client whose installment due date is in a week's time.
Upon opening the db, I want the database to double-check the due dates entered in another form and, if present, would inform the user that there is a client (or a number of clients) whose installment due date is a week ahead, and continue to display such message until the form checked is modified that the client(s) has deposited the installment.
The message I want the user to see is:
There are (number of clients) whose installments due date is (number of days) ahead.
Would you like to view them?
Yes Later

----------
Thanks...
 

Users who are viewing this thread

Back
Top Bottom