Search results

Thank you for the prompt reply. I'll try to answer your questions as best I can. My form is a single form. It has a subdatasheet attached based on a table called tblTransactionDetails. This table keeps track of specific line items that are purchased as a part of the whole transaction. The...

Hey everyone, I apologize if my question doesn't make any sense. I'm new to access so please forgive me. I have a table called TblTransactions. The fields are as follows: Transaction_ID (PK, auto number) TransactionDate (Date/Time) TransactionTime (Date/Time) CustomerName (Text)...

I am trying to make this code work for my database. Instead of using date, could I use an auto number PK field (Transaction_ID)? I'm pretty much trying to do the exact same thing as OP, but instead of Start Figure/End Figure, im trying to keep track of OldBank/NewBank for daily transactions...

Hey Gina, I have a question about one of the tables that you created for my database. Its the "tblBuildingCategories" table. I'm not sure of its applicability for the purpose of the database. The buildings that are going to be assessed don't need to be placed into categories....rather, the...

Also, I have a question about one of the tables. The tblEmployees assigns the employees a surrogate ID, and it's the primary key. What if the employee has their own 8 digit ID number? That would work as a primary key right? Because the rest of the fields in the table depend on that one?

Thank you for doing that. It really helps me understand what normalized tables should look like. And it drives home the idea that everything in the table should depend on the entire primary key. I am so relieved. Thank you. So the next step from here is to create the forms, am I right?

Sorry, my tables didn't attach. Here they are...i think

(I think as I'm not sure what Areas are) I'll try to explain how the buildings work: I use the words "Area" and "Section" as synonyms. They are the same thing essentially, but each building calls them something different. They are essentially cells within a building that perform different...

As for posting the tables, all of the information on them is considered proprietary. The field names themselves are considered proprietary information. I know it sounds silly. I could make one with fake names I suppose if you think that would help. I've created all of the tables that you...

Ok. I read a lot of that. Not all of it because a lot of the links didn't work. But enough of it to have a better understanding of the power of MS Access, and how I should begin this struggle. As far as the tables go, I am thinking about what the most appropriate way to structure them is...

Hey guys. I'm new to Access, and new here. I was assigned a project at work and it requires me to create a database, and an application for end users with Access. I'm already running into some issues. The application is going to be used for weekly assessments. It needs to include checklists for...