Access. I need the steps and the expression for the \"if\" conditional. 1. Creat

Question

Access. I need the steps and the expression for the "if" conditional.

1. Create a named data macro , which will automatically send an alert e-mail to the Medical Coder that the database has been altered.

a. Create a data macro which will send an e-mail to the Medical Coder when the Patients table has been altered.

b. Needed data: Medical Coder’s e-mail address: medicalcoder@chc.com Subject: CHC Database Alert Body: The Patients table has been updated. c. Save the macro as DataMacro-SendEmail.

2. Attach a Named Macro a Form

You will now attach the above macro to a form event to implement the e-mail macro. You will use the After Update event as the trigger for the send e-mail macro.

Create a macro for After Update of the Patients form that runs the DataMacro-SendEmail macro.

Explanation / Answer

Reference Links:

https://support.office.com/en-us/article/Create-a-data-macro-b1b94bca-4f17-47ad-a66d-f296ef834200

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects