WUGNET, the Windows User Group Network
Your Complete Resource Center for "The Best" in Shareware, Computing Tips and Support, Windows Industry News... and much more!
Home Forums Shareware Windows Tips Hot Offers FREE Newsletters Arcade Contact Us About Partners
Search WUGNET: RSS Feeds RSS Feeds Advertise with WUGNET    |    Shareware eBooks
HomeHome FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

How to know if a Form.Close Event is the result of canceling

 
   Home -> Office -> Programming VBA RSS
Next:  Is there a "clear form" control for a f..  
Author Message
escamoteur

External


Since: Aug 24, 2009
Posts: 2



(Msg. 1) Posted: Mon Aug 24, 2009 4:05 pm
Post subject: How to know if a Form.Close Event is the result of canceling
Archived from groups: microsoft>public>outlook>program_vba (more info?)

Hi,

I would like to know how can I detect it a user clicked the close button on the titlebar or if the inspector was closed after it's
item was saved. Unfortunately the Close-Events do not provide any information why they are fired.

I use Outlook2007
Best
Tom
Back to top
Login to vote
Ken Slovak - [MVP - Outlo

External


Since: Oct 17, 2003
Posts: 2977



(Msg. 2) Posted: Mon Aug 24, 2009 4:05 pm
Post subject: Re: How to know if a Form.Close Event is the result of canceling [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Handle the Write() event, which fires when an item is saved. You can also
check the Saved status of the item.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"escamoteur" <mail DeleteThis @burkharts.net> wrote in message
news:A3FD6BEA-3A5F-4F36-89BF-60FCD7FA9174@microsoft.com...
> Hi,
>
> I would like to know how can I detect it a user clicked the close button
> on the titlebar or if the inspector was closed after it's item was saved.
> Unfortunately the Close-Events do not provide any information why they are
> fired.
>
> I use Outlook2007
> Best
> Tom
Back to top
Login to vote
escamoteur

External


Since: Aug 24, 2009
Posts: 2



(Msg. 3) Posted: Mon Aug 24, 2009 6:05 pm
Post subject: Re: How to know if a Form.Close Event is the result of canceling [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

My problem is that I have some fields that have to be saved too but that are not mapped to any Item Fields. if only they are changed
I don't get a WriteEvent when closing an item. Also the Saved Status does not change if only one of the unbound Controls have
changed.
Unfortunately it seems that the "Saved" status is read only so you can't mark an item as "unsaved".

I know use a crued work arround. As soon as a control changes that should also set the Item in "unsaved" state I know write to not
used Datafield of the item ans I restore the original value a moment later.
So even if none of the bound controls don't change I can use the"Write Event" to store my unbound data if it was modified.

Best
Tom

"Ken Slovak - [MVP - Outlook]" <kenslovak DeleteThis @mvps.org> schrieb im Newsbeitrag news:uTRmVMPJKHA.1336@TK2MSFTNGP05.phx.gbl...
> Handle the Write() event, which fires when an item is saved. You can also check the Saved status of the item.
>
> --
> Ken Slovak
> [MVP - Outlook]
> http://www.slovaktech.com
> Author: Professional Programming Outlook 2007.
> Reminder Manager, Extended Reminders, Attachment Options.
> http://www.slovaktech.com/products.htm
>
>
> "escamoteur" <mail DeleteThis @burkharts.net> wrote in message news:A3FD6BEA-3A5F-4F36-89BF-60FCD7FA9174@microsoft.com...
>> Hi,
>>
>> I would like to know how can I detect it a user clicked the close button on the titlebar or if the inspector was closed after
>> it's item was saved. Unfortunately the Close-Events do not provide any information why they are fired.
>>
>> I use Outlook2007
>> Best
>> Tom
>
Back to top
Login to vote
Ken Slovak - [MVP - Outlo

External


Since: Oct 17, 2003
Posts: 2977



(Msg. 4) Posted: Tue Aug 25, 2009 10:17 am
Post subject: Re: How to know if a Form.Close Event is the result of canceling [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Why are you using unbound controls at all? Bind the controls to some fields
and get rid of the problem.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"escamoteur" <mail RemoveThis @burkharts.net> wrote in message
news:0CA647FD-E9A9-48BA-941C-25A2E2C29F7C@microsoft.com...
> My problem is that I have some fields that have to be saved too but that
> are not mapped to any Item Fields. if only they are changed I don't get a
> WriteEvent when closing an item. Also the Saved Status does not change if
> only one of the unbound Controls have changed.
> Unfortunately it seems that the "Saved" status is read only so you can't
> mark an item as "unsaved".
>
> I know use a crued work arround. As soon as a control changes that should
> also set the Item in "unsaved" state I know write to not used Datafield
> of the item ans I restore the original value a moment later.
> So even if none of the bound controls don't change I can use the"Write
> Event" to store my unbound data if it was modified.
>
> Best
> Tom
Back to top
Login to vote
Display posts from previous:   
       Home -> Office -> Programming VBA All times are: Eastern Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Categories:
 Windows XP
 Windows Vista
 Windows Other
  Office
 Office Other
 Security
  • Home |
  • Shareware |
  • Windows Tips |
  • Hot Offers |
  • FREE Newsletters |
  • Arcade |
  • Forums |
  • eBooks |
  • About WUGNET |
  • Partners |
  • Contact

  • WUGNET Privacy Policy |
  • Link to WUGNET |
  • IT Support