Microsoft Access Calendar

[Guest]

I work with employees to ensure they are up-to-date with immunization. How
can I use my outlook in access to automatically make appointment reminders?
Is this even possible

 

[Douglas J. Steele]

It depends on how your database is structured.

Properly, you need a table of employees, and a table of immunizations.
Assuming your Employee table has a primary key of EmployeeId, your
Immunization table would link back to the Employee table by having a foreign
key of EmployeeId in it, plus fields indicating which immunization type and
when it was received.

You'd then have a query that you could run whenever you wanted that returned
the names of those employees for which the Immunization record for
immunization type X was more than n months/weeks/years old.

 

[Ron Hinds]

Yes, it is! You need to first add a reference for Outlook in your Access
app. Then put code like this behind a button to add a task to Outlook
(here's a skeleton):

Public Sub AddOutlookTask()

On Error GoTo Error_AddOutlookTask

Dim objOutlook As Object
Dim objTask As TaskItem
Dim boolLaunched As Boolean

On Error Resume Next

Set objOutlook = GetObject(Class:="Outlook.Application")

If Err.Number Then
Set objOutlook = CreateObject("Outlook.Application")
boolLaunched = True
End If

On Error GoTo Error_AddOutlookTask

If Not objOutlook Is Nothing Then
Set objTask = objOutlook.CreateItem(olTaskItem)

With objTask
.Subject =
.Duration =
.ReminderMinutesBeforeStart =
.Start =
.CreationTime =
.Display True 'Display modal form
.Save
End With

If boolLaunched Then
objOutlook.Quit
End If
End If

Set objTask = Nothing
Set objOutlook = Nothing

Exit_AddOutlookTask:
Exit Sub

Error_AddOutlookTask:
msgbox error, vbCritical, "Error " & err & " - AddOutlookTask"
Resume Exit_AddOutlookTask

End Sub

 

[dbahooker]

more importantly

right-click LINK in Access to link to files of type = outlook

select TASKS or whatever you need to link to

then build your queries to use the data however you want

 

[Arvin Meyer [MVP]]

I work with employees to ensure they are up-to-date with immunization. How
can I use my outlook in access to automatically make appointment reminders?
Is this even possible

You can probably adapt the following free demo to your purpose:

http://www.datastrat.com/Download/OutlookAppointment.zip
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access