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 Invoice Report from Form

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

  1. Levans digital

    Levans digital
    Expand Collapse
    Guest

    Help Please?

    I have a form that is link to a report but to have the latest data on on the
    form print on the report I had to manually put a "refresh" command button on
    the form.
    So to print I must click "refresh" then click "Print" can the form
    automatically refresh on its on just before I hit the "Print" button?

    Thanks again
     
  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. Sprinks

    Sprinks
    Expand Collapse
    Guest

    Open the form in Design view, and right-click on the Print command button.
    Select Properties, then the Events tab. Cursor into the OnClick field, and
    click the ellipsis to the right, then Code Builder, if prompted. You will be
    placed in the Visual Basic editor for this command button.

    Right after the On Error... line, place the refresh code:

    DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70

    Save and test it. When you're sure it's working, you can delete the Refresh
    button.

    Hope that helps.
    Sprinks

    "Levans digital" wrote:

    > Help Please?
    >
    > I have a form that is link to a report but to have the latest data on on the
    > form print on the report I had to manually put a "refresh" command button on
    > the form.
    > So to print I must click "refresh" then click "Print" can the form
    > automatically refresh on its on just before I hit the "Print" button?
    >
    > Thanks again
     
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