PC Review


Reply
Thread Tools Rate Thread

create auto number field in task form

 
 
Diana
Guest
Posts: n/a
 
      24th Feb 2010
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
 
Reply With Quote
 
 
 
 
Joel Allen
Guest
Posts: n/a
 
      24th Feb 2010
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" <(E-Mail Removed)> wrote in message
news:CA9DAC63-0CE8-4099-BA6B-(E-Mail Removed)...
> 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



 
Reply With Quote
 
Diana
Guest
Posts: n/a
 
      25th Feb 2010
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" <(E-Mail Removed)> wrote in message
> news:CA9DAC63-0CE8-4099-BA6B-(E-Mail Removed)...
> > 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

>
>
> .
>

 
Reply With Quote
 
Joel Allen
Guest
Posts: n/a
 
      26th Feb 2010
Try this:


Function Item_Open()

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

End Function


Joel

"Diana" <(E-Mail Removed)> wrote in message
news:1983E7AE-5004-48B5-84FC-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:CA9DAC63-0CE8-4099-BA6B-(E-Mail Removed)...
>> > 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

>>
>>
>> .
>>



 
Reply With Quote
 
Diana
Guest
Posts: n/a
 
      28th Feb 2010
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" <(E-Mail Removed)> wrote in message
> news:1983E7AE-5004-48B5-84FC-(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message
> >> news:CA9DAC63-0CE8-4099-BA6B-(E-Mail Removed)...
> >> > 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
> >>
> >>
> >> .
> >>

>
>
> .
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to create an auto number field? Ben Microsoft Access VBA Modules 2 26th Nov 2008 06:44 PM
create a field into which an auto number is inserted Bill Microsoft Access 1 18th Apr 2008 10:38 PM
Auto number in custom task form =?Utf-8?B?UGF1bCBXaGl0ZQ==?= Microsoft Outlook Form Programming 1 13th Jun 2006 03:19 AM
how do you create an auto number field in Access using DDL? =?Utf-8?B?S2hhbGlsUw==?= Microsoft Access Database Table Design 2 28th Feb 2005 11:40 AM
How do I create a calculated field which displays a auto number ? Adrian Microsoft Access 2 10th Aug 2004 01:45 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:06 PM.