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!
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!