Export data from Access 2003

[Guest]

Hey guys, i am a relatively new in programming VBA, however, i have created a
small application with several tables and forms that provide a certain
automation through intgrated vba code. My problem is that i need to export
data from a form to a word document (or pdf) keeping the format. The
integrated "Export" command outputs all data into a table, but what i need is
to output the data in a more reader-friendly verion - e.g. text fomratted in
several lines just like a normal text page instead of one endless table. Any
suggestions?

 

[Guest]

One option would be to setup a report and print it as a PDF.

Check out http://www.lebans.com/reporttopdf.htm

If you really want to automate word then check out

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html - mailmerge
http://www.excelguru.ca/node/10#Word - late bidning technique
Also, use google there are ton of examples out there.

 

[Guest]

10x Daniel

One option would be to setup a report and print it as a PDF.

Check out http://www.lebans.com/reporttopdf.htm

If you really want to automate word then check out

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html - mailmerge
http://www.excelguru.ca/node/10#Word - late bidning technique
Also, use google there are ton of examples out there.