Create a Unique Tracking Number

[crhodus]

The users of my database want to have a field that contains a unique 6 digit tracking number. The number will be initially be assigned by the system when a new record is created, but can be changed by the user.

I've tried playing around with creating something, but I'm having no luck. Can someone tell me how I can do this or show me an existing example of something like this?

BTW - I can't use my record number as the the tracking number.

Thanks,
crhodus

 

[Kodo]

random numbers

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/vsfctrnd.asp

 

[o1110010]

The users of my database want to have a field that contains a unique 6 digit tracking number. The number will be initially be assigned by the system when a new record is created, but can be changed by the user.

I've tried playing around with creating something, but I'm having no luck. Can someone tell me how I can do this or show me an existing example of something like this?

BTW - I can't use my record number as the the tracking number.

Thanks,
crhodus

hello..

just curious, why can't it be the record number? that's how one of my databases make a tracking/reference number.

and the autonumber data type won't help?

 

[crhodus]

I can't use the record number because it is created by appending today's data/time with a random number.

hello..

just curious, why can't it be the record number? that's how one of my databases make a tracking/reference number.

and the autonumber data type won't help?

 

[crhodus]

Thanks for the link Kodo. I have just one question. There have been times when I have used random numbers, but the number wasn't very random. The same number was returned back to me three or four times in a row. This is why I appended the date/time with a random number.

Did this problem occur because I didn't use the Randomize statement?

Thanks,
Crhodus

 

[Kodo]

Thanks for the link Kodo. I have just one question. There have been times when I have used random numbers, but the number wasn't very random. The same number was returned back to me three or four times in a row. This is why I appended the date/time with a random number.

Did this problem occur because I didn't use the Randomize statement?

Thanks,
Crhodus

yes, you need to use randomize in order for it to work properly