Tables
in [Access]
|
Working with many-to-many relationships in Access 2007 Hi, I'm new to Access but have been studiously using the help, tutorials, and forums. I seem to have the tables laid out but am now stuck at getting the relationships worked out. Basically, I have 3 tables: 1-Contacts (people), 2-Programs , and 3- Organizations. Each contact works with one organization but e... 30 Jun 2008 15:49
How do I prevent deletion or changing of a record in Access 2007? I want to be able to "lock" a record once it has been created, I am using auto-number as the data type, that will show that the record has been deleted, but not the details, but want to try and prevent editing and deletion. Thanks in advance Aldric ... 30 Jun 2008 01:27
Hate Your Job? Do You Hate Your Job? If You Are Like Me And REALLY Hate Your Job, You Can Do What I have Done And Tell All About Your Company At A Great And CHEAP New Site Called Dont Work For These . Com http://www.dontworkforthese.com This Site Has Chat Rooms, A Joke Section, A Great Story Section Where You Can Tell All Th... 29 Jun 2008 06:02
How to add a column to an existing table via code? I have an existing table in a .mdb database and I want to add a text column that is not required. I can add the text column but when I tried to set it to allow nulls I get the error "Multiple-step OLE DB operations generated errors.", error messasge. My code is shown below. Dim catCurr As New ADOX.Catalog c... 30 Jun 2008 14:47
Hey Roberta, your little boy is playing in the middle of the road The con artist is at it again. I see you are avoiding words like good, functional or useful when referrring to your work. These newsgroups are provided by Microsoft for FREE peer to peer support, not for gas station attendants who pretend to be computer experts trying to sell snake oil. John... "Mark" <n... 28 Jun 2008 12:42
Pictures in Access database records How do I show different pictures in individual Access database records (forms view)? ... 5 Jul 2008 02:21
reservationsystem for tickets I have a circus and need a database to reservation of tickets, can anyone help me to get such a system. ... 28 Jun 2008 13:43
help with Table structure Hi, My office has a staff database consists of 3 tables. tblEmployee, tblEducationAllowance, tblMedicalAllowance. tblEmployee has EmpID, Empname, EmpPosition, DOB, DateofService... Now my office needs to incorporate employee dependents into the database. Each dependent will have medical allowance as well. ... 28 Jun 2008 03:31
setting up the network path for workstations In the article "Splitting a access database, or how to run ms-access in a multiuser mode" Albert D. Kallal states that you should not use drive letters and mapping to link the front end of an application, on workstations, to the backend on the server. Instead, use UNC as the path name. My question is, if I put... 28 Jun 2008 01:29
Database Design/Combo Boxes and Relationships I'm setting up a database and I'm trying to follow the rules for normalizing it. I have a master table that has about 7 fields that all store the foreign key from lookup tables. I had set up a relationship on each field to the lookup tables as well. Create the forms with appropirate combo boxes. Where I run i... 10 Jul 2008 11:20 |