Search results

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

Sorry, I sent that last message before I saw your reply. Let me clean it up and attach in a few minutes.

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

Where can I find a "multi-spreadsheet" form? Is that the same as datasheet form? Can this multi-spreadsheet form be created with the Form Wizard?

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

Would a tabbed form or navigation form allow me to do have a form that can be edited without creating a multi-user locking issue?

So I need to house all the different tables into one table in order to have a form that will allow multiple users to edit records? A "read-only" form doesn't help me at all because I need the form view to allow edits as well.

I have no idea what I just read. I was trying to make a database for me and a few other people in order to get us off of the ever growing Excel sheet currently being used. I have had no other experience with Access other than this. I've spent a lot of time trying to make this work, but I'm not...

I am trying to create a form that will bring several tables together so that information can be added to all tables at one time. When I use the Form Wizard it allows for me to pick one table and then to have all the other tables below it in a subform. Is there a better way to accomplish this?

I have cascading comboboxes in a form I created. The combo boxes on the main form work fine, but I don't know how to edit the control source for the combo boxes on the subform. Right now the combo boxes are unbound, but I need them to be bound to a table in the subform. Does anyone know how to...