PC Review

Thread Tools Rate Thread

Print Selected Record

Posts: n/a
      13th Jul 2006
I have a form that is larger than 8.5" and the area of the form that contains
the information that I want to print is less than this -- how can I print the
selected record (using File --> Print) only on one 8.5 x 11 page without all
the other "junk" (buttons on the right of my form which don't need to print
but will print on page 2).

Make sense?
Reply With Quote
Albert D.Kallal
Posts: n/a
      13th Jul 2006
The best approach in these cases is to simply layout and build a report.

Reports are actually for being printed, and thus you can have things like
page number, or all kinds of things that make no sense at all on a form.


forms = good idea for data entry
reports = good idea for printing

The trick is thus to build/layout the report the way you want. Then, place a
button on your form, and have that button RESTRICT the report the ONE
CURRENT record. The following code will do this

me.refresh ' write current record to disk (so report can use data)

docmd.openReport "YourNiceReprot",acviewPreview,,"id = " & me!id

The above assumes your current record does have a primary key of id (most
table do have this....but, if you used something different, then change id
to whatever you used for the primary key of the record).

Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
(E-Mail Removed)

Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
REQ Help: Adding record to a table that is related to a selected record Peppie Microsoft Access Macros 4 30th Aug 2006 11:24 AM
2 subforms only one clears its record when new record selected naigy via AccessMonster.com Microsoft Access VBA Modules 9 10th Jul 2006 02:27 AM
Go To Main Form Record from selected subform record =?Utf-8?B?UmljaCBK?= Microsoft Access Forms 3 28th Dec 2004 07:11 PM
Creating a new record from selected fields of existing record =?Utf-8?B?U3Vl?= Microsoft Access 4 6th May 2004 04:53 PM
Creating a new record from selected fields of existing record Sue Microsoft Access Forms 3 6th May 2004 04:20 PM




All times are GMT +1. The time now is 02:23 AM.