Problem outputting access report to .snp

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 ...
DoCmd.OpenForm "frmReport"
                   
'load the snapshot fiel into the viewer control
Forms("frmReport").Controls("SnapshotViewer2").SnapshotPath_ = "C:\Temp\rptMonthlyVBH_.snp"


                   
jonesy_33Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

jonesy_33Author Commented:
does anyone have any idea why it outputs endless pages in the runtime environment, but outputs the correct number of pages and opens correctly when on a machine with teh full version of Access
0
puppydogbuddyCommented:
Probably because of the syntax.  Here is syntax I use. Try it.
 
DoCmd.OutputTo acOutputReport, "rptMonthly_All", acFormatSNP, "C:\Temp\rptMonthly_All.snp" , False
0
jonesy_33Author Commented:
After further testing I think it is because of the printer. The user's pc's using the runtime environment they connect to the printer through a print server. However, when I load the drivers, like I was adding a local printer the problem disappears. if I remove all printers from the PC the problem comes back.

Do you know of the snapshot viewer requiring a local printer??
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

jonesy_33Author Commented:
just found the answer to my own question; http://www.totalmetrics.com/cms/servlet/main2?Subject=Content&ID=807

It appears that the snapshot viewer does require a default printer and the way I code the printing of the reports sometimes leaves the printers without a default (not sure how or why), but if that happens and then the user goes to preview a report using the snapshot viewer then they will have the issue in my original posting, but if they go in to Printers and FAX's and assign one then it works fine. Kind of a hassel, but they will have to deal till I can debug..

0
jonesy_33Author Commented:
How do I close a question I answered myself other than the obvious answer of never asking it in the first place??
0
puppydogbuddyCommented:
Contact community support and request that they close out the question and refund your points.
0
puppydogbuddyCommented:
No objection.
       PDB
0
jonesy_33Author Commented:
works for me, it would be nice if it was just closed. That way if others come across the same issue maybe it could be of use.
0
GranModCommented:
Closed, 125 points refunded.
GranMod
The Experts Exchange
Community Support Moderator of all Ages
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.