Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Manassas, Virginia, USA
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Printing the correct report for each record. (Access 2002, SP3)

    I have a table containing over 70,000 student records. I have two reports, one in English and one in Spanish. Based on a field in my table called HomeLngCor that would be null for records that will need to print the English version and "138" for records that will need to print the Spanish version of the report. Rather than printing each report separately which would then necessitate quite a bit of manual sorting so that both reports are sorted together by school and within each school by homeroom, how can I make my code print the entire list in the order I want and print one report or the other for each record it comes to.
    Judy Jones, Computer Training Specialist
    Manassas, Virginia

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Printing the correct report for each record. (Access 2002, SP3)

    The only way i could think of would be to duplicate all the controls in the Detail Section of the report, both English and Spanish controls.

    Then i the Format event of the Detail Section you could make the English controls visible and the Spanish controls invisible if the record is English and vice versa.

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Printing the correct report for each record. (Access 2002, SP3)

    Alternatively, you could change the caption of labels according to the language in the On Format event of the appropriate section.

Posting Permissions

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