Reminder

[Tara]

I'm not sure I'm posting this in the right spot, but here
goes...I would like to design something to remind users
to run a certain report every thirty days. Something
like a flashing label that is only visible every 30 days,
so that when the user opens the database, they get this
visual reminder. Is this possible? Thanks in advance
for any help!!

Tara

 

[Rick B]

You could add a field to a commonly used form and make the field visible by
comparing the "day" part of current date to your due date.

You could also have code run when the database is opened that checks the
date and pops up a form if it is near the end of the month. The form could
have a warning on it.

If you want to turn this off once the report is run, you would need to store
the run dates for the report in a table. If you want the warning to turn
off for each employee as they run it, the table would also need to track the
userid.

This could be as simple or as complex as you'd like it to be.

Post back once you get a plan if you need help implementing it.

Rick B



I'm not sure I'm posting this in the right spot, but here
goes...I would like to design something to remind users
to run a certain report every thirty days. Something
like a flashing label that is only visible every 30 days,
so that when the user opens the database, they get this
visual reminder. Is this possible? Thanks in advance
for any help!!

Tara

 

[Rick B]

One more thought. If the day of the month varies (John runs it around the
middle, Sue runs it around the end, etc.) then you would need to track by
whom and when the report was run. You'd then have to insert code somewhere
to do a lookup in that table and find the current user's most recent record.
You'd have to do date math to subtract the run date from the current date.
If the difference was 29 days or more (for example) then pop up your message
box, or display your textbox.

Rick B


I'm not sure I'm posting this in the right spot, but here
goes...I would like to design something to remind users
to run a certain report every thirty days. Something
like a flashing label that is only visible every 30 days,
so that when the user opens the database, they get this
visual reminder. Is this possible? Thanks in advance
for any help!!

Tara

 

[Guest]

Rick,
Thanks for the help! I need to think it through a bit
more as you brought up some good points I hadn't thought
of (tracking users, etc.). I will post back when I've
made a couple of decisions, if I still need help.

Tara