Autonumber Generatade numbers

[Pena]

Hi,

I'm putting togheter a e-store and want Acess to generate the order numbers. The simple increment is bad because it only generates numbers like 1,2,3 ect. Then I tried the ramdom number thing and the numbers that come out now are like : 5700399, 10033334,
-5710399, -10033334. I just don't want negative numbers to come out. Anyone knows how to format those generated numbers?

Thanks!

[dhtmlgod]

Try:

cInt(number here)

[Pena]

I'm not sure where to put that code...
The 'new value' box doesn't alow me to put it there.

[dhtmlgod]

Uhm... you talking about with ASP or just with Access?

[Pena]

Just Acess. In the autonumber properties, there's 3 fields to set:
Field Size : I choosed Long Int
New Values : Ramdom
Format : nothing

The format thing doesn't work for me. I tried ABS(number) and nothing, negative numbers still come out.

[dhtmlgod]

Does it have to be a numbe? If not, you could make an repulcation ID, which generates a random string, tho it contains letters and stuff.

[Pena]

no it doesn't have to be a number, but the replication is kindo of too long I think.

[goober]

Maybe you should try it like this?

val1 = |val2|

lol nothing to support it, i dunno if it'll work, but it's worth a shot.

[big_al]

Hi,

I personaly wouldn't suggest using random numbers for invoices as VB's random numbers....aren't so random

But if you really want some random number that are good for using in invoices then here is a little script I somtimes use

Randomize
    function ZeroPad(sWork, nDigits)
    	ZeroPad = right(string(nDigits, "0") & trim(sWork), nDigits)
    End function
    function GetIndexNumber()
    	sDay = Day(Now())
    	sMonth = Month(Now())
    	sYear = Year(Now())
    	sHour = Hour(Now())
    	sMinute = Minute(Now())
    	sSecond = Second(Now())
    	Tail = Int(1000000 * Rnd)
    	GetIndexNumber = ZeroPad(sYear, 4) & ZeroPad(sMonth, 2) & ZeroPad(sDay, 2) & ZeroPad(sHour, 2) & ZeroPad(sMinute, 2) & ZeroPad(sSecond, 2) & ZeroPad(Tail, 6)
    End function

[dhtmlgod]

Yeah, I would go with what Al said. When ever I need to generate random numbers, I always found that using the time the best way to go. And some times a lil of the IP number.

[big_al]

Never thought about using IP as well, great idea, might have to use that next time