Auto Number in a Custom Post Form

  • Thread starter Thread starter Chuck Rich
  • Start date Start date
C

Chuck Rich

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
 
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/articles/ricardosilva/vbscriptoutforms.asp

5) Use an Excel worksheet that contains VBA code to increment the number. See http://www.microsoft.com/office/com...sers&mid=5489e140-9794-41b7-a9ba-1324e136ff3a

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
Back
Top