[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Problem outputting access report to .snp

Posted on 2006-03-30
10
Medium Priority
?
348 Views
Last Modified: 2008-03-17
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"


                   
0
Comment
Question by:jonesy_33
  • 5
  • 3
9 Comments
 

Author Comment

by:jonesy_33
ID: 16338608
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
 
LVL 38

Expert Comment

by:puppydogbuddy
ID: 16338992
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
 

Author Comment

by:jonesy_33
ID: 16339306
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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 

Author Comment

by:jonesy_33
ID: 16339319
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
 

Author Comment

by:jonesy_33
ID: 16339324
How do I close a question I answered myself other than the obvious answer of never asking it in the first place??
0
 
LVL 38

Expert Comment

by:puppydogbuddy
ID: 16339508
Contact community support and request that they close out the question and refund your points.
0
 
LVL 38

Expert Comment

by:puppydogbuddy
ID: 16348039
No objection.
       PDB
0
 

Author Comment

by:jonesy_33
ID: 16352728
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
 

Accepted Solution

by:
GranMod earned 0 total points
ID: 16370705
Closed, 125 points refunded.
GranMod
The Experts Exchange
Community Support Moderator of all Ages
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Suggested Courses

834 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