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

    Prevent 'Printing' Message (Version 2000)

    I have code that is sending a report to an ascii file so that the link I have created to that ascii file can be used as the basis for a crosstab query. Is there a way to prevent the message from appearing on the screen that the report is printing? I think my users will be confused by this since there is no print job being sent to their printer until much later in the program.
    Judy Jones, Computer Training Specialist
    Manassas, Virginia

  2. #2
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Prevent 'Printing' Message (Version 2000)

    Could you reproduce the report data in a query and use the query data for your cross tab instead?

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

    Re: Prevent 'Printing' Message (Version 2000)

    I use the ascii file created from a report in order to provide a count that increments for each record in my database. Each student involved in an incident/event may have violated several rules, up to a maximum of 5. For example, they may be guilty of Alcohol Possession, Fighting, Weapon Possession, etc. For each of these rule violations there is a separate record in the table for StudentCodes along with their student # and event #. In order to compare discipline administered for each incident/event I need to display the charges against each student in a crosstab such as charge #1, charge #2, charge #3, charge #4, charge #5. The only way I could think to accomplish this was to create a report that writes to an ascii file and numbers each charge, resetting the number with each student. The crosstab query that uses the ascii file, displays the student # and each of the charges against a student on the same row.
    Without using the ascii file, I know of no way to accomplish this.
    Judy Jones, Computer Training Specialist
    Manassas, Virginia

Posting Permissions

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