Printing

C

Chi

Hi,

I have a report that has 12 pages. I would like to print the first page only.

Would you please show me how to do it?


Thanks
Chi
 
A

Andrew S.

Sure thing, with the report open go to the File menu -> Print... and in the
window that pops up you will see a section labeled "Print Range". In this
section, select "Pages" instead of the default "All", and type "1" in the
From: field and "1" in the To: field. (Access 2003) This defines the print
range.

For Access 2007 it's very similar, only instead of the old File menu you
click on the Office icon which houses the same functions as the File menu it
replaces. For there the same print options are available.

Good luck!
 
C

Chi

Hi Andrew,

Thank you for your response! Would you please show me to create a marco and
then include it in a button?


Chi
 
F

fredg

Hi,

I have a report that has 12 pages. I would like to print the first page only.

Would you please show me how to do it?

Thanks
Chi
Click to expand...

DoCmd.SelectObject acReport, "ReportName", True
DoCmd.PrintOut acPages, 1, 1

The above will print just the first page of the report.
The report must not already be open.
If the report is already open in Preview, change True to False
 
A

Andrew S.

I know very little about creating macros myself, but attaching one to a
button is easy enough. :)

Once you place your button (or drop-down list, or checkbox, or whatever) on
your form, you can then right-click on it and select "Properties". Here, in
the Event tab, you can attach a macro to the button whenever it's clicked.
Just use the drop-down list to select an existing macro to a specific event,
or you can click the "..." icon next to the drop-down list to bring up the
Macro Builder.

Notice you can also have macros or events execute for all sorts of events,
ranging from simply waving a mouse over the thing you're working with, or
double-clicking on it, or all sorts of other options.
 
C

Chi

Hi Andrew,

Again, Thank you so much for helping me on printing.

I don't know much about marco either. Please let me know when you have any
ideas on writing marco or VBA.
Chi
 
Top