File Extension Problem

[bernie10]

Hello,
From a form I am using

DoCmd.OutputTo acReport, "MyReport", acFormatSNP

to bring up a file dialogue window allowing the user to save the report in Snapshot format. When the file dialogue window opens, it allows the user to pick the file name, and it defaults to "MyReport.snp" (Save as Type defaults to "All files (*.*)").

My concern is that if the user chooses to rename the file they will not likely remember to add the .snp file extension to the end of their file name. I was wondering if there is any way I can force the user to save the file as a Snapshot file or to save the file with .snp file extension at the end.

Thanks in advance for the help.

Collen

 

[Crowley16]

well, instead of setting defaults to all files, set it to *.snp, that will automatically add a .snp extension to the file if none exsists.

or, skip the file dialogue, and generate a set filename/path and save it to that, i.e. don't let your users choose.

--------------------
Procrastinate Now!

 

[bernie10]

Crowley16,
Thanks for the response... I am not setting the default to "all files" myself... the window just defaults to that. So how would I set the default to "*.snp"?

I am going to have to let my user choose his path so option 2 won't work.

Thanks again,
Collen