How can i do autonumber in form

[Jason]

Hi,
I desinged a form and i want add text box that has autonumber properties
in this form.
could it be? and how can i do this?

 

[Sue Mosher [MVP-Outlook]]

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

3) 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