Search results

Hello Everyone I have question about filling in ID numbers to connect two tables to together using a Many to One Relation ship. I have been working on a database with data I was assigned to import into certain tables from here I'm supposed to make it all connect. I often use the query design...

Hello all, I had a interesting request on a form and was wondering what you guys think. Basically I will use this example If I have many cars with many colors yet many cars can have many colors how can I show one car that has many colors If I'm just using one Field of colors, Normally I...

Ok Guys I think I got a real hard query to create lets see if we can solve this So I have been requested to created this database base off of one excel sheet, i'm in the process of adding this data to make sure the data fits in with the database ER diagram. I have had to restructured/add...

Hello all I'm working a project and i'm wondering if there is an way to delete duplicate rows fast. I imported a section of my excel sheet that has duplicate rows, at 1st I tried to copy the table and "just structure" and turn one of my fields to No duplicates in the Indeed because this field...

Hello I was wondering if anyone has found a way to set a DataType just as a Year but also include AD and BC. I know there is Date/Time and those formats are not what I'm looking for. Any thoughts or ways around this? is this a limitation? Sure i can have a Text field and type all my years...

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...

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...

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...

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...

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 All, I hope this is the right section for my question, I'm wondering if it is possible to have one Excel sheet with over 3000 entries and their attributes to be exported into multiple tables and have all their table IDs be connected with their related tables in Access. Can VBA perform...

Hello All, I live in the Southwest US and I have been new to access for about 5 months. I been eager to learn access to help create some databases. My interests include history and music. Looking Forward to hear new skills and information from you all