Search results

JHB thanks that is fantastic exactly what I needed:)

I have uploaded a cut down version of the database. This includes 2 reports - the query I am talking about is only used for these reports. The one Titled Cox Balmain Bush and Stewart shows the total field for the team playing that comp with the teams that did not have four individual results...

Plog and Ranman thanks to both of you but I don't think I have explained myself clearly on what this is Each year a large group of female members of several golf clubs get together over a three day tournament. They play for numerous trophies and in numerous events. The greater majority of...

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

JHB Seems to work great thanks and also thanks for the tip re pasting the query etc... will keep that in mind

JHB Here is the whole string - the part in red is what I am trying to achieve. Only want records from the players table that have true for the checkboxes Day 1 Only OR Block Entry only Private Sub GetSelectedPlayer(PlayerNo As Integer, TheControl As String) Dim dbs As Database, rst As...

JHB Am back regarding this post - have used database for recent tournament and worked great BUT and there always is a but. When using the combo boxes to select players to tee off I am still showing the players that are not playing that day Part of the expression as above is...

STumac thanks for thatt - did that and it worked perfectly

stumac fantastic that was what I needed exactly I should have said Block entry or Day 3 only to be true not both of them together

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

JHB Fantastic thanks. I was putting that line in but in wrong place thanks for all your help and quick replies Steve:D

JHB Just to let you know the fix works exactly right except (there always is a but...) Before when the names appeared in the drop down they were in alphabetical order by surname - for some reason now after the alterations they appear in the order they heve been entered in the database not by...

JHB and Spikepl thanks for your help - I was just starting to redesign this part of the database to accommodate the 99 limit but thanks to you JHB that works great. You learn something new everytime you work on access.

Spikepl Thanks for your quick response. I am not 100 percent sure which expression is causing the problem but I think it is this one - Private Function GetSelectedPlayer(PlayerNo As Integer) Dim dbs As Database, rst As Recordset, SQLString As String Set dbs = CurrentDb Set rst =...

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

Gina worked great thanks - am going into testing of database soon with full data - any problems will yell Made small changes as below and it worked great Dim SQL As String DoCmd.SetWarnings False SQL = "UPDATE Players " & _ "INNER JOIN tblTeeofftimesshotgun ON...

Gina Tried this code - continued to get compile error . I have other update procedures in there. Even removing them it did not make any difference. Tried placing brackets and parentheses in different spots - didn't make difference. have copied the code below Private Sub Player1_AfterUpdate()...

Thanks Gina -that's exactly what I need - will try in a couple of days when i get home

Gina thanks for that - dumb question but is this an after update in the form or players1 field or is it a new inner join query?????

Gina sorry about that - I quickly answered your question on my way out. Yes it will need to overwrite anything in those fields thanks