Weekly Reminder

[Hayley Baxter]

I could use a little help with this guys. What I would like is a pop up msgbox that reminds the users to add their comments to a weekly journal.

So far I have created a macro with my title and msgbox comments etc. I know about the timer interval property but rather than every few seconds or minutes I would like this message to appear on a weekly basis. However If I set this to one specific date in the week they might not open the db on that day.

My question is that given I want to remind them weekly what should I put in the timer interval or would I be better off just using code?

Any help would be appreciated.

Thanks
Hayley

 

[RV]

A quick thought:

- create a query which retrieves (even per user perhaps if that's possible = depending on your database definition) when the last comment was added.
- when the latest comment was added 7 days ago or more, a form pops up.

You can use the DCount function to count the number of comments which were added >= 7 days ago.

RV

 

[Hayley Baxter]

Hello RV thanks for responding. I'm still not quite getting this right. I have created a query and added my field name Last comment date to the query grid and entered the criteria as

<Date()-7 which gives me all of the comments entered 7 days ago or more from the current date. This is not quite right as I only want to track the last comment.

I've been looking at conditions in the macro to run the message if the condition = Last comment <Date()-7 but I could still use some further suggestions

Thank you
Hayley

 

[ColinEssex]

Hiya Hay

Hows tricks??

Can't you do a Max in the query on the date field and set the number in the result so you only get one row?

I just did it with a "date last logged in" field - seems to work ok

Catch you later

Col

 

[Hayley Baxter]

Thanks to everyone who responded. I have managed to play around with this and make it work.

Cheers
Hayley

 

[fasternu]

An alternative would be to just set up a macro to e-mail the user(s) a reminder message, write a bat file to execute the macro and then schedue the bat file to run based on the task scheduler.