'OutputTo' won't allow file type selection 1

[Beren1h]

I'm trying to have reports in Access 97 be exported as snapshots when a button is clicked. My code is:

DoCmd.OutputTo acOutputReport, "rpt_BackUp_FT", acFormatSNP, strDirAdd & "_FT.snp"

but the acFormatSNP option doesn't work. I have to take it out and select the file format manaually when it executes. If I insert a number it gives me an error about theose formats not being in the Windows Registry.

Does anyone know what is going on with this?

I'd really like to avoid that extra click!

 

[AlexMidd]

The info I have is to use "Snapshot Format" (WITH the quotes) for this parameter. I use this and it works fine. Have fun! )

Alex Middleton

 

[Beren1h]

D'oh!

Thanks alot. It wasn't documented in the help files and that's all I'm working with (and Tek-Tips too...)


Thanks!