A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Outlook Script: Who to know I and item is used by someone



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old November 30th 07, 10:02 AM posted to microsoft.public.outlook.program_vba
bbnimda
external usenet poster
 
Posts: 94
Default Outlook Script: Who to know I and item is used by someone

Hi All,

To prevent conflict in using my perso Forms, I think about using something
like a flag

I think about using à personal field to put the name of the current user and
release this value when the file is closed

etc...

But perhaps a Built'in fuction can do this ....

any idea Sue ?



--
http://bensoft.miniville.fr/


Ads
  #2  
Old November 30th 07, 02:16 PM posted to microsoft.public.outlook.program_vba
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Outlook Script: Who to know I and item is used by someone

YOu can return the current user in VBA or VBScript behind a custom form with a call to Application.Session.CurrentUser.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"bbnimda" wrote in message ...
Hi All,

To prevent conflict in using my perso Forms, I think about using something
like a flag

I think about using à personal field to put the name of the current user and
release this value when the file is closed

etc...

But perhaps a Built'in fuction can do this ....

any idea Sue ?



--
http://bensoft.miniville.fr/


  #3  
Old November 30th 07, 03:06 PM posted to microsoft.public.outlook.program_vba
bbnimda
external usenet poster
 
Posts: 94
Default Outlook Script: Who to know I and item is used by someone

Excuse me Sue I didn't explain may sefl correctly

here is the situation
Server Exchange 2003 SBS & +/- 5 Outlook 2003
we're 5/6 users using outlook2003 over Lan

User A on computer A is using Outlook 2003 he open the contact item
"John Do" and he is updating some information

User B on computer B open the same contact item 10 sec after User A , User
B want to modify something and save while USER A is still updating the
contact item

How do I know from computer B accout UserB that this Item is currently busy
(User by User A)

I hope this example is more explicit

thks

Actually I use a workarroud solution by putting the name of current user in
a field and save the item
When the item is release I flush that field

When someone open the item, if the field is emplty I allow all operation
otherwise i only allow to see the contact item


this work but...
I have to perform save item twice (at the opening / closing) even if the
user modify nothing on the contact item





"Sue Mosher [MVP-Outlook]" a écrit dans le message
de news: ...
YOu can return the current user in VBA or VBScript behind a custom form with
a call to Application.Session.CurrentUser.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"bbnimda" wrote in message
...
Hi All,

To prevent conflict in using my perso Forms, I think about using something
like a flag

I think about using à personal field to put the name of the current user
and
release this value when the file is closed

etc...

But perhaps a Built'in fuction can do this ....

any idea Sue ?



--
http://bensoft.miniville.fr/




  #4  
Old November 30th 07, 04:39 PM posted to microsoft.public.outlook.program_vba
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Outlook Script: Who to know I and item is used by someone

Use the Item_Open event to stamp user information into a custom property and to check the current value of that property. Then the Item_Close event to clear the user stamp.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"bbnimda" wrote in message ...
Excuse me Sue I didn't explain may sefl correctly

here is the situation
Server Exchange 2003 SBS & +/- 5 Outlook 2003
we're 5/6 users using outlook2003 over Lan

User A on computer A is using Outlook 2003 he open the contact item
"John Do" and he is updating some information

User B on computer B open the same contact item 10 sec after User A , User
B want to modify something and save while USER A is still updating the
contact item

How do I know from computer B accout UserB that this Item is currently busy
(User by User A)

I hope this example is more explicit

thks

Actually I use a workarroud solution by putting the name of current user in
a field and save the item
When the item is release I flush that field

When someone open the item, if the field is emplty I allow all operation
otherwise i only allow to see the contact item


this work but...
I have to perform save item twice (at the opening / closing) even if the
user modify nothing on the contact item





"Sue Mosher [MVP-Outlook]" a écrit dans le message
de news: ...
YOu can return the current user in VBA or VBScript behind a custom form with
a call to Application.Session.CurrentUser.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"bbnimda" wrote in message
...
Hi All,

To prevent conflict in using my perso Forms, I think about using something
like a flag

I think about using à personal field to put the name of the current user
and
release this value when the file is closed

etc...

But perhaps a Built'in fuction can do this ....

any idea Sue ?



--
http://bensoft.miniville.fr/




 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Outlook Script: How to get the number of item in current folder bbnimda Outlook and VBA 1 November 29th 07 01:56 PM
Outlook 2003 Script How to obtain the number of item in a folder ? bbnimda Outlook and VBA 1 June 28th 07 07:33 PM
Item.Save and Item.Close Script causes Outlook 2007 to Crash Rayyan Outlook - Using Forms 6 November 25th 06 04:14 AM
Outlook 2k3 Script: Exporting Task item to Excel news.microsoft.com Outlook and VBA 5 November 8th 06 05:01 PM
Outlook 2k3 Script: Pb saving data in custom item news.microsoft.com Outlook and VBA 1 November 8th 06 03:49 PM


All times are GMT +1. The time now is 05:24 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.