Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


Somewhat Urgent: Exporting a Report to Snapshot Format in Access 97

Posted on 2004-10-26
Medium Priority
Last Modified: 2008-02-20
I've got a database written in Access 97 and have installed Service Releases 1 and 2 and the snapshot viewer but am still unable to export my report to a snapshot file.  The option is there, and I get no error message, but no file is produced.  Anyone seen this?

Question by:Michael Vasilevsky
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2

Accepted Solution

CrossWired earned 750 total points
ID: 12416922
What version of Windows are you using? The was a bug for Access 2000 under 95/98 that did something like this when a graphic was present

LVL 10

Author Comment

by:Michael Vasilevsky
ID: 12417012
This is Access 97 in Windows 2000 and/or XP.  And I do have graphics (tables with drawn lines) in my report.

Is there a work-around for the known bug?

LVL 34

Assisted Solution

flavo earned 750 total points
ID: 12417131
I use Access 97 (Win2k), this works a treat

DoCmd.OutputTo acOutputReport, "rptMyReportName", "Snapshot Format (*.snp)", "c:\1.snp", 0
LVL 10

Author Comment

by:Michael Vasilevsky
ID: 12417173
Oh, I get the points again!  It wasn't the drawn lines at all but a bitmap image in the header.  For some reason with bitmap it craps out but it can handle gif or jpeg.

endless wonders...

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
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…

636 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