Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    Feb 2003
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Quitting Access (2002)

    I'm having a problem when someone closes a database by clicking on the X in the top right corner instead of going back to the Quit Button on the switchboard. You get a VB End/Debug error message from the Form that is open at the time.

    I'm looking for a way to avoid VB error messages when Access closed by using the X. If that isn't possible then is there a way to get rid of the X and force the person to close down properly.

    Thanks for the suggestions.

    Paul

  2. #2
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Atlanta, Georgia, USA
    Posts
    274
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Quitting Access (2002)

    Here is an example of something I put together some time ago. I think there is enough info to get you started.
    Scott
    Attached Files Attached Files

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

    Re: Quitting Access (2002)

    Hi Paul,

    I also use the method used in the database posted by Ready4Data (a global boolean variable that controls closing the of main form and thereby of the database). It works very well.

    As an addition, you can disable (gray out) the "x" close button of the Access application window. See How to Disable the Close Button (X) on the Access Application Window and the Exit Command on the File Menu.

  4. #4
    3 Star Lounger
    Join Date
    May 2002
    Location
    Toronto, Ontario, Canada
    Posts
    314
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Quitting Access (2002)

    Would it be too much to ask you to post the example for '97 as well??... I'd love to see it but I only have Access 97 at work... <img src=/S/please.gif border=0 alt=please width=31 height=23>

  5. #5
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Atlanta, Georgia, USA
    Posts
    274
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Quitting Access (2002)

    As requested.
    Attached Files Attached Files

  6. #6
    3 Star Lounger
    Join Date
    May 2002
    Location
    Toronto, Ontario, Canada
    Posts
    314
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Quitting Access (2002)

    <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15> Scott

Posting Permissions

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