Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

RE: Odd snapshot behavior

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

  1. Debbie H

    Debbie H
    Expand Collapse
    Guest

    Nathan,

    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

Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page