Incremental Number on a Custom Form

  • Thread starter Thread starter R.Jayawardane
  • Start date Start date
R

R.Jayawardane

I'm using Exchange 2000(SP3) and outlook 2002.

I have a custom form published in Organizational Forms
Library. In that form there is a user-defined filed name
called RefNo. All the users use this form to send memos &
letters internally. I would like to introduce a serial
number, which should be a part of the RefNo, so that when
a user sends a memo it takes the next available serial
number and adds to the RefNo avoiding duplicate serial
numbers.

Can somebody help me please.

Your help is highly appreciated.
 
R.Jayawardane said:
I have a custom form published in Organizational Forms
Library. In that form there is a user-defined filed name
called RefNo. All the users use this form to send memos &
letters internally. I would like to introduce a serial
number, which should be a part of the RefNo, so that when
a user sends a memo it takes the next available serial
number and adds to the RefNo avoiding duplicate serial
numbers.
Click to expand...
MS has a KB article that tells how to do this using an Access database.
See the following article:
Q172796 - Creating Sequentially-Numbered Items in a Folder

As the number indicates, it is quite old. See if you can find the
current version with a higher number.

Hollis D. Paul [MVP - Outlook]
(e-mail address removed)
Using Virtual Access 4.52 build 277 (32-bit), Windows 2000 build 2195
http://search.support.microsoft.com/kb/c.asp?FR=0&SD=TECH&LN=EN-US

Mukilteo, WA USA
 
Thanks Paul, now I have an idea of how to do it.

-----Original Message-----
wrote:
I have a custom form published in Organizational Forms
Library. In that form there is a user-defined filed name
called RefNo. All the users use this form to send memos &
letters internally. I would like to introduce a serial
number, which should be a part of the RefNo, so that when
a user sends a memo it takes the next available serial
number and adds to the RefNo avoiding duplicate serial
numbers.
Click to expand...
MS has a KB article that tells how to do this using an Access database.
See the following article:
Q172796 - Creating Sequentially-Numbered Items in a Folder

As the number indicates, it is quite old. See if you can find the
current version with a higher number.

Hollis D. Paul [MVP - Outlook]
(e-mail address removed)
Using Virtual Access 4.52 build 277 (32-bit), Windows 2000 build 2195
http://search.support.microsoft.com/kb/c.asp? FR=0&SD=TECH&LN=EN-US

Mukilteo, WA USA


.
Click to expand...
Click to expand...
 
Back
Top