Problem outputting access report to .snp
Posted on 2006-03-30
I am having a problem wich I beleive to be an issue with the access runtime environment. I have a form where users can select a report to either print or preview. Print send it striang to the printer and works like a charm. Preview outputs to a .snp file on the users local pc then opens it in the snapshot viewer (see code below) this all works just fine on a pc with the full version of Access however, on a pc with just the runtime environment it appears to be working, but a 10 page report will continue to output pages until I decide to click cancel usually around 6000 pages or so.
'Create A Snapshot of the report.
DoCmd.OutputTo acOutputReport, "rptMonthly_All", "snapshot_ Format", "C:\Temp\rptMonthly_All.snp" '..... this saves your report as snapshot
'then open your form with a snapshot viewer control on it ...
'load the snapshot fiel into the viewer control
Forms("frmReport").Controls("SnapshotViewer2").SnapshotPath_ = "C:\Temp\rptMonthlyVBH_.snp"