Is there a way to do this?

  • Thread starter Thread starter Terry
  • Start date Start date
T

Terry

I have an order form with a field on the form for Revised Date. Does anyone
know if there is a way that if data is entered into this "Revised Date"
field or if the data is changed in this field, is there a way to send an
email notification to someone?

Any help/suggestions would be greatly appreciated.

Terry
 
Hello,

You can set up a button on your form so if the anything changes with that
field, just click the button and it will pop up a new email(as long as your
email is outlook) then put in the email address and click send. If you are
sending to one specific indiviual, you can have their email address
automatically populate with when the new email pops up. Does that seem like
it will work for your purposes?
 
"Terry" wrote in message
I have an order form with a field on the form for Revised Date. Does
anyone know if there is a way that if data is entered into this "Revised
Date" field or if the data is changed in this field, is there a way to send
an email notification to someone?
Click to expand...


You can use something like this air code in the form's BeforeUpdate event:

'----- start of "air code" -----
Private Sub Form_BeforeUpdate(Cancel As Integer)

With Me!RevisedDate
If Not IsNull(.Value) Then
If .Value = .OldValue Then
' Same as previous value (or previous value
' was Null); ignore.
Else

DoCmd.SendObject acSendNoObject, _
To:="(e-mail address removed)", _
Subject:="Order Revised", _
MessageText:="Order " & Me.OrderID & " was revised.", _
EditMessage:=False

End If
End If
End With

End Sub
'----- end of "air code" -----
 
Hi Dirk,

You help me once before on my Storage Database(with the hyperlinks) I was
wondering if you could take a look at a posting I put out today entitled:
Date turn time calculation HELP PLEASE!

I sure would appreciate it if there was any help you could give me.

Thank you!
 
Back
Top