create auto number field in task form

Status
Not open for further replies.
D

Diana

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
 
J

Joel Allen

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" <Diana> wrote in message

news:CA9DAC63-0CE8-4099-BA6B-D3B5DAB97740@microsoft.com...
> 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
 
D

Diana

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" <Diana> wrote in message
> news:CA9DAC63-0CE8-4099-BA6B-D3B5DAB97740@microsoft.com...
> > 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

> .
>
 
J

Joel Allen

Try this:

Function Item_Open()

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

item.save

End Function

Joel

"Diana" <Diana> wrote in message

news:1983E7AE-5004-48B5-84FC-CD2860B89B79@microsoft.com...
> 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" <Diana> wrote in message
> > news:CA9DAC63-0CE8-4099-BA6B-D3B5DAB97740@microsoft.com...
> > > 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
>

>
>> .
> >
 
D

Diana

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" <Diana> wrote in message
> news:1983E7AE-5004-48B5-84FC-CD2860B89B79@microsoft.com...
> > 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" <Diana> wrote in message
> >> news:CA9DAC63-0CE8-4099-BA6B-D3B5DAB97740@microsoft.com...
> >> > 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
> >
> >
> >> .
> >>

> .
>
 
Status
Not open for further replies.
< Pickfolder, modOpenSaveFile, clsCommonDialog | Auto-reply with macro whether logged in to outlook or not >
Similar threads
Thread starter Title Forum Replies Date
rc4524 Create auto follow-up reminder email for already sent messages Outlook VBA and Custom Forms 1
S Auto Create new Task upon Current Task completion Outlook VBA and Custom Forms 28
R Auto-create receipt from email and forward to payer Using Outlook 3
C Visual Basic auto create task from email including attachments Using Outlook 9
H Create/Apply auto formatting rules by VB? Outlook VBA and Custom Forms 2
G Macro: Create New Message and Auto populate To Field Outlook VBA and Custom Forms 5
S Create Auto eMail with Web table Content Outlook VBA and Custom Forms 1
B Modify VBA to create a RULE to block multiple messages Outlook VBA and Custom Forms 0
J Want to create a button on the nav bar (module add-in) to run code Outlook VBA and Custom Forms 2
B How to create a button that sorts and selects the most recent message with ONE click Using Outlook 2
J PSA: How to create custom keyboard shortcut for "Paste Unformatted Text" in Outlook on Windows Outlook VBA and Custom Forms 1
W Create a Quick Step or VBA to SAVE AS PDF in G:|Data|Client File Outlook VBA and Custom Forms 1
Wotme create email only data file Using Outlook 1
S Outlook 365 Help me create a Macro to make some received emails into tasks? Outlook VBA and Custom Forms 1
J How to create a drop down user defined field that will appear on an inbox view Outlook VBA and Custom Forms 8
Commodore Any way to create "from-only" account on Outlook 2021? Using Outlook 1
L Capture email addresses and create a comma separated list Outlook VBA and Custom Forms 5
N Can't create NEW GROUP and add/remove a member from existing Group in Outlook Using Outlook 1
NVDon Create new Move To Folder list Outlook VBA and Custom Forms 0
C Create Meeting With Custom Form Outlook VBA and Custom Forms 2
D Create advanced search (email) via VBA with LONG QUERY (>1024 char) Outlook VBA and Custom Forms 2
G Create ordinal numbers for birthday Outlook VBA and Custom Forms 2
O Outlook 365 - How to create / copy a new contact from an existing one? Using Outlook 5
D Create new email from the received Email Body with attachment Outlook VBA and Custom Forms 10
A How to create fixed signatures for aliases that process through GMAIL? Outlook VBA and Custom Forms 0
P Can I create a Rule that sends me an email when I get a Task? Using Outlook 2
M How create a Rule to filter sender's email with more that one @ sign Using Outlook 1
B Can I create a local PST file for SPAM on a drive that is usually disconnected? Using Outlook 3
Chiba Create an appointment for all the members Outlook VBA and Custom Forms 1
S Create a clickable custom column field Outlook VBA and Custom Forms 0
O Create a custom contact form - questions before messing things up... Outlook VBA and Custom Forms 4
L automaticaly create a teams meeting with a sync Using Outlook 0
D Can Exchange Admin Center create a pst for users email/contacts/calendar? Exchange Server Administration 0
S Create A Search Folder That Looks For Message Class? Outlook VBA and Custom Forms 0
F How to create phone number as links in notes of Contacts Using Outlook 2
Nessa Can't create new appointment Using Outlook 1
A Create date folder and move messages daily Outlook VBA and Custom Forms 1
C Create new Message with shared contacts & BCC'ing recipients Outlook VBA and Custom Forms 0
O Multiple email accounts - hesitate to create a new profile Using Outlook 3
G Can't create Folder Groups in Outlook 2013 Using Outlook 0
N Outlook rules don't create a copy for bcc'ed emails Using Outlook 3
F Delete/create/reset Exchange mailbox on Outlook.com Using Outlook.com accounts in Outlook 3
R Can not create folder to store specific emails in in Outlook for Mac Using Outlook 1
W Create Search Folder excluding Specific Email Addresses Using Outlook 5
A Outlook macro to create search folder with mail categories as criteria Outlook VBA and Custom Forms 3
K VBA BeforeItemMove event create rule to always move to its folder. Outlook VBA and Custom Forms 4
JackBlack What tools do you use to create the signature for email? Using Outlook 3
Rupert Dragwater How to create a new email with @outlook.com Using Outlook.com accounts in Outlook 32
F Should a new email account also create new contacts Using Outlook 2
D create an html table in outlook custom form 2010 using vba in MsAccess Outlook VBA and Custom Forms 7

Similar threads

Top