printing reports in visual basic

[j_lyver]

what i need to do get a code and creates and query in visual basic. and prints the report. also i need to extend the limit on the page size from 21 to 31 on the report.

[smalig]

What report? When you ask anything, please describe your problem completely.

If you use ms access you need follow code.

--------------------

Dim RApp=New Access.Application

RApp.openCurrentDatabase("d:\db1.mdb")
reportname="reportname"

RApp.DoCmd.OpenReport reportname,acViewNormal

RApp.CloseCurrentDatabase
Set RApp=Nothing

------------------
smalig
[email protected]
smalig.tripod.com