Search results

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.

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?

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...

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...

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...