email a list from an updated field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to to send an e-mail to someone once a field has been updated or values put in
And would there be a way that I can query if something has been put in
Could I query based on the date in a field and the cuurent date. This could give what has been updated at that time

Does anyone have any suggestion
 
It depends on how their entering the data, if it's a form you can assign the field you want to test to a variable and then if that changes send an email or in the properties box just put the email code in there for on change, make sure to set a value.oldvalue and test it to the new value first so you don't send tons of emails. If they open the database table itself you can create similar code that opens the database and assigns the field to a variable and then watch if it changes.

The easiest way is to use a form and then just put your email and validation code in the on update or on change event.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating an update query that uses multiple parameters 2
Access Updating inventory levels 0
update field 2
Counting multiple memberships 1
Outlook Creating an Outlook form 2
Clear a date field using a macro 12
Copy form fields to related table 1
Memo fields and update query 1

Back
Top