Search results

Hello all I am hoping someone may help me:banghead:. I may be totally off mark with this but I believe that a sub query may help me sort this out. As part of a golf database upgrade I have added team numbers to players in a table called players. This table also collects the scores of each...

I have searched on this and cannot find a thread that seems to match want I need to do. As part of a database I have 2 tables. One which has players added to it and the other (foursomes table) is filled with data from the players table when user collects data using a form. The user selects...

I am again updating a local golf competition database and have struck an error "Expression too Complex" when using a form that contains drop down lists of players names to enter their tee off times. After entering 25 sets of 4 golfers the error shows up (No number is shown in the dialog box...

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

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

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

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

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

this is my first post to this forum - what a great forum - has helped me greatly so far but can't seem to find an answer to below: I am creating a database for an annual golf tournament. Part of this is to allocate players to play off together at certain times. I have a form bound to a table...