Search results

Thanks for your help. I have fixed the issue now by creating main form with subforms in tabs and pushing the results of query into the main form.

Actually I might try and push the id and company name from the query into the id and company name in the main form, which in theory should show the correct records in the subforms of the tab control

Ok, sorry all, I inherited this database, not not sure why the code is the way it is. So just to confirm. There was an attempt to use a Excel workbook in access. The work book was so big the database was created with linked tables, primary key being ID. A navigation form was created with the...

Yes an ID, all linked to a primary key in another table. Because the subforms are dynamically updated in the navigation form, I think I might need to create a query as there is no option to just add master/child links

Only needs to have one. What I want to happen is. 1.Create query with button push. 2. Display query results in navigation form 4. Move up records in core data subform. 5. Switch to another form 6. Still view the same record that I was viewing in core data. Points 1-6 currently work fine when...

I have around 7 subforms in a navigation form that show all different pieces of data all about the same companies. There is one with core data, another with their capabilities etc. Using the current code, if I open navigation form I can view any records core data and when I switch to their...

Option Compare Database Dim bQueryApplied As Boolean Private Sub Form_Activate() On Error GoTo ErrorHandler If Not bQueryApplied Then If Not IsNull(Me.txtSearchQuery) And Me.txtSearchQuery <> "" Then If Me.NavigationSubform.Form.RecordSource <> Me.txtSearchQuery Then...

Sorry, not sure how to post a block. The from coreData is there so that when I open the navigation form it shows all records and have the function to jump between subforms in the navigation from. If there is an easier way to be able to sync the subforms so I always see the same record when I...

Hi, I have the following code that is supposed to make sure that when I move through different subforms, the record is retained via the ID primary key so I am still looking at the same record. This works totally fine when I just open the "Navigation_Form" as it shows all records but when I want...

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