Welcome to SPN

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

Sign Up Now!

RE: Print Just One Record From A Report

Discussion in 'Information Technology' started by Sterdog, Nov 4, 2005.

  1. Sterdog

    Expand Collapse

    see if you can figure mine out: "Report name: recon form" "Primary Key:
    Record Number" "Control Source: Record Number (i think?)

    Private Sub print_reconform_Click()
    On Error GoTo Err_print_reconform_Click

    Dim stDocName As String

    strWhere = "Record number = " & Me![Record Number]
    stsstDocName = "Recon form"
    DoCmd.OpenReport stDocName, acViewPreview, , strWhere

    Exit Sub

    MsgBox Err.Description
    Resume Exit_print_reconform_Click

    End Sub

    "Sprinks" wrote:

    > Hi, Jackson.
    > Re: Procedure That Isn't Working
    > Please post it (cut and paste directly from the VBA Editor), and the names
    > of your report, the primary key of its RecordSource, and the corresponding
    > control on your form that has the key data, and I'll see if I can figure it
    > out.
    > Re: Learning Access
    > I'm afraid I can't help you much with formal courses to take; if it's been a
    > useful experience for you, try to get a detailed list of topics for each
    > available course and match them up with your needs & interests.
    > There are other excellent sources available in learning to develop
    > applications:
    > - the Northwind database that comes with Access demonstrates forms and
    > subforms, and many programming issues. Use the application, then investigate
    > the code behind command buttons, and the table structures, etc. See the Help
    > menu.
    > - create command buttons for various events with the wizard, and study the
    > code the wizard creates.
    > - Access 2002 Developer's Handbook by Litwin, Getz, & Gilbert. Parts of it
    > are advanced; there are other texts aimed at the basics, but I don't know
    > what they are.
    > - check out Jeff Conrad's recent (2-3 months) comprehensive post about
    > Access web resources. It's been awesome.
    > Hope that helps.
    > Sprinks
    > "Jackson" wrote:
    > > Sprinks,
    > >
    > > I copied the code and placed it in the proper place. It brought up the
    > > report with only one record as required but it did not let it print
    > > automatically. I got it to work once and only once. So I started all over
    > > and I still can't get it to work. Please help because I'm going to half to
    > > use this routine a lot.
    > >
    > > Also I took a course in Access 2003 and I'm having a great time designing
    > > our database at work, however the course did not go into vbl.
    > >
    > > Do you have any suggestions as to what to take next. I see vbl V6, Vbl.net
    > > and sql that other students have taken. I want to take another course but I
    > > need it to go with Acess. Any suggestions?
    > > Thank,
    > > Jackson
  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

Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     

Share This Page