Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / December 2005

Tip: Looking for answers? Try searching our database.

OutputTo /Parameter Query

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
MJatAflac - 19 Dec 2005 21:12 GMT
Does anyone know if there are issues using the Output method to save a report
to a snapshot file when the report you are generating is based on a parameter
query.

I am getting error messages when I try to do this and the only thing I can
think of that might be causing the problem is the fact that the report
requires user input.

Anyone with experience with this one?

Thanks,

Signature

Michal Joyce
Project Management IS Analyst
Aflac - Project Management Office

Alex Dybenko - 20 Dec 2005 07:20 GMT
Hi.
you can build a query for the report, replacing parameters with actual
values, use this query as a report source, and then export it to snapshot
using docmd.outputto

Signature

Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

> Does anyone know if there are issues using the Output method to save a
> report
[quoted text clipped - 9 lines]
>
> Thanks,
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.