Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2009
    Location
    Ohio, United States
    Posts
    167

    Unanswered: Before Close Event? Popup save message?

    I'm running MS Access 2002 and have a form used for item creation. I'd like it if when someone "X"es out of the form, it would open another form I have asking if they want to save their changes with options "yes", "no", and "cancel". I have accomplished this using the "onclose" event but unfortunately it only opens the confirmation popup after the previous item creation form has been closed. Is there a way to run something "beforeclose" so that the item creation form does not get closed until they click on something in the confirmation popup? Thanks, Joshua

  2. #2
    Join Date
    Aug 2009
    Location
    Up Nort' Wi
    Posts
    140
    Personally I would disable the control box (min/max/close buttons) and create my own exit/close form button...then stuff the exit checking code in the button.

    Sam, hth
    Good, fast, cheap...Pick 2.

  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    ▲ What he said.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  4. #4
    Join Date
    Jan 2009
    Location
    Ohio, United States
    Posts
    167
    I was thinking that too. I just wanted to keep the window border without having the "X" greyed out because it is disabled. I'll probably resort to that. Thanks! Joshua

  5. #5
    Join Date
    Aug 2009
    Location
    Up Nort' Wi
    Posts
    140
    I've set my window borders to Thin and then disabled all the buttons, none of them show at all (Access 97 and Access XP)...nice clean looking windows.

    My relevant Form Properties are this:
    Border Style = Thin
    Control Box = No
    MinMax Buttons = None
    Close Button = No

    hth,

    Sam
    Good, fast, cheap...Pick 2.

Posting Permissions

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