export as snapshot

[LGarcia]

Hi all,
I have a report that I need to export as a snapshot. Is it possible to use a
macro or code to have this happen? I would like the user to only have to
choose the destination and give it a new name.
TIA,
LGarcia

 

[David Aylott]

Try something like this:

Dim strRpt As String 'name of Access report
Dim strSnap As String 'path & name of snapshot report

DoCmd.OutputTo acOutputReport, strRpt, "Snapshot Format", strSnap,
True

Hi all,
I have a report that I need to export as a snapshot. Is it possible to use a
macro or code to have this happen? I would like the user to only have to
choose the destination and give it a new name.

,-._|\ David Aylott (Author of Access Version Checking utility)
/ Oz \ (e-mail address removed) (Melbourne, Australia)
\_,--.x/ Shareware, FAQ, hints & tips at:
v http://www.aylott.com.au/