469,631 Members | 968 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,631 developers. It's quick & easy.

open a word document by clicking a buttton in access form

50
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 1558
sierra7
446 Expert 256MB
Hi
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?

S7
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 gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.