Recent content by zar786

I have a report which has 7 labels and 7 associated checkboxes, these are laid out horizontally going from left to right, with the labels on one line and the checkboxes underneath, i've managed to use code so that only the checkboxes that are ticked and there associated label show up on the...

I have 2 text boxes were the user enters a start and end date for a list of fixtures, i need to validate them using vba to ensure a value has been entered, they are valid dates, not in the past and the end date must not be before the start date, once entered i have a command button which runs a...

i have been trying this for a while now, but can't get it to work, i've based the combo box on a query which selects the field i want to be filtered, i've made a command button with the following code on the onclick event: Private Sub cmdFilterByStatus_Click() 'filter records by Status Dim...

Based on the players PCI BMI (see other post) i need to highlight all players were they are out of range within normal BMI, which for men is 20.7 to 26.4 and for women 19.1 to 25.8, i've tried doing this using a select query on a textbox control source, however nothing comes up: SELECT IIf(bmi...

thx, should of known it would be something simple

is there anyway to limit the number of decimal places? 24.348798376398 don't look good lol.

is there any way to limit the number of decimal places? 26.47856348756348756347 don't look very good lol

finally got it working! using: =IIf([txtGender]="Male",(0.5*[txtWeight])/([txtHeight]*[txtHeight])+11.5,(0.4*[txtWeight])/(([txtHeight]*[txtHeight])+0.03*[txtAge])+11) thx for all your help!!

i've managed to get something to come up, but it's not right, i've played around with the code but either get a really low number like 0.23 or something too high like 65 and sometimes the females calculation doesn't work, you missed out the + 0.03 on the female calculation i've added this, i...

thx for the code, i tried it but it's still not working, i think it may have something to do with the boolean male function, as the field were it says whether they are male or female is called gender, so i assume this must need to be in there somewhere otherwise it won't know were it's getting...

In my Football League database I need to create a public function that takes a players weight, height, aage and gender and returns a players PCI BMI using the following calculation: men: 0.5 * weight / height squared + 11.5 women: 0.4 * weight / height squared + 0.03 * age + 11 taken from...