By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,124 Members | 2,027 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,124 IT Pros & Developers. It's quick & easy.

Outputting filtered report in snapshot format

P: n/a
Hi all,

The following code works to output a report myReport, to a file myFile, in
..snp format.

---------
DoCmd.OutputTo acOutputReport, "MyReport", "Snapshot Format", MyFile
---------
However I wish to output a filtered report, as I would generate the report,
example below

-----
DoCmd.OpenReport MyReport, acViewPreview, , stLinkCriteria
------

where sLinkCriteria is my filter string.
Is the a way to solve this .

Any advice most welcome.
Gerry Abbott


Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Sorry Guys/Gals, think i posted prematurely,,

found a thread which should answer my query

http://groups.google.com/groups?hl=e...=20191eb9f7d92
796&rnum=22
Thanks,

"Gerry Abbott" <pl****@ask.ie> wrote in message
news:Ym*****************@news.indigo.ie...
Hi all,

The following code works to output a report myReport, to a file myFile, in
.snp format.

---------
DoCmd.OutputTo acOutputReport, "MyReport", "Snapshot Format", MyFile
---------
However I wish to output a filtered report, as I would generate the report, example below

-----
DoCmd.OpenReport MyReport, acViewPreview, , stLinkCriteria
------

where sLinkCriteria is my filter string.
Is the a way to solve this .

Any advice most welcome.
Gerry Abbott

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.