Search results

Thanks for the quick reply. Is there a way you could break this down for me step by step? Or maybe send me a database with only 3 fields setup? I could learn it by just looking at the design. I know how to create forms and tables but I am not up to speed on queries... I kind of got lost after...

Hi everyone, I am very new to Access and I am not familiar with SQL. Can someone explain to me how I can create fields that are similar to each other? Let's say I have 3 fields in my table: Name, State, Area Code. I want it so that each time I select "Name" the appropriate State and Area...

This will only have tables and forms, no queries.

Hi everyone, I want to create a split-database. I want the entries made on the front-end to update into a combined table in the back-end. Back-end: One table with everyones entry Front-end: Multiple forms that feed into the back-end. When person A accesses his front-end form, he can only see...

Thank you again for all the details. This is going to take me longer than I thought, so I will probably try this out once we are back from the holidays. I might post the database here, all of this might be easier if you could take a look at it. Thanks again!

Thank you so much for your assistance. A few questions before I start working on this. The "tbl" abbreviation means that I am creating a table, what does "pk", "txt" and "fk" mean, are those fields I should create? Meaning this table will have a "ClientID", "CompanyID", "ClientName", and...

Hey there, thanks for the quick reply. I don't mind creating additional tables in order to make this work as long as ONE table pulls this information from multiple tables so that we can review it all in one place. Before I answer your questions, here are some more details and changes to our...

Hello everyone, I am a novice Access user. Our company is moving a lot of our logs from Excel to Access and I have been learning Access on the fly. Just to give you an idea of my skill level, I have gotten the hang of things as far as creating tables, forms, and split databases, and I just...