Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Outlook / Programming Forms / January 2005

Tip: Looking for answers? Try searching our database.

Reading Button status

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
sparkle_guy - 29 Jan 2005 17:51 GMT
When you close a form it shows a dialog box that says "Do You Want To Save
Changes" with Yes No and Cancel Buttons. How do you check which button is
clicked. I can do this with a dialog box that I generate(e.g. msgbox()) but
not with system dialog boxes.

Thanks in advance
Paul
Jim Vierra - 29 Jan 2005 18:28 GMT
   If vbOK = MsgBox("prompt", vbOKOnly, "title") Then
   End If

Signature

Jim Vierra 661815

> When you close a form it shows a dialog box that says "Do You Want To Save
> Changes" with Yes No and Cancel Buttons. How do you check which button is
[quoted text clipped - 4 lines]
> Thanks in advance
> Paul
Jim Vierra - 29 Jan 2005 18:38 GMT
Sorry about the last answer.  I was doing something else and forgot what I
was reading.  Hit send and - bang - realized I missed the point.

What application is the form being closed in?  Obviously you have changed
the form in some way so you must catch the updated or "on close" event.

In Access you would catch teh before update and after update evebts or catch
it on the dataset.  The return from the event determine the outcome.

If you are in a form designer then you can't catch it.  It may be catchable
in some applications like Outlook but you have to programatically open the
form in design mode and handle the event in other ways.

It would be more helpfull if we had more info.

Signature

Jim Vierra 661815

> When you close a form it shows a dialog box that says "Do You Want To Save
> Changes" with Yes No and Cancel Buttons. How do you check which button is
[quoted text clipped - 4 lines]
> Thanks in advance
> Paul
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.