Print Report from Form button 1

[drewson]

I want to have a button on my form that prints off a report. I've figured out to use this line of code to just print it to the default printer:

stDocName = "RepairOut"
DoCmd.OpenReport stDocName, acViewNormal

But I want the printer dialog to come up so I can let the user select the printer. Any ideas?

Thanks.

 

[randy700]

DoCmd.OpenReport stDocName, acViewPreview

Then, when you select print from the file menu, your printer dialog will come up.

 

[Wizzweb]

Hi

I'd be interested to know your results on this problem as I have just posted a thread elsewhere for a very similar problem.

I want to print a Single Record from a Form in a Report

Ken

 

[jimb0ne]

if you want to print a single record, wizzweb, you could just use the docmd.openreport, but set the wherecondition parameter to a value that is unique for the record you want to print, that way only that record would appear in the report.

drewson and wizzweb,
There is a post in this forum from awhile back outlining a procedure for making the printer dialog come up without having to use acviewpreview, I'll try to track it down.

 

[randy700]

Use a WHERE condition.....

Dim strCondition as String
strCondition = "FieldName = '" & me.txtName & "'" (if txtName is text)
OR
strCondition = "FieldName = " & me.txtAge (if txtAge is a number)
DoCmd.OpenReport stDocName, acViewPreview,,strCondition

 

[jimb0ne]

this article has all the info you'll want,

thread702-672044

and this one is a little less in depth

thread702-675417

 

[drewson]

Thanks... that thread helps a lot

 

[Wizzweb]

Hi All

Thanks alot for the tips. Read back on the old archives, so I wil try them out. Hopefully one day I will get it sorted.

ken