Recent content by MCAdude

Well the unique part isn't a problem since there will be assigned a recordnumber to each record which has got nothing to do with the random number. The random number is needed to assign a person to a location. But the person who uses the db can't see how this is done. So for example there are...

Got a OnClick event that will give a random number ranging between 1 and 12. On each new record a new random number is created, but on a recordset of 12 records there should be an even divided numbercollection (1 to 12) So I create the first record and I assign a random number to it. Let's say...

Is it possible in a SELECT TOP statement not to use a fixed value, but a variable in place of that? TIA, M.

Sorry for the somewhat late reply, but I checked the function and I noticed I have made an explanation error. The block of 12 should NOT be assigned at once. The first person would be entered in the db and than a random number from the fixed array of 12 has to be assigned. Than, after 11 more...

I have a field with a simple date validation. Is it possible to get a validation text that has a text similar like this "The date should be greater than [fieldname]" when the validation rule isn't passed?

Thanks Travis for the function, but unfortunatly it's not completly what I had in mind. Perhaps I should explain it a bit more. Let's say I've got a simple db with 12 records. I've to get 1 block of 12 randomly generated numbers divided amongst those records. But each generated number can only...

I would like to have a function where a random value is generated between 1 and 12.so far nothing special. But the tricky part is that each value may only be generated once and after a block of 12 a new block must start. Example: First block generates the following numbers at random...

No Dembrey, your code was the one I was looking for. So really, thanks for the help

Thanks this get's me out of my problems...

I've got the following (simple) code put under a button Private Sub random_Click() Dim MyValue Me![numbera] = 0 Me![randomdate] = Date Me![randomtime] = Time() MyValue = Int((2 * Rnd) + 1) ' Generate random value between 1 and 2. Me![numbera] = MyValue It works like it...

I've got 2 subforms, one with a textfield containing a string of loose values like "1 2 3" in the other subform there are checkboxes with the values 1 2 and 3. What i want is that if the first textbox contains a 1 the checkbox with value 1 remains visible, otherwise it should turn invisible and...

Thanks for the help, and I know the structure of the table isn't ideal but the numbers are in fact a concatenation of strings (it's quite difficult to explain) [This message has been edited by MCAdude (edited 03-04-2002).]

I have a query where I want the user to get its output by giving a number, the problem is the field can contain more than 1 number, but the current query returns only the fields with the given number. Example: The user types in 16 and he get's all the fields with only 16 What I want is a...