RE: Odd snapshot behavior

#1 (**permalink**) 28-Jul-2006, 08:16 AM

Nathan,

I had the exact same thing happen. I have several users running a shared
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10846-re-odd-snapshot-behavior.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10846
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
> >