Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / July 2007

Tip: Looking for answers? Try searching our database.

Problem exporting report as snapshot

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ade - 23 Jul 2007 11:18 GMT
When I try to export my report as snaphot(.snp), Access acts as if it has
exported a snapshot of the report but when I go to the folder that the
snapshot should be in there is nothing in the folder at all.

Has anyone encountered this problem before or suggest a cause?
Ade - 23 Jul 2007 11:26 GMT
The problem seems to occur with my reports that contain images.  The report
that just contains text based information exports with no problem.

Any ideas?

> When I try to export my report as snaphot(.snp), Access acts as if it has
> exported a snapshot of the report but when I go to the folder that the
> snapshot should be in there is nothing in the folder at all.
>
> Has anyone encountered this problem before or suggest a cause?
Stephen Lebans - 23 Jul 2007 22:34 GMT
Are you using an Image control or an OLE Frame control to display the images
on the report?

If you are using the standard Image control then place your code to set the
Picture property in the Print event NOT the Format event.

If you have any control's whose Borders are dots/dash etc., remove these and
reset the Border prop to a standard solid line.

Snapshot export will fail silently if you have an illegal character in the
output filename.

Finally, here is a previous post of mine on a relevant issue:

Have you turned off the Loading Image dialog?

If you do not stop the "Loading Image" Dialog via the Registry modification
you will run into two issues:

     1) Access can crash if you scroll through the reocrds too fast.

     2) When printing a Report, Access may run out of resources and be
unable to complete printing the report.

     Additionally, two issues in regards to the Registry modification
pointed to
     here http://www.mvps.org/access/api/api0038.htm

     1) The Registry key MUST be "No" NOT "no" or "NO"

     2) On systems with XP or on systems with more than one user account,
you  must add/modify the key in both HKEY_CURRENT_USER and
HKEY_LOCAL_MACHINE.

Signature

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

> The problem seems to occur with my reports that contain images.  The
> report
[quoted text clipped - 7 lines]
>>
>> Has anyone encountered this problem before or suggest a cause?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.