Search results for query: *

I have made a scorebord (form) that is displaying the resultes, but i would also like to have the scorebord drew arrows to point out what place he will get if the attemt is good. for example attemt 2 : billy : 250 kilo pl. name g.a* bodyweight startnr. 1 bob 260 68.3...

MichaelRed your code worked excellent (I notes that "Master I" change 1 year to early, but i change the CatYr(3) = 15 to CatYr(3) = 16 and it worked perfect)Thank you for helping me. BTW could you make the code to also display "to young" I would realy appreciate it. I am...

Sorry i mean 18 (in the date 01.01.1999)

Thx for all the replays, I realy appreciate it, but none of the seems to work according to the rules (except MichaelRed i don`t know where to put the code in the query (in a form i know, but i need it in a query for later use) Let say that one is born 20.04.1980 (dd.mm.YYYY) 1st rule: He can...

I am trying to make a fild in a query to display his age categori base on his DOB. Rules: Age Categories Sub-Junior : from the day he reaches 14 years and throughout the full calendar year in which he reaches 18 years. Junior : from 1 January in the calendar year he reaches 19 years and...

Thank you for replaying! How many memers the form has is not alwas 10 sometimes it can be 9 or 20 it depend on how many the users chooses (or filer out). I was thinking of when the new record had focus a macro was run ( i tryed useing IsNull=[member_no] close form, but that diden`t work. Any ide?

In my form i have 10 record (lookup from table). When the user have enter the last informasion in the last record. I would like (by a macro) the form to close and upen another form. How can i make this happend? Form: members (locked) locked) member_no, Name, age 1 bob 34 and so on...

i have a query named members and a form with subform call form1. In the form i have a pulldown box (named text12 and has the number 1 to 10) and in the subform i have the fild from the members query, but when i choose 1 (so that only grupp from memers 1 is displayed (rest is filer out) nothing...

Thanks for replaying. TonyJollans - Your ide workt, but i what i would like the query to do is: When a user enter 1 (or select 1 from a pulldown) in the fild [id], [name]=bob and [sex]=male(is lookup(this one i am using by relatianship lookup and is working) then the user enter bodyweight in...

Can anyone help me? I have made 2 table. Table1 have id,name,bodyweight,sex. Table2 have bodyweight,mail,femail. In my query i have placed all fild from table1 any added point. What i want to do is when i enter bodyweight the fild point return the value from table 2 based on sex and bodyweight...