Notified of data entries

[Guest]

Hello, I am working with Access 2003. I created a form that as field for
Requisition number, Qty Order, and Qty Issue. Qty Back Order is a calculated
Field in a query. What are some of the methods I could use to be notified
that we have a back order listed in the Qty Back Order field? Is it possible
Access can automatically send this information by using Outlook?

 

[[MVP] S.Clark]

The SendObject method can send emails, based on any criteria that you want.
It requires some VBA code.

With [Fieldname]
If not isnull(.value) then
docmd.sendobject ...[Add desired parameters]
end if
End With

 

[Guest]

Hi Steve, thank you for responding. Your information is putting me on the
correct path but I am new user with VBA code. Am I correct with putting the
following information in the code;

With [Qty Back Order]
If not isnull(.0) then
docmd sendobject…

For the [Add desired parameters] instruction, is that where I put the other
fields name or a verbal statement such as†This is an automatic message from
Receiving Log, part number M879001 is back order 12 qty.†How is the email
address enter within the VBA code? Thank you very much for helping.

The SendObject method can send emails, based on any criteria that you want.
It requires some VBA code.

With [Fieldname]
If not isnull(.value) then
docmd.sendobject ...[Add desired parameters]
end if
End With