Access 2007 form creation
Hi There,
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.
Email: kvspawan@gmail.com
Thanks
Pavan
Software/Hardware used:
access 2007
Software/Hardware used:
access 2007
ASKED:
January 23, 2010 12:10 PM
UPDATED:
January 29, 2010 9:10 PM
Answer Wiki:
<a href="http://office.microsoft.com/en-us/access/HA010345481033.aspx">Here</a> is info on how to create access forms.
Once you got that down add code like <a href="http://www.peterssoftware.com/c_emfa.htm">this</a> to send out an emai.
---------------------------------------------------------------------------------------------------------------------------
Hi there,
First of all thanks for your help. The code that you provided was really working. Now that i have one problem here.
When drafting email how do input the message where it captures content from the fields in the access form along with the body of the message.
example: the body of the message should be something as below:
Hi there,
I request you to approve my leave for (date should be captured from the form) OR
I request you to approve my early login/logout (time should be captured as entered in the form)
Regards
XXXX
Also, the micro soft link provided is not working!
Thanks
Pavan.
To see all answers submitted to the Answer Wiki: View Answer History.
Do you mean that the link won’t open for you or it’s not the information you needed? Here is a text copy of the link:
http://office.microsoft.com/en-us/access/HA010345481033.aspx
Hi Gent01,
how do i send my query directly to you. As your understanding seems to be matching my level. Please let me know. As i m building a database useful for my organisation for overcoming transport issues. please help me.
Further, i was not able to open the microsoft link. it said problem loading page. But in office i was able to open. Please email me your email id so that i can get some help.
My email id is: kvspawan@gmail.com