need report help! thanks guys - simple i am sure for you!

[Guest]

hey - i have a button on a form that opens a report. when i click that
button it seems as tho the report gets printed!
i want to open a report by clicking a button without printing - just view on
screen.
is that possible?
thanks!

 

[Rick Brandt]

hey - i have a button on a form that opens a report. when i click that
button it seems as tho the report gets printed!
i want to open a report by clicking a button without printing - just view on
screen.
is that possible?
thanks!

Look at the code for your button. It will be using the OpenReport method of
DoCmd. The second (optional) argument for that method controls this. It
defaults to acViewNormal. You need to use acViewPreview instead.

 

[Guest]

Yes, it is. Here are a couple of examples:

Unfiltered report:
DoCmd.OpenReport ReportName:="rptEmployees", View:=acPreview

Filtered report:
DoCmd.OpenReport ReportName:="rptEmployees", View:=acPreview, _
WhereCondition:="EmployeeID = " & Me.cboSelectEmployee


where "rptEmployees" is the name of the report, and "cboSelectEmployee" is
the name of a combo box on the form, for the filtered report. Make the
appropriate substitutions.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

hey - i have a button on a form that opens a report. when i click that
button it seems as tho the report gets printed!
i want to open a report by clicking a button without printing - just view on
screen.
is that possible?
thanks!

 

[Guest]

TOM YOURS WORKED PERFECT THANKS GUYS!

 

[Guest]

Here is the code for behind your button:

Dim stDocName As String

stDocName = "rptReportName"
DoCmd.OpenReport stDocName, acPreview