I have created a transport database for my organisation where employees can req for transport when needed. But i'm not good at Access 2007.
I need help on below list of queries:
1. I have created button for employees to submit their request, now when they click on that button a message should appear as
"A email will be sent to ur TL, manager and transport dept"
"Do you wish to continue"
Yes or No.
2. If employee clicks on Yes, an email should be generated and sent to said list with a format automatically (few columns should be captured and paste in body of email).
If employee clicks on No, he should be returned to main page/form where he/she raises a req for transport.
3. And all that is being done above should be captured in the database.
Awaiting for a quick response.
January 23, 2010 12:10 PM
January 29, 2010 9:10 PM