Snapshot Files

[steel]

Hi,

When using VBA to create a Snapshot file a dialog box is shown as if the
Snapshot is being generated, however, the actually Snapshot doesn't get saved
at the file location I specify. There are no file-level security restrictions
to hinder the creation. From the creation the file is then emailed, however,
the email module gets an error because it can not find the attachment
(snapshot Report) in the file location specified.

Docmd.OutPutTo acOutputReport, "Task Report", acFormatSNP,
"c:\temp\report.snp"

Is there a VBA Reference that needs enabling?

Any help is appreciated.

Thanks.

 

[privatenews]

Hello Steel,

I was not able to reproduce the issue. When running first function in
immdiate window, the snapshot file could be generated properly under doc
folder:


Function test()
DoCmd.OutputTo acOutputReport, "Alphabetical List of Products",
acFormatSNP, "c:\doc\report.snp"
End Function

YOu may test above code in Northwind sample database to see if you could
find the result snp file. No reference is necessary.

Please make sure the folder c:\temp exist and you have the proper permssion
to the folder.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================



This posting is provided "AS IS" with no warranties, and confers no rights.

 

[steel]

Hi Peter,

Turns out the snapshot was being generated because the Report itself was
opening, because of a corrupt query, query didn't open because of a corrupt
table, which had a corrupt record (the culpript turned out to be one record
out of 1035). I deleted the record and everything worked OK including
snapshot and email...go figure.

I don't know why the record was corrupting everything, but it wasn't
important. Deleting it was easier than troubleshooting any further.

Thanks for you testing.

Alan

 

[privatenews]

Hello Steel,

Geat to hear you resolved the issue. Your experience on this issue shall
benefit the community.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================


This posting is provided "AS IS" with no warranties, and confers no rights.