HI can any one help!!
:banghead:I need a couple of macro codes if anyone can help. I'm using Access 2010
1st one is to automatically send email on event change. I have a field that the database user can tick if they need to send an email. See attached document. The filed is basically a check box and email address. If the check box is ricked they would need to be sent the email.
Secondly, I need to highlight all the fields in a row if the order status is "Pending or Partially Ordered" based upon date required field. Again see attached.
I thank I attachments are there, please let me know if they are not.
Many thanks for any help I can get.
Kind Regards Vinny
:banghead:I need a couple of macro codes if anyone can help. I'm using Access 2010
1st one is to automatically send email on event change. I have a field that the database user can tick if they need to send an email. See attached document. The filed is basically a check box and email address. If the check box is ricked they would need to be sent the email.
Secondly, I need to highlight all the fields in a row if the order status is "Pending or Partially Ordered" based upon date required field. Again see attached.
I thank I attachments are there, please let me know if they are not.
Many thanks for any help I can get.
Kind Regards Vinny