• Updating a Table after Printing (Access 97/SR2)

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Updating a Table after Printing (Access 97/SR2)

    Author
    Topic
    WSPaulK
    AskWoody Lounger
    July 2, 2001 at 3:01 pm #357622

    I’m looking for alternative suggestions for recording data and updating data after a report has printed as I am not 100% satisfied with my method. I have a table which contains client id’s and a type field which can either be ‘O’ or ‘P’. When the type is changed from ‘O’ to ‘P’ the record will appear on a label report. It is required to record that a record has been printed and when. My method includes running an update query which records the date the report was printed. The update query also changes a yes/no field from no to yes to show that the record has been printed. That’s probably redundant but that’s the way they want it. Originally the report was printed directly to the printer without previewing. I created a small procedure called from a switchboard button that prints the report and then runs the update query. Now they want to preview the report before printing – a reasonable request – but it introduces a variable into the process and that is the possibility of closing the report preview without running the report. I looked for a unique event that occurred either during the report printing or after the report was printed. The best I could do was the report page event. But this event occurs also when the report is previewed. So, I created a global variable which I increment by one each time the event occurs. Then in the close event of the report I check the value of the global variable and if it is greater than one I run the update query. I’ve tested it and it works but I’m not entirely comfortable with it. I would interested in hearing any alternative suggestions or comments. TIA.

    Reply | Quote
    Viewing 0 reply threads
    Author
    Replies
    • WSMarkLiquorman
      AskWoody Lounger
      July 2, 2001 at 6:28 pm #531668

      There is, unfortunately, no way to do this. The only thing I can suggest is that you define a custom toolbar and menubar for the report, so that a Print option is not provided if they Preview it. This way, users will be forced to select your normal print routine to get it printed.

      Reply | Quote
      • WScharlotte
        AskWoody Lounger
        July 3, 2001 at 2:33 am #531717

        Actually, you could put a print button on a custom toolbar that only displays when you preview the report. That’s what I generally do, since I don’t allow the built-in toolbars and menus to be available. That could be used to call a routine to log the print job after the command to print the report.

        It still isn’t perfect, especially on a network where the report may be spooled to a printer but never actually get printed.

        Reply | Quote
        • WSMarkLiquorman
          AskWoody Lounger
          July 3, 2001 at 11:35 am #531744

          Good idea. However, you still need to keep user from selecting the File | Print option.

          Reply | Quote
          • WScharlotte
            AskWoody Lounger
            July 3, 2001 at 1:53 pm #531763

            He can’t select it if the menu isn’t available. I use only custom menubars in my apps, and the reports have their own menubar that includes a Print button. It only appears when the report is open, which means, in effect, open in preview. Otherwise, they’re working with a menu that doesn’t include the print option. In fact, the main menu I display has nothing on it but an Exit button unless I use menus instead of a switchboard.

            Reply | Quote
    Viewing 0 reply threads
    Reply To: Updating a Table after Printing (Access 97/SR2)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    March 2025
    S M T W T F S
     1
    2345678
    9101112131415
    16171819202122
    23242526272829
    3031  

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.