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

Printing Problems

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

  1. Geoff

    Geoff
    Expand Collapse
    Guest

    I am printing out from a Form and request printing of Selected Record. The
    first record prints OK but then the second record each time shows an error
    with Access closing down
     
  2. Loading...

    Similar Threads Forum Date
    Controversial War over Private Printing of "Birs" Intensifies Hard Talk Jul 9, 2011
    Sikh News Sikhs Face Problems While Carrying Kirpans In Khyber-Pakhtunkhwa - SikhSiyasat.Net Breaking News Jul 29, 2016
    "Dasam" Granth - A Look At The Core Problems Dasam Granth Oct 21, 2015
    Problems In Life Sikh Sikhi Sikhism Apr 13, 2015
    Muslim Girl-Sikh Boy Marriage Problems- Please Help! Love & Marriage Oct 12, 2012

  3. Rick B

    Rick B
    Expand Collapse
    Guest

    Not sure what you mean. If you have one record on a form, and you wish to
    print a report that only contains that record, what do you mean by "the
    second record..."? I thought you were only printing the current record?

    Here is an example of what your code should look like...

    Private Sub cmdPrint_Click()

    Dim strWhere As String

    If Me.Dirty Then 'Save any edits.

    Me.Dirty = False

    End If

    If Me.NewRecord Then 'Check there is a record to print

    MsgBox "Select a record to print"

    Else

    strWhere = "[ID] = " & Me.[ID]

    DoCmd.OpenReport "MyReport", acViewPreview, , strWhere

    End If

    End Sub



    Notes: If your primary key is a Text type field (not a Number type field),
    you need extra quotes: strWhere = "[ID] = """ & Me.[ID] & """"

    If you want the report to print without preview, replace acViewPreview with
    acViewNormal.



    See also: http://allenbrowne.com/casu-15.html




    --
    Rick B



    "Geoff" <Geoff@discussions.microsoft.com> wrote in message
    news:E4096926-0AC4-41CA-B2D4-8CC2C30B0B15@microsoft.com...
    >I am printing out from a Form and request printing of Selected Record. The
    > first record prints OK but then the second record each time shows an error
    > with Access closing down
     
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