PC Review Forums Newsgroups Microsoft Outlook Microsoft Outlook Form Programming Auto number in custom task form

Reply

Auto number in custom task form

 
Thread Tools Rate Thread
Old 12-06-2006, 10:36 PM   #1
=?Utf-8?B?UGF1bCBXaGl0ZQ==?=
Guest
 
Posts: n/a
Default Auto number in custom task form


I need Outlook to assign a unique number to each new task that is entered by
many users sharing the same task folder.
The unique number will consist of yyyymmxxxx (where xxxx is a running number
from 0001 to 9999).
The number will be entered in to a custom field each time a new task form is
saved.
Can this be done?
Many thanks
  Reply With Quote
Old 13-06-2006, 03:19 AM   #2
Sue Mosher [MVP-Outlook]
Guest
 
Posts: n/a
Default Re: Auto number in custom task form

If you need a sequential number, not just a unique number, here are some methods you can use:

1) Use an autonumber table in SQL Server or Microsoft Access. (In my book, Listing 23.7 with Listing 23.4 or 23.3 to open the database)

2) In a custom Outlook form, republish the form after each use to reset the number. See http://www.outlookexchange.com/arti...iptoutforms.asp

3) Use an Excel worksheet that contains VBA code to increment the number. See http://www.microsoft.com/office/com...ba-1324e136ff3a

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Paul White" <PaulWhite@discussions.microsoft.com> wrote in message news:2235725D-A6D3-44C2-B3DE-4B95A4171958@microsoft.com...
>I need Outlook to assign a unique number to each new task that is entered by
> many users sharing the same task folder.
> The unique number will consist of yyyymmxxxx (where xxxx is a running number
> from 0001 to 9999).
> The number will be entered in to a custom field each time a new task form is
> saved.
> Can this be done?
> Many thanks

  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

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