Question

  • Creator
    Topic
  • #2157986

    Print a Report from a current Form entry

    Locked

    by james ·

    Hello All,

    I need some help to work out how I can Print a Report (invoice) from a Form that has just been entered in MS Access 2003.

    i.e. Type in the information into a form and subform then click on a button a the bottom to print the invoice out using a form.

    I hope someone can help.

    Thanks a million.

    James.

All Answers

  • Author
    Replies
    • #2947846

      Clarifications

      by james ·

      In reply to Print a Report from a current Form entry

      Clarifications

    • #2947837

      Button

      by unhappyuser ·

      In reply to Print a Report from a current Form entry

      Set up a button on the form to print the current record.

      EMD

      • #2947808

        Button

        by james ·

        In reply to Button

        Could you please point me in the right direction of some code to do that as I can’t seem to print just the current record, it seems to want to print all the records in the table.

        Thanks,

        JM

        • #2947802

          Here goes

          by unhappyuser ·

          In reply to Button

          Open the form in Design View. Click on the button icon and choose Form Operations under Categories and Print Current Form under Actions. Choose Text or Picture for the icon and Finish.

          EMD

        • #2963679

          print current field from form

          by oss2010 ·

          In reply to Here goes

          Private Sub ???43_Click()
          ‘ chek your id name on you db

          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 “t1”, acViewPreview, , strWhere
          End If
          End Sub

Viewing 1 reply thread