|
| 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. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
February 13th 06, 07:07 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
Auto Number in a Custom Post Form
I'd like to use a sequential auto generated number in one of my Public
Folder Post forms. Is there a VBA script available for that or do I need to link to an Access db to generate an auto number? If so, how? Thanks 
|
| Ads |
|
#2
February 13th 06, 07:28 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
Auto Number in a Custom Post 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) You can download the sample code from http://www.outlookcode.com/member/book.aspx 2 In a custom Outlook form, republish the form after each use to reset the number. See http://www.outlookexchange.com/artic...ptoutforms.asp 5) Use an Excel worksheet that contains VBA code to increment the number. See http://www.microsoft.com/office/comm...a-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 "Chuck Rich" wrote in message ... I'd like to use a sequential auto generated number in one of my Public Folder Post forms. Is there a VBA script available for that or do I need to link to an Access db to generate an auto number? If so, how? Thanks
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| auto format phone number fields in Outlook 2003 | msj | Outlook - Using Contacts | 7 | March 9th 06 11:10 AM |
| OL2003 - can you auto-fill a singel new contact form with online form data | TimR | Outlook - Using Contacts | 1 | February 15th 06 02:43 PM |
| Valid entries for Version and Form Number | sublimese | Outlook - Using Forms | 4 | February 9th 06 10:17 PM |
| I send an Outlook custom form, but a std. form displays? | Sue Mosher [MVP-Outlook] | Outlook - Using Forms | 0 | January 20th 06 08:41 PM |
| Cannot programmatically open custom message in custom form | ms | Outlook - Using Forms | 1 | January 20th 06 04:01 PM |
Linear Mode
