I have an Access Database setup like so...
I have a table called t_users The fields are..
Field 1 - Employee
Field 2 - Email Address
I have a table called t_rooms. The field is ..
Field 1 - Meeting Room
I have a form called f_users and it consists of a drop down box, field name Employee and I choose a name from the table t_users. I also have a drop down box, field name Room and I choose a Room from the t_rooms table.
I need a script/module....
I want to press a form button and create a meeting request to this chosen employee and I want the chosen Room as the Subject. I also need to manipulate the date/time of the meeting request before being sent either using date fields on the form or another method.