Export Microsoft Access Report to a Microsoft Word Document

Export to Word
By Richard Rost

2 months ago

Export to Word Upload Images Link
John Muir
2 months ago

Followed instructions for VBA code. But, when I hit the button, it out puts 10,000 pages, not just the ID I'm working with. I put the button on a form that is opened from the main form.

To preview this same report i used: DoCmd.OpenReport "SAR non-litigation-Annuity Language-Minor" , acViewPreview, , "[ID]=" & [ID], and that works great.

How do I print this report to word and only get the report for the ID i'm working with?

Thanks,

John

Scott Axton
2 months ago

How are you printing it?
You should be able to just print fom the preview screen and only print he single report, Not all of them.
If that syntax is returning the correct report it shouldn't print additional pages.

Adam Schwanz
2 months ago

Just to verify, is there an ID field on the form you're pushing the button on?

If there is, you have spaces and dashes in the name, very possible access is trying to do some kind of mathematical calculation with it. Try putting it in brackets and see if it works. [SAR non-litigation-Annuity Language-Minor]

This thread is now closed. If you wish to comment, start a NEW discussion, below.

Back to Export to Word Comments