Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / April 2007

Tip: Looking for answers? Try searching our database.

Export data from Access 2003

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Peter - 29 Apr 2007 13:12 GMT
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?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.