Search results

It is called from the 'on click' event of a button on the form..

You are right in saying that this is a new record. But personal details (sex, DOB, address etc.) will have been added and saved before they ever get to this stage. So the sex text box always contains either 'F' or 'M' and is never null. This is the puzzle. What do you mean by conditional...

Access 2003 on Win XP I'm using the code below to check whether patients have abnormal metabolic syndrome. The code works fine some of the time, but occasionally it fail to pick up on the fact that txtSEX contains either 'M' or 'F. Instead, it will inform the user that 'sex not entered etc'...

Thanks for your help again.

Thanks very for the fast reply namliam. When I call the function from the exit event my year field I get an 'invalid date' error whether the date is valid or not. I changed the function so that it now reads: Function fnCkDate(txtyyyy As Integer, txtmm As Integer, txtdd As Integer) As Integer...

Hello all, A requirement for a database I'm working on is that the date fields consist of the three constituent date parts - the day (dd), the month (mm) and the year (yyyy). I've written the following code to check the values entered in the day and month fields (below). My problem is that...

Yes I understand that there is something of contradiction in the expression I used. Perhaps pseudo-randomisation is better? But as I understand it, the random number generator in Access in pseudo-random anyway. And this doesn't really explain the results I'm getting when Access help files tell...

Thanks for the response. I have removed the 'Randomize' statement as you suggest and the results are strange to say the least. I do not get the same sequence of numbers each time I run the code. The results returned may be the same on two or three or four different times, but then it will...

I need to randomise participants to two groups which we can call 'A' and 'B'. As a further complication, I need to use 'block randomisation'. If you use blocks of four for example, they are 6 different patterns possible: AABB, BBAA, ABAB etc etc. If you then generate a random number between 1...