Search results

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

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