Odd snapshot behavior

[Nathan]

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

 

[Nathan]

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

 

[Debbie H]

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.