Search results

  1. G

    Searching ALL fields in a drop down from ONE Combo box

    Thanks. I'll check it out
  2. G

    Combo Box woes

    Hi Mike, this looks like a great tool but I am struggling to implement it. I used to be a programmer and have the logic skills but my Access skills are fairly rudimentary. I have a subform where I am adding runners' names to a race event so I can then upload their times at the end of the race...
  3. G

    Searching ALL fields in a drop down from ONE Combo box

    Hi, I am adding runners to a race timing database to 'register' the runner's details for the race. I am using a standard Combo box on the runners' table. So of course if I enter text it filters and then hopefully finds the runner I am looking for. now sometimes I have the runner's number not...
  4. G

    Solved Join in Query giving odd results

    For me the problem is why when I add the 3rd key the join becomes a left join. I investigated further and found a Combo box on a table field which was masking what the underlying database was seeing. I was seeing '10' as the racedistance but it was actually storing the RaceId which is 2. So...
  5. G

    Solved Join in Query giving odd results

    Well it’s actually a lot more than that as there are several queries in a chain and then all the tables and linked data. I was hoping what I wrote would be enough. The unique record is there. If you do a simple select on the world record table with the 3 key elements it finds one single record...
  6. G

    Solved Join in Query giving odd results

    Hi, I have a table with World record running times in it with race Distance, Age and gender and the 3 primary keys. I know there is only 1 unique record in the database for 10k distance but there isalso a record for the 5k distance. I have a query which links to the WorldRecord table to pick...
  7. G

    Solved Update a field in a table based on the result of a subquery

    Thank you. Yes in terms of data people are often happy to give their Age but not their DOB so the DB allows both. This exercise is an initial exercise to set the data for an upcoming series of races.
  8. G

    Solved Update a field in a table based on the result of a subquery

    Hi, I am trying to run some SQL to update a field in one table with the result of a nested subquery which returns just one field. The code is below: UPDATE Runners SET Runners.Category = (select RunnerCategory.RunnerCategoryID from RunnerCategory WHERE...
  9. G

    Solved Default value of combo box on one form based on combo box value in another

    We got there in the end! Thanks. Turns out it is stupidly simple. Just use the Default value and hey presto perfect! Thanks for the help guys as ever
  10. G

    Solved Default value of combo box on one form based on combo box value in another

    Thanks, that gives me something to work with Gasman and thanks Doc_Man for the tip on sample code. The combo box is currently bound to the whole table. I was just trying out different things hence rowsource but that clearly wasn't working. :)
  11. G

    Solved Default value of combo box on one form based on combo box value in another

    CJ, you’re right on the names. 2 columns, bound column is 1 widths 0 cm; 5cm. The drop down works fine. I just want to give the combo box a default value and just don’t know how to do that. I’ve tried cmbracename = me.openargs but access just tells me I can’t assign a value to the object...
  12. G

    Solved Default value of combo box on one form based on combo box value in another

    Yep I don’t know what you mean by being in them all and set the value of the combo box. Can you give me some sample code or at least the command steps please? Thanks.
  13. G

    Solved Default value of combo box on one form based on combo box value in another

    Openargs contains the correct id. I just cannot get the combo on the destination form to who all records but default to the one I want. Could you send some sample code? RaceName is the table, Racename.ID is the bound column and Racename.Racename is the column I want to show. Thanks Stephen
  14. G

    Solved Default value of combo box on one form based on combo box value in another

    Hi All, It's been a while. Lock down definitely got in the way as all races were cancelled. now there is a prospect of them restarting I have the impetus to restart my race database project. Anyways, I feel i should know the answer to this and that it really shouldn't be as complicated as I...
  15. G

    Is the .column property available in Access macros

    Thanks. I'll just do it in VBA as there are some other tests I need to do anyway and it will be neater.
  16. G

    Is the .column property available in Access macros

    HI, I want to check the value of column 3 in one of my combo boxes in a macro but Access doesn't seem to make it available to macros where of course it is available in VBA. Am I missing something or is my syntax wrong for the macro: cmbSeriesID.column(2)? Thanks, Stephen
  17. G

    Create report header name from ID field

    .. it's not wrong but seems inefficient to have 10000 reads when one at the top of the report would do. Dlookup won't work as it looks up a single field on a table and I need to get the info from 2 tables so need a join query. I can easily do a query just want it to be as efficient as possible...
  18. G

    Create report header name from ID field

    It's a joined table so not sure Dlookup would work. Just seems bizarre that you can't just do a simply query on a header field in access. If I have 10000 records in my input file it's having to do 10000 reads on the table (and then the joined table) to put the race name and date on every...
Top Bottom