Search results

If I write a select case statement for a field X i.e. 6 to 7 for example will this: 1. Select any fields X where the number is greater than or equal to 6 but less than (and not including) 7 B. Select any fields X where the number is greater than or equal to 6 but includes decimels of 7 i.e...

No place it on the on click event on the button on the main form that causes the second form to open.

THat is so weird. I tried the same thing over and over (the definition of insanity) and it didnt work. I tried it again when I saw your post because I knew I was doing the right thing and it worked fine. How weird. Oh Well. Thank-you for your help.

Sorry to be slow but I cant get it to work. In the module code I need to Write Public Function BMI(Weight As Variant, Height As Variant) As Single If Weight > 0 And Height > 0 Then BMI = Weight / (Height ^ 2) (in my case --> BMI = Weight / ((Height/100)*(Height/100)) End If End...

Sorry Whoot, It doesnt seem to be working. The fields that are required and havent yet been filled trip it up since requery causes it to "refresh" but I havent yet filled out the other data. Dennis - If u have time can you please walk me through how to do this? I wouldnt have thought it...

Thanks Whoot I am still having issues using the first method. For new records: If I do If is not null etv (Participant Height), Me.Requery method in weight field and vice versa, I get an error when trying to enter data in second field (although I do not get an error when adding data to the...

THis is probably a simple question but I cant seem to get everything coordinated. I have a form that collects information about participant's in a study including height, weight etc. I need to automatically calculate BMI once a person has placed the information in to the form so I created a...

THe databased is used mainly as a computerised version of a number of psychological tests. Basically what we do is open the file on the participants computer, add the participant as a record and then open a window that has buttons to a number of forms which the participant can do at their own...

That was my fauly also - "" is for text I wasnt thinking.

Thanks Brian. Have a good day.

Thats okay That is because I do calculations on the data but if there is no data I cant do division by 0. When there is data is works fine.

Yehaaww! It seems to work well - but better than my ploddy round about the way version :) Thank-you :) haha see my next problem under VBA coding.. splitting my database causes errors with the password module. Doh! It seems like I have been spending an awful lot of time on here lately but I...

Okay I think it worked. Let me try a bit more..

Is there no text in the module?

DoCmd.OpenForm "frmExtraInfo", acPreview, , _ "AutonumberID = Forms!frmMainForm!AutonumberID"?

Sorry I was a little overzealous with deleting forms etc to get it under max size. I left everything as is and just uploaded it to a free hosting site. Here it is: http://www.filesend.net/download.php?f=aeecd16b129712d38ccfd2cb06a35fc7 I am not sure what you mean by testing to see if the form...

Try this: =Count(IIf(mezo11]="3",0)) I followed the example here http://www.databasedev.co.uk/count_values_countiif.html

I followed the instructions by Microsoft for passwording a form (http://support.microsoft.com/kb/209871) but once I tried to split my database I get an error message #3219 when I try to enter the password and open my form. I know it has something to do with the code and Set rs =...

In the input mask type the word Password. however if you want a secure way to create a password - follow microsoft instructions http://support.microsoft.com/kb/209871

The Form frmReportView is ALWAYS OPEN (just not always visible - see my diagram) because this is where the PrintAllReports cmd button is. It normally becomes invisible when you click to open any ofthe single reports so you can view them (which causes a popup form to open so I can filter the...