Access 2007 form creation

35 pts.
Tags:
Access 2007
Access forms
Microsoft Access
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

Here is info on how to create access forms.

Once you got that down add code like this to send out an email.

—————————————————————————————————————————

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.

Discuss This Question: 3  Replies

 
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
  • Gent01
    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
    1,870 pointsBadges:
    report
  • Gent01
    http://office.microsoft.com/en-us/access/HA010345481033.aspx
    1,870 pointsBadges:
    report
  • Kvs
    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
    35 pointsBadges:
    report

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