Unique Number

[Paul Martin]

Hi All

I have made a custom task form. I have a field foe job number. This just
needs to be a unique number or a number that changes eachtime a new task is
created. As this is in a Public Folder is there anyway to generate a unique
number or link to something so I don't have two tasks with the same number.

Thanks
Paul

 

[Hollis D. Paul]

I have made a custom task form. I have a field foe job number. This just
needs to be a unique number or a number that changes eachtime a new task is
created. As this is in a Public Folder is there anyway to generate a unique
number or link to something so I don't have two tasks with the same number.

Search the KB for unique number. The KB used to say to link to a database and
store the last number there, increment it, push it to your form, then save the
incremented value back to the database. In a large environment that add a lot
to the network traffic, and increases the likely hood of conflict and
lock-ups. I suggest that you have a table with just an autonumber field,
create a new record, and use the autonumber value.

Of course, the real solution is to learn how to make a GUID for each item, and
they would never conflict. However, they might not be sequential and/or
continuous.

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

Mukilteo, WA USA