I thought I was getting a grasp on the whole table/relationship design, but the more I read the more I feel like I am spinning my wheels. QUESTION What is the...

Hello, I designed a table with 225 fields and saved without problem. Right now, I am creating a form using that table. However, when I want to make some...

I am using Duane Hookom's At Your Survey software to set up a survey for my church. I have finally succeeded in deleting the sample surveys included with the...

Hi, MS Access 2002 automatically creates an index when a foreign key (ie the primary key of another table) is added. Is this necessary or (at least) in ones...

Hi, I am trying to build two tables containing information about fish that we have collected: tbl Fish: FishPK (one for each individual fish;...

My database is set up to remind maintenance of PMS due based on the last done date. Now maintenance is asking for specific equipment to be PM'd on Tuesday...

I'm just looking for a simple database to input the results of a questionnaire/survey done by our employees. It was made in Excel but printed and handed out...

How do I format a field so whenever a number is enter, the field automatically make that entry a Percent. I tried formattting the number to Percent but when...

Hi all, I am trying to clean up a subform/form/parent table/child table issue. I have a form which relates information regarding a property (20000 or so...

My database has four tables, customer, products, orders and order/product link. Is it possible to delete a customer with a command button, I have tried a...

Hi, I have a database design question. A friend and I were having lunch and got into a database table discussion. Neither one of us is experienced in database...

I am looking for a scheduling database template to schedule transportation for senior citizens for doctor appts., outings, etc. Does anyone have one to...

I apparently lost the person helping me so I will start over here in hopes of getting some help from someone that is more familiar. Once I do it once, I learn...

How can link a access table in my local access file ? is it possible? I choose link table --ODBC Databases()--Creating new Dsn --User Data Source...

I am the Treasurer for a Habitat for Humanity affiliate. I am trying to create a database to track the hours worked by our volunteers. I have already...

I have the following problem. In a database, I want to keep records as historic, before making any changes to them (historic in the same table). One of these...

Is there a way to make one field only editable based on the answer (like a Yes/No checkbox) or entry of another field? For example if you have a Yes/No...

I am making a database that acts as a questionnaire that consists of a main form and 2 subforms. The main form has the person's name, etc. The 1st subform...

Hello All, Looking for suggestions, ideas, thoughts... I have 5 tables included in my query: tblCoilReceiving PK tblCoilRun (related to tblCoilReceiving 1...

A little background: as you may know, I am attempting to "fix" my employer's existing database. We are a non-profit (i.e., NO budget for someone to help me...