Search results

Thanks Galaxiom that code works fine

I removed the space still same error

Hello everyone I'm try to combine two queries that do work fine when separated. I put the two together on one Query so that I can reduce the number of query processes when transferring data into another table (I want to only have to press the run button once not may) I have on my database...

Thanks ashleedawg, but if this is on a form then shouldnt I have a button? Shouldnt Name_Click() be on the code somewhere?

Hello all I have manged to create user interface where I can import an Excel sheet into a table but does anyone know how to do the opposite where I can export my access data into an excel sheet on a form. I know I can create reports for each table and then export that data into an excel sheet...

Thanks but would the distinct values be from the "27 color IDs" how would the unique values automatically be connected with those IDs I'm thinking I would have a table with 27 IDs and the 27 color names and I would have a column of the 1000 duplicate colors on another table no IDs so I'm...

Hello All, Lets say I have a table that has 27 color IDs that match 1000 cars in another table. I have an excel sheet that lists all the colors that match the cars, If I import all 1000 colors (which would mean that they would be duplicate colors because there are only 27 unique colors) from...

Hello all, I believe there Is a query where I can find the IDs of the matching field,but if I ask to find the matching field name many times would the ID repeat itself ? I dont know any SQL language so I try to create an example Select.ID Copper,Copper,Wood, in theory would my outcome be...

Thank you for your help I was to find select section of my table fields and insert my copy data inside

I apologize I mis read your comment, I can not demostrarte the data because I'm new to access , I'm asking how I would perform the task

Wow that really solve my issue Thanks,

right now the doors are just the ID numbers no specific names if I have a door Table with 300 doors that uses the material ID from another table like so, (not all the doors have a material Id that needs to be filled) Table 1 DoorID | MaterialID 1 | 1 2 | 1 3 | 1 4...

Hello Everyone, Is there a way to have a query to fill a section of your columns in your tables with the same ID? for example, If I have a table with 300 different types of Doors that all have different material types can I automatically or have a shortcut where doors 1-100 are fill in as...

Thanks I got it to work after I changed it in the Join Type in the Relationship view section. Now the funny part is that the sections that are connected (cars that have colors) are at the end of the records it's no longer Car 1 Car 2 Car 3...because they are connected with color, it starts with...

I just connected in the Query view, ALL the car records shown and just the color records connected option and it doesnt seem that it work Do I have to run the query?

I connected only by Relationship, would that mean I would have to create a query

I have them connected by relationships is a query connection essential ?

Hello everyone, I have been trying to see if there is a way to use one excel sheet and import individual columns into individual tables it appears I can use a VBA code from a youtube video but its just importing the excel sheet into one table. The way how the creator is describing the code, I...

Hello Everyone, I'm creating a form base off of 10 Tables, The person I'm designing this for, Wants parts of the fields (or input boxes) of each table on one form. I had no problem creating a blank form and inserting the desired boxes and connecting them on the form, however the data that is...

Hello Uncle Gizmo, Thanks for the website, however some of the images are not shown asking for to update the account, and the tool to convert excel to access doesn't seem to have any instructions, could I email you directly to see how the tool works? Will it automatically import into IDs across...