Re: Generating Random Numbers...

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Rob Oldfield (blah_at_blah.com)
Date: 01/17/05 

Date: Mon, 17 Jan 2005 21:07:59 -0000

Rather than doing the generation on the fly, it'd be better to just create
an initial table containing 1-999 in a random order, then just read those
numbers in order.

The word 'better' is, as Martin suggests, a relative term. You should tell
your management team that their plan is ludicrous (unless there are other
reasons you don't mention).

"Martin J" <anonmous@nospam.com> wrote in message
news:2AF959BB-9F19-494B-A9A6-5FAD120EFC1D@microsoft.com...
> to use random it would look like this
> dim job as int
> Randomize
> job = Rnd() * 1000
> To check if its a double
> if dlookup([job],[table],"[job]=" & job) is null then add record
> this is how it would be done. I personally hate doing it this way bec. why
> use random numbers as keys? At least use counting numbers up to 999. Think
> about what is going to happen when there are few keys left. It might take
a
> while for the program to find a key for you. You also have to make sure
not
> all the keys are used with a dcount() statment otherwise you'll be in an
> infinite loop. With counting numbers its very simple
nz(dmax(job,table),0)+1
> if <1000 then add record. In all these cases the 05 should be added on the
> form and not be saved with the field.
>
> HTH
> Martin J
>
> "Brad Pears" wrote:
>
> > The management team has come up with a plan to generate random job#'s
for
> > each home that we build - However, the first two digits will be the year
the
> > job came in i.e. this years jobs will be starting with "05" and the
next
> > three digits will be the random number I generate.
> >
> > This number is stored in our Access DB and I must make sure that each
time a
> > new random number is generated, that it does not already exist in the
db -
> > so will have to do a quick lookup.
> >
> > Does anyone have any code to randomize numbers? I want to generate a 3
> > digit number.
> >
> > Thanks,
> >
> > Brad
> >
> >
> >

Relevant Pages

  • Re: Trying to use sets for random selection, but the pop() method returns items in order
    ... I also tried using a dictionary, with keys from 1 to 10, and also got ... The keys in a dict or set are not in random order, ... they are in hash key order modulo the size of the hash. ...
    (comp.lang.python)
  • Re: Generating Random Numbers...
    ... an initial table containing 1-999 in a random order, ... At least use counting numbers up to 999. ... > about what is going to happen when there are few keys left. ... >> three digits will be the random number I generate. ...
    (microsoft.public.access.forms)
  • Re: keypress predictor
    ... user to press keys in what feels to him to be a random order. ... writing a little Basic program to put letters on the screen and have ... and see what letters or numbers top the list. ...
    (comp.lang.basic.misc)
  • Re: Set priority of Run key
    ... random order. ... TECH ...
    (microsoft.public.vb.general.discussion)
  • Re: Memorisable/handwriteable/typeable key styles
    ... >>> all of which have four letters. ... > with random digits. ... those keys are too long - so we use letter/digit ... Not for secret keys, ...
    (sci.crypt)