Re: Need some help with Exit Event

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Matt,

You would have to hive it off somewhere, like a hidden worksheet or a text
file, and then the next time you open the form, re-in state it. All manual I
am afraid.

ans = MsgBox("Save the Form", vbYesNo)
If ans = vbYes
'call the save routine
Else
End
End If

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Matt" <mlaipple@xxxxxxxxx> wrote in message
news:1112283327.883933.50200@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Good point Bob- Any idea of code that would allow the data to be saved
> as well.
>
> I'm also looking for a pop-up box which upon pressing the exit button
> would ask the user if they wanted to save the form w/ data -- if yes
> would save and if no would exit the entire application.
>
> Thanks for everyone's help!
>


.

Relevant Pages

  • Re: Exit status or function return value?
    ... function calc, which must be 0. ... The "return $ans" command sets the function's exit status to $ans. ... echo "Function cal requires atleast three args" ...
    (comp.unix.shell)
  • Re: The Promise of Forth
    ... ANS Forth and won't work on all systems, ... have aptly-named words that execute EXIT to bail out from the ... IF EXIT THEN ... ... POSTPONE 0= POSTPONE IF POSTPONE EXIT POSTPONE THEN; ...
    (comp.lang.forth)
  • Re: class object using widget
    ... # get widget classes from tkMessageBox ... def quit: ... ans = askokcancel('Verify exit', ... "Really quit?") if ans: Frame.quit ...
    (comp.lang.python)
  • Re: The Promise of Forth
    ... ANS Forth and won't work on all systems, ... have aptly-named words that execute EXIT to bail out from the ... IF EXIT THEN ... ... compiled fresh every time you use it. ...
    (comp.lang.forth)