Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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. 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...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     

Share This Page