Results 1 to 3 of 3
  1. #1
    genest11 is offline Novice
    Windows XP Access 2000
    Join Date
    Jan 2010
    Posts
    19

    Cool Print Single Envelope From Form

    I created a form that I use to input and review a person's name, mailing address and other information into a table. What I would like to do is select one name from the form and print an envelope with name and address directly onto the envelope without having to do a mail merge. Ideally, select the person and click a button on the form to print a mailing envelope. I currently review and print reports from this input form.



    I have searched the forum for a related question but came up empty. Could someone point me in the right direction or provide some insight on how this may be accomplished? Thank you.

  2. #2
    genest11 is offline Novice
    Windows XP Access 2000
    Join Date
    Jan 2010
    Posts
    19
    I have muddled my way into being able to print an envelope from my form.
    1. I first created a report named Envelope2;
    2. I put a command button on the form using the wizard;
    3. I modified the Click event procedure (in the command button’s properties) in Visual Basic from this:

    Private Sub Prnt_Recd_Click()
    On Error GoTo Err_Prnt_Recd_Click

    DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
    DoCmd.PrintOut acSelection

    Exit_Prnt_Recd_Click:
    Exit Sub

    Err_Prnt_Recd_Click:
    MsgBox Err.Description
    Resume Exit_Prnt_Recd_Click

    End Sub

    To this:

    Private Sub Prnt_Recd_Click()
    On Error GoTo Err_Prnt_Recd_Click

    Dim strDocName As String
    Dim strFilter As String

    strDocName = "Envelope2"
    strFilter = "ID = Forms!Homebuyers1!ID"
    DoCmd.OpenReport strDocName, acViewNormal, , strFilter

    Exit_Prnt_Recd_Click:
    Exit Sub

    Err_Prnt_Recd_Click:
    MsgBox Err.Description
    Resume Exit_Prnt_Recd_Click

    End Sub

    Here is the remaining problem:

    When I click the command button the current record is printed on an envelope and then a second envelope is also printed!

    The first envelope is printed with the name, mailing address and return address. A second envelope is then printed with just the return address.

    I am totally ignorant of Visual Basic and this is my first attempt in editing any Visual Basic routines. Does anyone know how I may be able to stop the second blank envelope from printing?

    Access 2000
    Windows XP

    Thank you.

  3. #3
    genest11 is offline Novice
    Windows XP Access 2000
    Join Date
    Jan 2010
    Posts
    19
    Just figured it out!

    It was in the report and the way I set up the envelope layout.

    Thank you to me!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Print Single Report
    By emkwan in forum Access
    Replies: 1
    Last Post: 01-29-2010, 11:19 AM
  2. Print Form problem
    By Stelios Panayides in forum Forms
    Replies: 1
    Last Post: 10-06-2009, 07:06 AM
  3. Print Report from Form ID
    By Brian62 in forum Forms
    Replies: 1
    Last Post: 09-18-2009, 01:50 PM
  4. Replies: 2
    Last Post: 02-10-2009, 12:02 PM
  5. print form
    By vam in forum Forms
    Replies: 0
    Last Post: 05-02-2006, 07:41 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums