[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Can Access 2007 export a report to Word and save it in a 'prior to 2007' format?

Posted on 2010-11-16
6
Medium Priority
?
375 Views
Last Modified: 2012-05-10
I have a command button on an Access 2007 form which exports a report to Word. Is it possible, through VBA, to export the report and have it saved in a format compatible with older versions of Word?
0
Comment
Question by:newbie46
6 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 34145320
If you specify a .doc file that should be sufficient.
0
 
LVL 93

Expert Comment

by:Patrick Matthews
ID: 34145325
Please post the code you are using now.
0
 

Author Comment

by:newbie46
ID: 34145351
matthewspatrick,
DoCmd.OutputTo acOutputReport, "rptA", acFormatRTF, PMTableName & ".rtf", True
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
LVL 93

Accepted Solution

by:
Patrick Matthews earned 2000 total points
ID: 34145476
Access does not do a native export to Word.  The closest it gets to is RTF (rich text format), which Word is able to interpret.  Some, but by no means all, of the formatting in Access is translatable into RTF, but in my experience the fidelity is not high, and I avoid using it unless I absolutely must.

Have you tried opening an RTF document generated from Access 2007 in Word 2003?  My gut feeling is that it will probably work.
0
 

Author Closing Comment

by:newbie46
ID: 34145663
thanks.
0
 
LVL 49

Expert Comment

by:Dale Fye
ID: 34145797
Personally, I avoid the RTF export as well, since it embeds hard carrage returns and has other formatting issues.

If I want my output to go to Word, I generally write a custom procedure that opens Word via automation, and I build the Word document from scratch.  I could post some sample code (if you are interested), it wouldn't mean much because all the tables and fields are meaningless, but it might give you some ideas regarding how to do this.
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Get the source code for a fully functional Access application shell with several popular security features that Access VBA application developers desire, but find difficult or impossible to figure out how to code. You get the source code for managi…

612 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question