need some kind of pop up reminder or email from access 2003 to go

[carriedekoffins]

Hello all,

I am new to this website as I was directed to it by a fellow employee
literally about an hour ago! He said if I had a question about Microsoft
Access, this is where I need to be!

I currently have outlook 2007 and Access 2003 on my work computer. I am not
sure if what I want to do will work if they're not the same, but it's worth
asking....

I have managed to create a few databases for the management I work with, but
they say they need to recieve some kind of pop up alert or email when a
particular date in the database comes up; for example if the database was for
staff training that was due, I would need a message to pop up in their email
or calendar (something in outlook) that would alert them that Mr. Jones needs
training, say a week before it's due.

I hope this makes sense as I have been searching the internet for anything
that even sounds remotely like what I need, but I've had no such luck. The
colleague who told me about this site mentioned using soemthing called SQL,
and tried to briefly explain, but even if I did use this, I would be wasting
my time as access is the only thing that the managers have a basic
understanding of.

If anyone could point me in the right direction that would be FANTASTIC!!
....and save me searching the net through my dinner and breaks!!

Thanks very much

 

[Jeff Boyce]

Check into the SendMail command in Access.

You would use this to actually send the reminder.

You would still need to build the procedure that checks for and identifies
Mr Jones (and others).

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[Steve Schapel]

Carriedekoffins,

I would be pretty sure that Jeff meant to put SendObject not SendMail.

As well as needing to work out how to identify the recipients, you will also
need to clarify *when* you want this to happen. Macros and VBA code in
Access are activated in response to "Events", for example when a form opens,
or when a command button is clicked, or when an internal timer cycles.

 

[Jeff Boyce]

Steve

You're good! I didn't even know what I was thinking, but you did!

You have a fine future as a translater ... but I can only pay $1.37/hr
....<G>

Jeff B.

 

[Reed Mason]

Ido not understands WHY THIS WAS FORWEDTO ME
I DO USE ENTOURGE 12.1.O FOR SUSTEM 8
I ddo not use macros nor VBA codes
I did send a request for help a while. Do not rember what it was now