Well I was actually thrown into this project because I have strictly worked in Excel for the last six years or so. I guess they thought because I could drive a car, I could fly a plane. I've been reading everything I can find as I come up against it. I have a better understanding of it, but I...
So how does one become "fluent" in database design? Read lots of forums? :)
Beetle
Thank you for taking the time to look at this. I seriously appreciate it. I feel like it's a complicated structure as well, so its really made me stay up many late nights trying to figure out away to get it...
Also, I noticed that all the forms work independently of each other. Is there a way to bind all the forms to one control so that I can hide all the navigation icons on each subform so that it looks clean and just click on a "New Record" button so that all the forms will refresh to a blank form...
Okay,
Sorry I didn't see your last response. I tried to just "clean up" the "subform" template I started on yesterday. Please forgive the table structure if you look in the relationships. I've messed with this database for an embarrassingly long time.
The break down of the tables was...
What I ended up doing yesterday was deleting my form and creating a subform only that included all my tables (as per the advice i received). I haven't designed the layout or anything at this point because in the middle of doing that i was told that that wouldn't help me have a form that could be...
I have about 13 tables in all. I haven't setup any queries either. All I did was setup all the tables and then made then set the relationships. I was just trying to create an entry form so that all the information would go into all the different tables correctly.
This started because I couldn't...
I'm so frustrated. I just wanted to try and setup a form that would tie all my tables together. Now I deleted that form and of course all the work that was involved is gone as well. This was an all day discussion yesterday.
So just to be clear, if I setup an "enrollment form" that form can be...
I was on here yesterday to inquire about my db design, and I was told that forms cannot be used for a multi-user database unless they are read-only. I was hoping someone could confirm or deny that statement.
My attempt was to create a form that was based upon all the tables I had created.
I...
The example of the Northwinds database opens with a pop up form that asks for the name of the person using the db. There are several names to choose from in this form so I can only assume that they are designing this as a multiple user interface. Obviously I can be wrong about this.
Thank you...
So then why does the form view get used in the Northwinds Database?
What is the best way to allow multiple users to enter information into a database then?
Okay. So when inserting my forms into the subform do I just drag and drop or should I use the wizard (or does it matter?) I understand the designing aspects of Access because I have tried this so many times already, ugh..but..the way you are saying to do this, it will allow for multiple users...
Okay. I have all the tables created to each individual form and I opened up a blank subform. When you say to "edit" are you speaking of the icon you select to add a subform? This is where you drag and drop the control/icon onto the form itself and the subform wizard creates this by asking a...
I understand what you are saying, but I thought the Access just locked the row of the table being edited. I didn't know it would lock the whole table.
The issue I deal with now in using Excel is similar. Excel wants to lock the whole spreadsheet and I was under the impression that Access only...