I want to insert access report in a word document, for this, I use this code:
DoCmd.OutputTo acReport, "rptName", acFormatRTF, "C:ReportFileName.rtf"
but, when that output word file is empty, don't have any chart that was in access report.
I want to insert access report in a word document, for this, I use this code:
DoCmd.OutputTo acReport, "rptName", acFormatRTF, "C:ReportFileName.rtf"
but, when that output word file is empty, don't have any chart that was in access report.
It is probably an issue with the Rich Text Format (.rtf). Although word can open RTF files, RTF does not have all of the format capabilities of, say, .docx. I can not find a way to format in Word .docx using OutputTo method. Also, you path needs a backslash - "C:\TestReportFileName
Maybe you can use acFormatPDF and save as a pdf file to preserve formatting of charts, etc.
Code:DoCmd.OutputTo acReport, "rptName", "PDFFormat(*.pdf)", "C:\TestReportFileName.pdf" 'OR DoCmd.OutputTo acReport, "rptName", acFormatPDF, "C:\TestReportFileName.pdf"
i have many chart in access should be exported to my word document."pdf" file don't proper for this.
Charts will not export. Period. RTF doesn't handle. Why do you need a Word document? Why not just an Access report?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
How can i insert 30 chart with different row source, in one report?
30 charts is a lot. Access report dimension limits are 22x22 inches. That is not big enough? Why 30 charts?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
if all of 30 charts have same row source,access don't have any problem,but with different row source,word office is better.for this reason i want to export every chart from access to word document.
30 charts or even more, are for every instrument that installed in one project (dam or tunnel),monitoring report should be contain all of instrument charts.