Micorsoft Access Capabilities

[Teeka]

Hi good day, I would like to find out something. Now, my
employer wants me to create a database to record
information about all the company's vehicles. Like when
was their last tune up and when the insurance is due and
stuff like that. However he wants an added effect. He
would like a pop up message to remind us when things are
due (like when the insurance is due and when the next tune
up is due). He wants it to keep popping up until it has
been entered that it has been done. That way it won't be
that until it is due that someone remembers that it has to
be done, so it can be done in a timely basis. Does
Microsoft Access have that kind of capabilty? And if it
doesn't is there I program that I could integrate with
Access to give me that capability? Or do you know of a
software that can store information like Access and give
me the reminders my boss desires? If anyone has an answer
for me you can respond directly to my email address.

 

[CSmith]

Hi,

You could create a reminder lookup table and develop some code around it
using such tools as the DateDiff() function to calculate in advance when
reminders should start popping up. However, instead of reinventing the
wheel, you could use tools that already have that implementation such as
Microsoft Outlook, Yahoo Calendar, etc, which will do the same thing.

 

[Guest]

Thanks for taking the time to read my question. But how do
I use Outlook to get that? Is that I have Outlook to stor
the information or I use access but integrate it with
outlook for the reminders? I do not know a whole lot about
Access or Outlook(jsut to send/receive mail).

 

[CSmith]

Hi,

You're welcome!

You'll have to review/study the Outlook Calendar features and then decide if
you want to simply store the reminders within Outlook itself or integrate
Outlook with your Access data using Outlook VBA from Access, which is a
programming task. It would be easier to simply store your reminders within
Outlook, however, the reminders won't be visible until the user loads
Outlook of course.