Search results

I'll try and post one tomorrow when I have cleaned up the data. I can convert the box to a combobox but there are no values. When I right click on the combobox in design mode the option is not there to update the list....weird.

I am wanting to create a form for each record. I'm cool with the process of dragging the field names across onto the blank form, this is all sorted but I get a bit stuck when I want to change some of the value fields into a combo box so that it makes it easier for the user to select options when...

Just an update to say that I managed to get a work around for this with some help with how to write it. I created a query for the yes/no answers then created another query for the OR answers and added the name of the 1st query in the FROM field of the 2nd query. So really query 2 is running on...

woahhhhh hold on! So what that is doing is kinda filtering down from table on the fly as you add the criteria with the option to pick And or Or? and not running a query? Thats well cool

Thank you!! Its deffo the latter, the products are not unique to a specific company, as you say a company a can makes product ABC, company 2 can make ADE etc. Id like then to have a search form with multiple different combo boxes where I can select "Product A" from a product1 combo box then...

Just another question, I am going to set up some tables to try and make this database the correct way but I just have a question. As mentioned the database will be about companies and the products and services they provide. I'm going to set up tables for company details, products, services and...

Thanks for this!! I will take a look later and see how I can use to base the DB on. The full spreadsheet is about company related data and what they do/make. So my starting point would be to look at making the 1st table that has an ID number per company so that I can use the same ID to link up...

I did yes and thought I had replied to you, sorry. I'll take a look tomorrow. Thanks

See that just shows how much of a novice I am. Cool I'll take a look and see how I can structure better. Might just need a table each for products, services, acccredations, contact details and then one for all the other 20 yes/no questions

I concur, learning the right way might be painful but will be worth it.

Would there need to be a table for each? Also there are about 2000 rows of data

Sorry it was replied in error. I can't really because it's work related but as an example there are 231 different options for just products or services

Hey Isaac, Thanks for the amazing reply! And totally see your points there. When I said it was rubbish I meant that the structure is totally wrong and really I was being lazy and hoping that someone might know some magic code to make the database do what I wanted it to do...and that person...

Yeah I gathered that but wondered if there was a way around it rather than making separate tables. I know its not ideal but it wouldn't be for everyday use. If I was to do it correctly then I would require a lot of tables as some of the columns contain over 30 different options which isn't an...

Hi Mike, I have uploaded a sample of the database just so you can get the idea. If you search if the AND logic on its own it works fine (the 1st 3 options) and if you search the OR logic (the last one) it also works fine. but when you search together it fails. What I think I want to happen is...

I think the answer to this will be no....go build a better database but thought I would ask. I have a database set up with different columns, the majority of them contain a yes/no reply but there are also columns that has data about the same subject but across a few fields, for example...