Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2011

    Unanswered: Selectively printing mailing labels

    OK, I've worked out the very simple process of printing mailing labels of the entire data table. But what if I want to do a selective print of only some of the database.

    I have a members ledger for a club. One of the fields is 'Member Type'. The records in this field are one of the following types: O, L, D or X. Is there a way I can print labels for only one or two of these types - say O and L?

    Or is there some other way I can select or deselect records to print? I suspect is is easy - if you know how.


    Norm C

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    its all part of the query that feeds the label report

    set the parameters for that rowsource using a form which validates the input,

    then you need to use thos parameters int he reprot, possibly the most straightforward if to use a filter when you call the report using say a button on that form that calls the following code.. note you will have to change the myreportname, membertype and my parameter to appropriate values

    DoCmd.OpenReport "myreportname", acViewPreview, , "myMemberType = '" & myParameter & "'"

    the other way is to reset the reports rowsource at runtime
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts