Send SNP file

[Guest]

How can I send a SNP file to a my aaa folder on my c drive. Here is what I
have so far. Thanks.

DoCmd.SendObject acSendReport, "123report", acFormatSNP, c:\aaa

 

[jahoobob via AccessMonster.com]

SendObject is for e-mail only. You want the OutputTo:
DoCmd.OutputTo acReport, "123report", "SnapshotFormat(*.snp)", "c:\aaa",
False, "", 0

 

[Guest]

Thanks, I should have known that. I have another question with regards to
this problem. How can I have the snp file "123report" be [field].snp

Another words, I have a field that is an auto number field and would like
the snp file to reflect that number. ex: 12345.snp I can get it to be
123report.snp but not sure how to do it the other way.

Thanks.