Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

RE: Odd snapshot behavior

Discussion in 'Information Technology' started by Debbie H, Jul 28, 2006.

  1. Debbie H

    Debbie H
    Expand Collapse


    I had the exact same thing happen. I have several users running a shared
    Access system from a server. Suddenly, one particular user was creating
    strange looking XLS attachments from a DoCmd.SendObject which was coded to
    export the report as acFormatSNP (Snapshot). All the other users who share
    the same system were not having this problem.

    I found that simply opening the report in Design View, doing a SAVE AS a new
    name, and then revising the SendObject code to point to the newly named
    report seemed to solve the problem. I also tried just opening the original
    report in Design View and resaving it, but that did not fix the problem. The
    SAVE AS option makes you choose: Report or Data Access page, so maybe that
    "resets" something. I'd be interested in hearing if anyone else has
    experienced this problem and can explain what is happening.

    "Nathan" wrote:

    > Well, whatever was going was fixed by copying the contents of the report over
    > to a new report. All is well. Still would like to know what was going on
    > for future reference if anyone knows.
    > Thanks
    > Nathan
    > "Nathan" wrote:
    > > I have a report - here is the problem
    > >
    > > When I go to the send to - mail as attachment and select snapshot as my
    > > format, it sends it out as what appears to be a snapshot format, but the file
    > > name is an odd name and the extension is .xls. Other reports in the database
    > > work just fine, save as a .snp with no trouble. What did I do or what am I
    > > missing that the filename is getting changed somehow.
    > >
    > > Thanks
    > >
    > > Nathan
    > >
  2. Loading...

    Similar Threads Forum Date
    Soul Mates, Twin Flames or just Oddballs Blogs Oct 17, 2015
    20 Odd Questions for Waris Ahluwalia Sikh Youth Nov 24, 2013
    Leisure Odd Michigan Law Business, Lifestyle & Leisure Sep 28, 2013
    Atheism Atheism's Odd Relationship with Morality Interfaith Dialogues Mar 27, 2011
    Hinduism Does Sikhism Confirm the Existence of Hindu Gods/Goddesses? Interfaith Dialogues Mar 2, 2011

Share This Page