Recent content by Sirkevin

Works great thanks.

I have a similar problem to a couple of other threads I have found, however I do not seem to be able to find a solution. There is a combo box in the form header which brings up the corresponding record in the detail. I then have a text box (lets call it text box 1) which pulls through a...

This is exactly what I was looking for thanks.

I wonder if anyone can enlighten me. If I have a table say with two fields Member and staff code: Member..... Staff Code Jon.................1 Adam.............10 Sarah.............7 Bob................8 If I also have a form with various details including a dropdown box for the member...

Thanks both Brian and MM. I have managed to get both methods to work now. Your help has been much appreciated. Cheers K

I absolutely agree with you, I was getting quite confused due to the varied methods and answers people were kindly providing me. Like you say, there are so many different ways to do this by the looks of things. I also agree that the database you have uploaded works spot on. I do not know if...

Thanks for your help MM1, however the SQL you have posted seemed to confuse Access. It stated that the Query was too complex. Just going back to Jon's post, it was exactly what I wanted. He posted a database with the explanation, which did exactly what I wanted (attached to this post). I...

Following on from an earlier post, I thought I would ask a bit of further advice as I need a quick answer to this problem. The query in my database seems to be returning all of the fields rather than just selecting those which match the criteria selected from dropdowns in a form. I have...

Thanks for this, however I have followed what I think is being suggested and it keeps returning all of the results not a selection based on my criteria. I have attached what I have done below qrymain1 and searchform2. Could someone point out where I have gone wrong, I am sure it is...

Thanks Access Guy, sorry for the late reply, however I have been abroad for about 3 weeks and it has been a bit hectic. I did not know if you would still be subscribed to this thread, hence I have reposted a new one on the queries section, "Multiple Queries and Drop Downs". I am still...

Please could someone help with the following. I am trying to get my query to work from a set of criteria set by drop downs in a form. I want it to work if any of the drop downs is left blank (null values). If any one of the drop down criteria is incorrect (i.e. no exact match) no records will...

Hey, could I be a real pain and ask you to reupload your database. I dont know if someone has amended it, but it now appears to be read only and the search options no longer work. Unfortunately I did not save your original to my pc.

Well done, this one is spot on. Thank you very much, your help is much appreciated. I now need to amend it to get it to work for around 20 fields in a new database I am designing :)

Thanks for this. Your database is very close to being correct, however it is still experieincing the problems I was having originally. For example: 2 and London = zero returns (correct) 2 London and England = 3 London England (incorrect) The three criteria together should not find a...

Thanks for the code, however it does not seem to work. I have copied and pasted it into the query, however when the criteria is entered the following occurs: if ID is entered the correct field is shown if the city or country is included from the combo drop dowms on my form, no data is...