Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Oct 2003
    Posts
    77
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Application Close (2000)

    I run a query when a user exits the application to remove his/her name from the "current users" table. I run this query from the Yes click on the confirm exit dialog. This all works fine. I run into trouble when the user closes the app from the "X" (close button) in the upper right hand corner of the Access window (which does not launch my confirm exit dialog). Where do I put the code to either: launch my confirm exit dialog from that "X" or run my query when the user exits using the "X". Your help is always appreciated. Thanks.

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

    Re: Application Close (2000)

    You can disable the close button of the Access application window. See MSKB article ACC2000: How to Disable the Close Button (X) on the Access Application Window.

    You can also prevent the user from closing a form except by clicking a command button on your form. See for example <post#=94249>post 94249</post#>.

  3. #3
    Star Lounger
    Join Date
    Mar 2003
    Location
    Ilkeston, Derbyshire
    Posts
    62
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Application Close (2000)

    I wondered how that could be done.

    Thanks Hans

    Mark

  4. #4
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Schenectady, New York, USA
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Application Close (2000)

    <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16> Thanks Hans, i have been <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15> on this for sometime. Three cheers to you. <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16> <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    Don
    <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18> <img src=/S/flags/NewYork.gif border=0 alt=NewYork width=30 height=18> "Life on Earth is expensive, but at least it includes a free trip around the Sun."

Posting Permissions

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