Creating reminders - Can this be done?

[Kosmos]

Howdy...I'm still a newbie although I've been working with Access for a couple of months now, it's only been on Fridays (but I've been trying to give back by helping out when I can). Anyways this may be a kind of complicated question, but my boss wants to know if I can create a reminder somehow, with outlook, or at least when she opens access, that certain contracts are going to end in a certain number of days and then display a list of these contracts (usually something along the lines of 90 days). Anyways if this can be done please let me know :) It would be very appreciated.

Cheers,
Kosmös

[beat1078]

Howdy...I'm still a newbie although I've been working with Access for a couple of months now, it's only been on Fridays (but I've been trying to give back by helping out when I can). Anyways this may be a kind of complicated question, but my boss wants to know if I can create a reminder somehow, with outlook, or at least when she opens access, that certain contracts are going to end in a certain number of days and then display a list of these contracts (usually something along the lines of 90 days). Anyways if this can be done please let me know :) It would be very appreciated.

Cheers,
Kosmös

When you open Access you can run a report to do that.
Create a Macro called Autoexec and inside it run a report (rptContractsExpire)

The report will be linked to a query (qryContractsExpire) that tests the date against the date of the contract +90 days or what ever your criteria is. So [ContractDate] field criteria should be >=Date()+30 provided your date is in date format and not text format. Othewise you need to be creative.

--Jason

[Kosmos]

okay thanks, but is there a way I can get this to integrate with access? I already have created a module for testing for the end date and therefore the amount of days the user has before the contract has expired....but I wanted to create a reminder and hopefully that can be added into MS Outlook. Is that possible?

[MMcCarthy]

okay thanks, but is there a way I can get this to integrate with access? I already have created a module for testing for the end date and therefore the amount of days the user has before the contract has expired....but I wanted to create a reminder and hopefully that can be added into MS Outlook. Is that possible?

You can put your code behind the form that opens on start up in the form load event. Then when the query is run use the following to send a spreadsheet of the results to whomever.

DoCmd.SendObject acSendReport, "QueryName", acFormatXLS, "EmailAddress", , , "SubjectLine", "Message"
 

Mary

[Kosmos]

Cool thanks :)

[MMcCarthy]

Cool thanks :)

No problem.

Mary

[NeoPa]

okay thanks, but is there a way I can get this to integrate with access? I already have created a module for testing for the end date and therefore the amount of days the user has before the contract has expired....but I wanted to create a reminder and hopefully that can be added into MS Outlook. Is that possible?

If all your data is stored in Access then it should be possible.
You can export the data to Excel format easily enough (as per Mary's suggestion), but Outlook would need to use the reference to the Outlook application (I would guess). Unfortunately I've never worked in that area so can't help with details.

PS. A module should certainly not be required to test the dates. SQL can handle that perfectly adequately.