Search results

Just the data in the tee off time and tee number fields so that it shows what time and tee that each player will tee off etc

I have been knocking my head on this one.:banghead: Have been helped before in this forum with great results. I have attached part of my database. 2 tables - the main table in players that has numerous fields. The second table is tee off times. (There are of course numerous other reports etc...

JHB That works great exactly what I have been pulling my hair out over for the last couple of weeks thank you

JHB thanks for that that works for the first four but after selecting them then tabbing down to select another four it refreshes the list and the names appear again.

I have a form that has four combo boxes on it that enable the user to select entrants in a golf tournament for tee off times and tee. (I have attached part of this database to this post) It all works fine but after selecting the first player in the first combo box and then selecting the second...

JHB sorry never got back to you on last post - exactly what I needed thanks

JHB Thanks worked great and I was able to make up the same for the Nett 36 holes Only has a problem when one of the team members does not have a score next to their name. User needs to ensure all scores are entered before this is used

JHB The format doesn't really matter I don't think I have numbered enough teams in the sample I sent but each teamclub as listed can enter as many teams of 3 as they have players, for example 24 players they can have 8 teams of 3. Each team is numbered 1, 2, 3 etc under each club Example Every...

Have just about finished my large database for golf tournament. Am absolutely stuck on this one. Part of the tournament is team events and part of those teams are teams of 3 The players in these teams play individually throughout the tournament and therefore score individually. Over the first...

Cronk thanks for this - it worked - had big problems as I had used a calculated field in the table but have fixed that now and everything is great :)

Cronk thanks for that - may need to know what function - I think problem may be also that the field is a calculated field which of course is locked - I am using 2010 May have to somehow change the field from calculated - your suggfestions??

Thanks Cronk but I am aware of validation and it is not this I am looking for. The field that has the handicap is a calculation whereby after entering the players own club handicap this is multiplied by the playing course's slope rating and divided by 113. (Don't ask how they come up with that...

Hi again Still working on a golf tournament database. Have searched and racked what little brain I have left over this and can't work it out. With a new handicap system coming in force handicaps for players have to be calculated by multiplying 2 figures then dividing by another one. I have...

I have finally had a chance to fully run all options on this and I must thank all of you again. I used Nigel and Mihail's suggestion and in particular the code Rounds = INT((HolesPlayed-1) / NumberOfHolesPerRound) Holes = HolesPlayed - Rounds*NumberOfHolesPerRoundWorks like a charm. the end...

I have tried Gemma code but get a syntax error on cycle Am a bit lost regarding the other suggestions - can easily include a round field in the table but am lost as to where I put the code that has been suggested by both Nigel and Mihail. I am certainly no expert when it comes to this Steve

If you had a "round" number as well you could increment the tee number, using DMax(), based on the "round" number and the player. Nigel Sorry I don't see what you mean? Steve

Thanks to both of you for the assistance. Will give them a try over the next few days and get back to you.

Help please One of my forms has a text box which is bound to a field called teenumber. This form is set up that "on current" has code If Me.teenumber = 0 Or IsNull(Me.teenumber) Then Me.teenumber = Nz(DMax("teenumber", "tblteeofftimesshotgun"), 0) + 1 this enables the text box teenumber to be...

JHB Works well thanks - have tried it several times and it is working.

JHB Have uploaded database - it is only part of it as was too big to fully upload but the tables and forms etc that relate to tee off are included. Also a screen print of the form where it goes wrong - you will see in screen print that when first records put in it creates the second tee off...