Access 2007 form creation

35 pts.
Tags:
Access 2007
Access 2007 form creation
Access Forms Database
[strong]KVS: [/strong]

[strong]Q: [/strong]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

[strong]Gent01[/strong]-

[strong]A:[/strong] Here is info on how to create access forms. Once you got that down add code like this to send out an email

[strong]KVS: [/strong]

[strong]RE-Q: [/strong]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.

ASKED: January 28, 2010  9:19 PM
UPDATED: January 28, 2010  10:09 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following