Results 1 to 2 of 2
  1. #1
    3 Star Lounger Jimmy-W's Avatar
    Join Date
    Jan 2001
    Location
    Helena, Montana, USA
    Posts
    220
    Thanks
    13
    Thanked 0 Times in 0 Posts

    Printing non-consecutive records (2000)

    Is there a way to select for printing multiple, non-consecutive records in a table? In the datasheet view, it seems that I can select only consecutive records. Thanks,
    JimmyW
    Helena, MT

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Printing non-consecutive records (2000)

    >>Is there a way to select for printing multiple, non-consecutive records in a table? In the datasheet view, it seems that I can select only consecutive records.<<

    Put a multiselect listbox on a form, with its rowsource being the table you want to draw from. Add a print button to print the report you want. The wizard will create button for opening a report, which will be in the button's OnClick event. You will have to add code to create a WHERE clause which lists all selected items from listbox.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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