I
Irv1010
I have a field called [NextApptDate] and another called [NextApptTime] which
gives that date and time of the next appointment for a client. I would like
these fields along with the [ClientID], [Surname] & [Forenames] to go into my
Outlook diary as an appointment if I Dbl_Click the [NextApptDate] field.
I tried looking at the CodeWidgets.com entry which was suggested to another
question poster, but can't get it to work.
I used the following code to do a similar thing with email:
Private Sub EMail_DblClick(Cancel As Integer)
On Error GoTo ProcError
'Save the record first
If Me.Dirty = True Then
Me.Dirty = False
End If
Application.FollowHyperlink "mailto:" & Me.EMail
ExitProc:
Exit Sub
ProcError:
MsgBox "Error" & Err.Number & ": " & Err.Description, vbCritical, "Error in
procedure Email_DblClick..."
Resume ExitProc
End Sub
Can anyone help please.
gives that date and time of the next appointment for a client. I would like
these fields along with the [ClientID], [Surname] & [Forenames] to go into my
Outlook diary as an appointment if I Dbl_Click the [NextApptDate] field.
I tried looking at the CodeWidgets.com entry which was suggested to another
question poster, but can't get it to work.
I used the following code to do a similar thing with email:
Private Sub EMail_DblClick(Cancel As Integer)
On Error GoTo ProcError
'Save the record first
If Me.Dirty = True Then
Me.Dirty = False
End If
Application.FollowHyperlink "mailto:" & Me.EMail
ExitProc:
Exit Sub
ProcError:
MsgBox "Error" & Err.Number & ": " & Err.Description, vbCritical, "Error in
procedure Email_DblClick..."
Resume ExitProc
End Sub
Can anyone help please.