Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Print Selected Record

Discussion in 'Information Technology' started by alaskahawk, Jul 28, 2006.

  1. alaskahawk

    Expand Collapse

    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?
  2. Loading...

    Similar Threads Forum Date
    In The Footprints Of Guru Nanak- Fourth Journey In Punjab Sikh Sikhi Sikhism Dec 22, 2016
    In The Footprints Of Guru Nanak-Fourth Itinerary Sikh Sikhi Sikhism Dec 18, 2016
    Footprints Of Guru Nanak In Sri Lanka History of Sikhism May 27, 2016
    Sikhism Preserving The Sikh Heritage In Print Sikh Sikhi Sikhism Jan 12, 2016
    Guru Nanak's Foot-Prints In Baghdad's Sands Blogs Oct 22, 2015

  3. OP
    Albert D.Kallal

    Albert D.Kallal
    Expand Collapse

    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
Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     

Share This Page