PC Review
Forums
Newsgroups
Microsoft Outlook
Microsoft Outlook Form Programming
Auto number in custom task form
Forums
Newsgroups
Microsoft Outlook
Microsoft Outlook Form Programming
Auto number in custom task form
![]() |
Auto number in custom task form |
|
|
Thread Tools | Rate Thread |
|
|
#1 |
|
Guest
Posts: n/a
|
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 |
|
|
|
#2 |
|
Guest
Posts: n/a
|
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 |
|
![]() |
|
| Thread Tools | |
| Rate This Thread | |
|
|

Main Page 

