G Guest Oct 31, 2005 #1 I want to create a form which increases it serial number automatically once a person uses it. Just like a Bill No. in Bill book.
I want to create a form which increases it serial number automatically once a person uses it. Just like a Bill No. in Bill book.
S Sue Mosher [MVP-Outlook] Nov 1, 2005 #2 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
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
