Question Sending Form Through Email And Processing Responses, Access 2010

[AccessRube]

Hello,

I'm working on a vacation/time off tracker and was hoping to use the collect data feature. I've created a form where a user submits their requested date and number of hours, at which point I'd like the form to be sent to their manager for approval. The manager's email address is stored in a table. Once the manager marks yes or no, I'd like that reflected in the time off requests table, and an email sent to the requester letting them know if it was approved or not. Is this possible? How would I go about it. I'm pretty new to Access, learning on the fly, but I'm pretty good at modifying code to match my situation/working backwards if you have any examples for me to look at. Happy to explain further if anything is unclear.

Also, if this is the wrong forum please let me know where to move it to.

Thanks in advance!

 

[Trevor G]

Look at your Outlook in there, there is a form you can use which stays attached to the Database.

Other than that you could send out notifiers to the managers and request they check the database, as normally an access form can't be used without being connected to the database. So other option would be using Excel workbook and create a form for them to fill out and then send to you and upload the results into the database with some VBA code.