I'm a newbie at Access, but have been tasked with creating a web-enabled database. The goal is to allow a requester to input an issue for review. The reviewer must be notified a new issue has been directed to them via email.
I've started by using the Microsoft Issues web-enabled template as my base. I've added some fields and a table to the template to meet my needs. I've also found an online tip that describes how to build a data/name macro to email a notifier when a new record is entered for review. This macro resides in the Issues table. In case you don't know, you must use macros in web-enabled Access databases. You cannot use VB code, since it does not translate to the web.
Now here's my problem...
On my Issues form the requester must select a School, from a combo-box. The school record in the Users table contains fields that include the reviewer for that school's name and email address. I have established combo-box fields that display the reviewer's name and email address from the User table record, after the School is selected (auto-fill). I can see the values I want are being populated on the form. On the Issues form I've created a button that when clicked calls the macro in the Issues table to email an alert to the reviewer. However, those values are not being transferred into the Issues table. And, consequently, my email macro is returning an error that 'The SendEmail action failed because no recipients were specified.'
I've attached a zipped image of my name/data macro, if that will help anyone sleuth a solution to my problem.
Basically, I need to know why my auto-filled fields are not storing their values in the Issues table after being pulled from my Users table.
Any and all help is appreciated!
I've started by using the Microsoft Issues web-enabled template as my base. I've added some fields and a table to the template to meet my needs. I've also found an online tip that describes how to build a data/name macro to email a notifier when a new record is entered for review. This macro resides in the Issues table. In case you don't know, you must use macros in web-enabled Access databases. You cannot use VB code, since it does not translate to the web.
Now here's my problem...
On my Issues form the requester must select a School, from a combo-box. The school record in the Users table contains fields that include the reviewer for that school's name and email address. I have established combo-box fields that display the reviewer's name and email address from the User table record, after the School is selected (auto-fill). I can see the values I want are being populated on the form. On the Issues form I've created a button that when clicked calls the macro in the Issues table to email an alert to the reviewer. However, those values are not being transferred into the Issues table. And, consequently, my email macro is returning an error that 'The SendEmail action failed because no recipients were specified.'
I've attached a zipped image of my name/data macro, if that will help anyone sleuth a solution to my problem.
Basically, I need to know why my auto-filled fields are not storing their values in the Issues table after being pulled from my Users table.
Any and all help is appreciated!