471,863 Members | 1,020 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,863 software developers and data experts.

open a word document by clicking a buttton in access form

Hi everyone and anyone, i have a form in Access named "Invoice" which store information for each particular invoice. After filling in the particular detail of an invoice, I want to click on a button "Create Invoice" to open a word document so that i can perform the mail merge function to select the Invoice Data from access and then convert it into PDF file and lastly save it as a Invoice file like INV0100 - P85037,

That's mean each Invoice record in Access form will have 1 Invoice file. After the invoice file is created, I want to click on "View Invoice" button to view the invoice being created just now. For example, for the Invoice record of the Invoice form with Invoice ID INV0100, if I click on "View Invoice" button, the INV0100 - P85037 will appear and so on.

I have google around to find the solutions, but I just can't get exactly what I want. Anyone has the solution please? Many Thanks.
Feb 15 '08 #1
1 1623
446 Expert 256MB
This is fairly ambitious!

You can open a Word document from Access but you would then have to program a macro in Word to do the Mail Merge. I will be interested to learn how to then save this as a PDF?

What's wrong with generating the Invoice in Access as a report (with all the text from the Mail merge document built in) and then printing it via PDF printer software to a file?

Feb 18 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by Marion Neubauer | last post: by
3 posts views Thread by Andy Davis | last post: by
2 posts views Thread by Jonathan Trevor | last post: by
5 posts views Thread by jerry.ranch | last post: by
reply views Thread by YellowAndGreen | last post: by
reply views Thread by aboka | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.