Print Button

[Julie Smith]

Hi,
How do I make a button on a form to print a Report of pages 1 to 1? That is,
print only the first page?

Thank you in advance.

 

[tina]

are you talking about printing the "first page" of data from the *form*? and
does "one page" in the form equal one record? if so, use the OpenReport
action in a macro or VBA code, to print the report, including a WHERE clause
in the action's argument. suggest you read up on the OpenReport Action topic
in Access Help, so you'll understand how it works.

hth

 

[Julie Smith]

I have a report that shows data from a query. It is usually over 10 pages,
but I only want to print the first page. Rather than opening the report each
time and printing page 1to1, I just want a button on a seperate form that
will do this operation.

 

[tina]

you can use a macro or VBA code to open the report in PrintPreview, then
PrintOut the first page, then close the report again. because the three
actions are run one after the other, the user doesn't have to manually open,
print, and close the report. read up on the OpenReport Action and PrintOut
Action in Access Help so you'll understand how to use them.

hth