![]() |
|
|
#1
|
|||
|
|||
|
hi im setting up a database for a friend of mine who is setting his own business up and i want to transfer data from Access to Word to print an invoice off but i dont want to do it using mail merge I want to do it using VBA as I have done the whole database using VBA can anyone help me??
any help will be brill rich |
|
#2
|
|||
|
|||
|
any one please help??
|
|
#3
|
|||
|
|||
|
do you know that access can make a report base on you tables or queries? why the need to transfer data from access to word for the purpose of printing invoice while you can do it without printing the invoice in the word file.
anyway, if you have created you invoice template in a report form of access, then you can use the code below to export it to word file. docmd.OutputTo acOutputReport,"reportname",acformatrtf,"c:\",true |
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How do I get info from Access table to Word doc. | slim_jim_56 | Import/Export Data | 0 | 10-04-2007 07:56 PM |
| Word document INTO Access form | jonathonhicks | Forms | 0 | 04-30-2007 03:59 PM |
| Desperately need code to automate Access 2003 from Word 2003 | smdesq13 | Programming | 1 | 09-06-2006 09:48 AM |
| font of word bookmarks | emilylu3 | Programming | 1 | 03-09-2006 09:07 AM |
| Importing a table created in word to Access | anthony_f_justin | Access | 4 | 01-04-2006 06:06 AM |