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

create auto number field in task form



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old February 24th 10, 01:39 PM posted to microsoft.public.outlook.program_vba
Diana
external usenet poster
 
Posts: 21
Default create auto number field in task form

Hi All,

I’m trying to create a textbox field on a task form-Outlook 2003-
and every time I open the task or click on txtbox , the number in it
incremented by 1
like a serial number for the tasks.
If anyone can show me the vbscript code to do that, I’ll be grateful

--
Thanks
Diana
Ads
  #2  
Old February 24th 10, 05:25 PM posted to microsoft.public.outlook.program_vba
Joel Allen
external usenet poster
 
Posts: 117
Default create auto number field in task form

Is it the same task? If so, make your field an integer. It will start with
0. Then in your code.....

Function Item_Open()

Item.UserProperties("YourField") = Item.UserProperties("YourField") +1

End Function



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

I'm trying to create a textbox field on a task form-Outlook 2003-
and every time I open the task or click on txtbox , the number in it
incremented by 1
like a serial number for the tasks.
If anyone can show me the vbscript code to do that, I'll be grateful

--
Thanks
Diana



  #3  
Old February 25th 10, 07:05 AM posted to microsoft.public.outlook.program_vba
Diana
external usenet poster
 
Posts: 21
Default create auto number field in task form

thx for replying Joel,.
Actually it is not the same task, i've created a new form (task), n a
textbox filed displaying "Call No" for helpdesk puposes, i want my code to
read the value (0)in this field and increments it by 1 ,becomes(1) ,then i
save the form and once i open it again incrementes by 1 becomes(2).
i've tried your code ,every time i open it displays "1" !


--
Thanks
Diana


"Joel Allen" wrote:

Is it the same task? If so, make your field an integer. It will start with
0. Then in your code.....

Function Item_Open()

Item.UserProperties("YourField") = Item.UserProperties("YourField") +1

End Function



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

I'm trying to create a textbox field on a task form-Outlook 2003-
and every time I open the task or click on txtbox , the number in it
incremented by 1
like a serial number for the tasks.
If anyone can show me the vbscript code to do that, I'll be grateful

--
Thanks
Diana



.

  #4  
Old February 26th 10, 12:28 AM posted to microsoft.public.outlook.program_vba
Joel Allen
external usenet poster
 
Posts: 117
Default create auto number field in task form

Try this:


Function Item_Open()

Item.UserProperties("YourField") = Item.UserProperties("YourField") +1
item.save

End Function


Joel

"Diana" wrote in message
...
thx for replying Joel,.
Actually it is not the same task, i've created a new form (task), n a
textbox filed displaying "Call No" for helpdesk puposes, i want my code to
read the value (0)in this field and increments it by 1 ,becomes(1) ,then i
save the form and once i open it again incrementes by 1 becomes(2).
i've tried your code ,every time i open it displays "1" !


--
Thanks
Diana


"Joel Allen" wrote:

Is it the same task? If so, make your field an integer. It will start
with
0. Then in your code.....

Function Item_Open()

Item.UserProperties("YourField") = Item.UserProperties("YourField") +1

End Function



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

I'm trying to create a textbox field on a task form-Outlook 2003-
and every time I open the task or click on txtbox , the number in it
incremented by 1
like a serial number for the tasks.
If anyone can show me the vbscript code to do that, I'll be grateful

--
Thanks
Diana



.



  #5  
Old February 28th 10, 10:09 AM posted to microsoft.public.outlook.program_vba
Diana
external usenet poster
 
Posts: 21
Default create auto number field in task form

also did not work
--
Thanks
Diana


"Joel Allen" wrote:

Try this:


Function Item_Open()

Item.UserProperties("YourField") = Item.UserProperties("YourField") +1
item.save

End Function


Joel

"Diana" wrote in message
...
thx for replying Joel,.
Actually it is not the same task, i've created a new form (task), n a
textbox filed displaying "Call No" for helpdesk puposes, i want my code to
read the value (0)in this field and increments it by 1 ,becomes(1) ,then i
save the form and once i open it again incrementes by 1 becomes(2).
i've tried your code ,every time i open it displays "1" !


--
Thanks
Diana


"Joel Allen" wrote:

Is it the same task? If so, make your field an integer. It will start
with
0. Then in your code.....

Function Item_Open()

Item.UserProperties("YourField") = Item.UserProperties("YourField") +1

End Function



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

I'm trying to create a textbox field on a task form-Outlook 2003-
and every time I open the task or click on txtbox , the number in it
incremented by 1
like a serial number for the tasks.
If anyone can show me the vbscript code to do that, I'll be grateful

--
Thanks
Diana


.



.

 




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
Create a formatted phone number field cmonroe21 via OfficeKB.com Outlook - Using Forms 0 March 2nd 09 04:08 PM
How to re-create due/start date field for Task form with calender Eddie Outlook - Using Forms 1 September 11th 06 02:54 PM
Auto number in custom task form Paul White Outlook - Using Forms 1 June 13th 06 03:19 AM
Auto Number in a Custom Post Form Chuck Rich Outlook - Using Forms 1 February 13th 06 06:28 PM
Populate Company field from Contact field in custom task form Sue Mosher [MVP-Outlook] Outlook - Using Forms 0 January 20th 06 07:37 PM


All times are GMT +1. The time now is 07:51 PM.


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.