Help with Access Database - converting to Word

[Molases]

Please help me figure out how to insert Acess database information into a word document...

thank you

 

[UncleJack]

Depends on the type and format of information you want to insert. If you can display the information in table format either as a table or as the result of a query, just highlight the columns and rows of the table, copy to the clipboard (Ctl + c) and paste (Ctrl + v) into the Word document. OLE (Automation they call it nowdays) will operate to create the data in Word that looks exactly like the highlighted portion of the table.

Uncle Jack

 

[Zepher2]

For instructions and sample code of inserting access fields from a form or report directly into word try this site.

http://www.helenfeddema.com/

Download code 2 which is an example of using vba to click a button on the form and open ms word using a template and inserting the fields into your word document.