Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Posts
    58

    Unanswered: Printing Problems

    I have a multi page per record access report that is setup to print as a folded stapled booklet, this is fine aslong as you only want to print one record at a time but when you want to print off a group of records at one time using the code

    strFilter = "[ClsDesc] Like " & "'" & Me![cmbForms].Column(1) & "'"
    DoCmd.OpenReport PupilReport_rpt, acNormal, , strFilter

    the printer acts as though all the records are to be printed as one single big booklet rather than several small booklets.

    How would I set it up so it breaks the print run into individual records by only pressing one button?

    Each record has a distinct ID called StuRecID.

    Thanks

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    what sorting and grouping are you using?

  3. #3
    Join Date
    Jan 2004
    Posts
    58
    The report is sorted by the ClsDesc and grouped by the StuRecID field. Report layout wise everything is working fine, the problem is that the printer identifies the report output as being one print job no matter how many records are included in the run, ie: each record consists of 5 pages if one record is printed at a time then the printer will fold and staple the 5 pages as one single booklet, if 3 records are sent to print at the same time the printer will fold and staple 15 pages as one single booklet rather than the required 3 booklets of 5 pages each.

    I am after some code that will send each individual record as one print job. At present I have had to set up a form with a combo box listing every single record, and a button that prints just the selected record, so I have to select a record, press print, change to another record, press print, etc. This takes ages when there are around 200 records.

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    so you have a specialised report, going to a specific printer.

    I'd be tempted to read the printer manual and find what code forces a group or staple, and place that in the group footer.

    Whether you can do that int he windows world I don't know, but that sort of trick was required in the so called bad old pre windows days

    undoubtedly you will need to use an ASC or CHR character code


    if that doesn't work then you coudl automate the process, by calling the report with each customer.

    build a recordset with the customers
    iterate through that recordset, calling the report with the appropriate parameters.

    so have a look at opeing a recordset (DAO or ADO)
    look at how to iterate through a recordset (have a look at the appropriate recordset .EOF)
    have a look at the macro command to open a report (docmd.openreport).. look at the parameters you need to pass to make sure the report prints.
    HTH

Posting Permissions

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