Graph's within forms

[ICCIIT]

I have built my graph's within the forms option in my database as it is a pop up database and I could not get the reports to work this way.

My question is I use the following command when printing docmd.runcommand accmdprint which brings up the print dialog box, however when the user selects the printer and clicks okay to print, they get a print for every record stored on that form.

What I need is for the printer to only print page 1 of 1, can anybody help me please.

 

[Larsson]

Well, you could tell your users to select the option "Selected records" on the print form, or you could filter the form first (Me.Filter = "KeyID = " & myKey) or you create a report that show only the selected record in a nice format.

Markus

 

[ICCIIT]

Markus,

I don't think this will work as my graph is already filtered and the screen display's the information required, however it will still print a copy of the graph for every record.

I can default the print command to

Private Sub cmdPrintGraph_Click()
DoCmd.PrintOut , 1, 1

End Sub

However this will only send to the users default printer which is not colour.

Chris

 

[Larsson]

Then I guess that you have to create a report for the graph.

Or you can use some Windows API and change the default printer, then print, and finally change back again.

Take a look at

http://www.mvps.org/access/

Markus