Access to Outlook apointment

[Jeff G]

I have a data base that tracks all of our machinery "lubrication Due" by
dates. Is there anyway they cane be made to show up in Outlook on a monthly
calander or even better yet, pop up as an apointment reminder?

Any advice would be a great help

 

[Tony Toews [MVP]]

I have a data base that tracks all of our machinery "lubrication Due" by
dates. Is there anyway they cane be made to show up in Outlook on a monthly
calander or even better yet, pop up as an apointment reminder?

One alternative would be to create a continuous form with the
Lubrication Due date in descending sequence. So the oldest is at the
top.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Jeff G]

Thank you Mr. Toews for your help. It is appreciated. I'm not sure what a
"continuous form" is. Is this something that can be used in ACCESS?

What I'm trying to do is prevent me from generating a report that is pinned
to our message board in our office. You know the message board that's in
every office. The one everyone see's, but totally ignores! That’s why I was
wondering if ACCESS can "talk" with OUTLOOK and create an appointment. I've
heard that this can be done but have never actually seen it done......Any
help would be greatly appreciated.
--
Jeff G
Maintenance Tech
Milgard Tempering

 

[Tony Toews [MVP]]

Thank you Mr. Toews for your help. It is appreciated. I'm not sure what a
"continuous form" is. Is this something that can be used in ACCESS?

Yes, this is a form that vaguely resembles a spread sheet in the a
number of records appear on the form. This approach means that
everyone who needs this information would have to open your app.

What I'm trying to do is prevent me from generating a report that is pinned
to our message board in our office. You know the message board that's in
every office. The one everyone see's, but totally ignores! That’s why I was
wondering if ACCESS can "talk" with OUTLOOK and create an appointment. I've
heard that this can be done but have never actually seen it done......Any
help would be greatly appreciated.

I haven't worked with Outlook and appointments. However this will
require some VBA code. I'd suggest following the Outlook specific
links at the Access Email FAQ at my website to locate other web sites
that have Outlook specific code.
http://www.granite.ab.ca/access/email/outlook.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/