pop up reminders

[kushy]

How can I go about creating pop up reminders for expired dates in (MS Acess 2003) forms for each record.

For example: Date Renewal = 31/01/2005

I need a pop up reminder popping up a month before the date renewal.

Thanks in advance!

 

[Mile-O]

Moved from Sample Database forum; please choose the appropriate forum in future.

Use the form's Current event to check if the date field contains a date that has expired.

 

[ScottGem]

How can I go about creating pop up reminders for expired dates in (MS Acess 2003) forms for each record.
For example: Date Renewal = 31/01/2005
I need a pop up reminder popping up a month before the date renewal.
Thanks in advance!

Create a query and set the criteria for the renewal date field to:

<DateAdd("m",-1,[RenewalDate])

Create a report based on that query and set it to run whenever you open your database.

 

[kushy]

thanks SJ McAbney and Scott.

But Scott once i've created the query and associated it with the report how do i automatically get it to run as soon as I open the database rather than having someone to click on a button and ask it to run?

thanks Kushy!

 

[Mile-O]

A macro called autoexec.

 

[ScottGem]

Or, if you have a default form loaded at startup you can put it in the On Load event of that form.

 

[kushy]

Scott do i need to use VBA by any chance..Because i'm not very good with VBA. Could you give me a link or a database sample on how you run queries automatically as soon as the database starts up.

Thanx Kushy!

 

[ScottGem]

You can use the Autoexec macro as SJ suggests. look up Autoexec in Access help for details. But you really should get away from macros and into modules. They are so much more flexible.

In your case, all you need is ONE line of code in the On Open Event of the default form. Open the form in design mode, select the On Open event, click the elipsses [...] and select Code Builder. The line of code would be:

DoCmd.OpenQuery...

Just fill in the arguments as prompted. For an explanation of the arguments lookup OpenQuery in Access help. You could also use OpenReport to open a report instead of a query.

 

[kushy]

Thankyou so much both SJ and Scott with the help you've given.

Another question if anyone can help me out...is that:

How do I go about allowing other users in the office to use the Database system I'm building.

I will be implementing my database system soon in the office...we talking roughly 10 users using it at the same time....So it should allow editting, adding etc happening at the same time.

If anyone can direct me to a specific path or give me links...I would be so grateful....!

Thanks in advance...!

I knw I may be in the section thread but I don't quite know where to post up this message! Sorry in advance as well.!!!

 

[Mile-O]

Do a search on splitting a database, front ends, backends, and database distribution - all your answers are here.

 

[ScottGem]

How do I go about allowing other users in the office to use the Database system I'm building.

You need to split the database between the back end (tables) and the front end (everything else). Access supplies a database splitter wizard to do this.

The back end gets stored on a network share. The front ends should be stored locally for the best performance, but can be in the same share.

 

[Gilrucht]

I'm not really at this stage in my db yet but I'm going to ask this question now because I think this post is exactly what I am looking for. Can this code, with some modifications, be used to track any duedate. For example, if there is a brief due in 30 days and a Motion due in 20 can we use this code to produce a reminder for both duedates?

I'm thinking of something like "If today is less than [due date] instead of the dateadd function. Then use a date calculation to subtraction todays date from duedate. We would then run it once a week to give us a weekly report of the status of things due.

The problem that I see is is that everything is in seperate Tables. (ie briefs and briefduedates in 1 table, pleadings and pleadingsduedate in another, statuteoflimitations in each case type because its different depending on case type, etc) We'd like a 5 column report: ClientName, ItemDue(ie,Brief,Motion,etc),todays date, duedate, duein(the date calculation. But I'm not sure how this report can be created when it needs to created on seperated tables but put in the same columns. Can data from different tables be put in the same columns of a report?