Setting an Alert/Reminder in Access

[drewdarian]

I haven't really used Access before, however, I'm a little familiar. There
is a database that's been created for our customer complaints, which
different departments are assigned these complaints. We have a monthly
meeting discussing the status of the customer complaints. Between the
months, I would like to set reminders or alerts for updates with the assigned
departments. Is there a way of doing this?

Thanks,
drewdarian

 

[Seth Schwarm]

This is possible. It depends on how you are wanting this functionality to
work.

You have described your basic application, now discuss what would the user
do to view the alerts (when they open the db, they must open a report, when a
form opens - how?), what are you wanting the alert to look like, how is an
alert to be triggered?

Think through these things, then reply and I will be happy to help.

Seth Schwarm

 

[drewdarian]

We are running Access 97 and Outlook 2003. What I want to make happen is for
the correct departments to be notified when they have a complaint to work.
Is there a way to link Access and Outlook so when a complaint is assigned, an
email or an appointment invite will be sent to the designated assignee where
they have to "accept" or "decline" as done in the Outlook calendar?

 

[Seth Schwarm]

Well what can I say . . . now you are talking developer talk. Your best bet
is to buy the book Access Cookbook by O'Reilly Publishing and study hard on
the chapters discussing interactivity with Outlook.

What you want to do can certainly be done, but I nor anyone else I suppose
is willing to type the endless pages it would take to detail every step.

If you were wanting to do something just inside Access we could probably
develop a modest solution, when you introduce Outlook - that is a whole other
sport.

Sorry - wish you the best.

Seth Schwarm

 

[drewdarian]

Thank you for your response.

Well what can I say . . . now you are talking developer talk. Your best bet
is to buy the book Access Cookbook by O'Reilly Publishing and study hard on
the chapters discussing interactivity with Outlook.

What you want to do can certainly be done, but I nor anyone else I suppose
is willing to type the endless pages it would take to detail every step.

If you were wanting to do something just inside Access we could probably
develop a modest solution, when you introduce Outlook - that is a whole other
sport.

Sorry - wish you the best.

Seth Schwarm