[gulch]

It's like the title said: how can I print a certain page from a report from Access using visual basic?

I hope it's called report, in dutch it's called like that anyways.
Thanks for any feedback.

its in vb.net btw

This post has been edited by gulch: 03 March 2007 - 06:55 AM

[Amadeus]

When you say print, do you mean to actually send the page to a physical printer?

[gulch]

yes, to actually print it on paper, that's the meaning

This post has been edited by gulch: 02 March 2007 - 07:27 AM

[gulch]

anyone?

[NickDMax]

Well 1 you could hit the print button on the tool bar. I am assuming that you would like to do it programaticly from within VBA or from within an external application?

From inside VBA: The key is the PrintOut method of DoCmd.

DoCmd.SelectObject(ObjectType:=.acReport, ObjectName:="Employees", InDatabaseWindow:=True)
DoCmd.PrintOut(PrintRange:= acPrintAll, Copies:=2, CollateCopies:=False)

You can also print a report out from the OpenReport method.

OpenReport(ReportName:="Sales",  View:=acViewNormal)

[gulch]

not in vba, but in vb.net

edit: will this code also work in .net?
and how can i select a certain page like 300 from a report which contains 600 pages? It's probably the range, but stil, to what do i have to set it?

This post has been edited by gulch: 03 March 2007 - 06:55 AM