Solved

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

Posted on 2004-10-26
421 Views
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?
Thanks,

mv
0
Question by:mvasilevsky
    4 Comments
     
    LVL 4

    Accepted Solution

    by:
    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

    0
     
    LVL 10

    Author Comment

    by:mvasilevsky
    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?

    mv
    0
     
    LVL 34

    Assisted Solution

    by:flavo
    I use Access 97 (Win2k), this works a treat

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

    Author Comment

    by:mvasilevsky
    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...
    0

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Anonabox PRO Tor & VPN Router

    PRO is the most advanced way to fortify your privacy and online anonymity by layering the Tor network with VPN services. Use both together or separately, and without needing to download software onto your devices.

    Suggested Solutions

    In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
    Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

    913 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

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now