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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Reminder
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 |
#2
|
|||
|
|||
Reminder
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 "Tara" wrote in message ... 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 |
#3
|
|||
|
|||
Reminder
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 "Tara" wrote in message ... 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 |
#4
|
|||
|
|||
Reminder
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 -----Original Message----- 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 "Tara" wrote in message ... 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 . |
Thread Tools | |
Display Modes | |
|
|