Printing Access Reports

[rushworld]

I need information on printing an MS Access Report through a VB command line/s.
What is needed is a query to select one record and print on one page, can this be done easily?
Also any options to output to Print Preview, or a text file, or something. Printing is the main portion though.
Thanks for any help.

 

[Zeroanarchy]

rushworld prob the easy way is to create the repot in your access backend, for the query side you can create that inside the report its self by going to
Design -> report properties -> record source -> ...

create the report but only save it on the way out this way it will be embedded into the report and it will not create an external query.

then in VB create a button that prints the report.
using the access line.
DoCmd.OpenReport "reportname", acNormal

Hope this helps
Zero Anarchy

 

[CCLINT]

Check out the SnapShot viewer from the MS Site (

http://www.microsoft.com)

[/b][/i][/u]*******************************************************
[sub]General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!

 

[rushworld]

Thanks alot guys, that helped alot