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?
Daniel - 29 Apr 2007 13:56 GMT
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.

Signature
Hope this helps,
Daniel P
> 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
[quoted text clipped - 4 lines]
> several lines just like a normal text page instead of one endless table. Any
> suggestions?
Peter - 29 Apr 2007 17:32 GMT
10x Daniel
> One option would be to setup a report and print it as a PDF.
>
[quoted text clipped - 14 lines]
> > several lines just like a normal text page instead of one endless table. Any
> > suggestions?