By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,164 Members | 969 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,164 IT Pros & Developers. It's quick & easy.

Creating reminders - Can this be done?

100+
P: 153
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
Dec 7 '06 #1
Share this Question
Share on Google+
6 Replies


P: 16
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
Dec 7 '06 #2

100+
P: 153
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?
Dec 7 '06 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
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.

Expand|Select|Wrap|Line Numbers
  1. DoCmd.SendObject acSendReport, "QueryName", acFormatXLS, "EmailAddress", , , "SubjectLine", "Message"
  2.  
Mary
Dec 7 '06 #4

100+
P: 153
Cool thanks :)
Dec 7 '06 #5

MMcCarthy
Expert Mod 10K+
P: 14,534
Cool thanks :)
No problem.

Mary
Dec 7 '06 #6

NeoPa
Expert Mod 15k+
P: 31,660
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.
Dec 7 '06 #7

Post your reply

Sign in to post your reply or Sign up for a free account.