Hi, i have just joined the forum and have built a few DB's in the past but found i have forgotten almost everything! I do remember with a previous DB i layed...

I am starting a new db to track hydraulic fittings and inventory. I want to do it right, from the start by having it normalized, and not quite sure what I am...

Hi I am trying to change the field type in a table, from text to Number, and I am getting an error message saying that I need to delete relationships first. ...

Hi All Anybody know of software that will use Access Database as data source that will show an organizational hierachy similar to that shown in Word 2007...

I have a table of estimates. Each estimate can have multiple locations stored as a text field. New need: I want to store the sizes of each location. Example is...

Hello I have been working with database since a couple of weeks now. The idea was to create a database that contains information about a student such as...

Hi all, I have two tables each is unique. One is the "Merit Badge" tabel the other "person Id" (name address info) tabel, there is a link tabel...

Hi All, I am doing a project to get started on Access. I am a tinkerer, and have a lab and garage full of storage boxes, component chests, tackle boxes,...

Hello. I have an instance that I'd like some input-suggestions on if anyone would be so kind. We have a vendor table with each vendor ID being unique. One...

Table1 is the parent table, Table2 is the child table. Table3 is joined to Table2 in a one-to-one relation. The purpose of Table3 is for additional fields...

Have several tables where the primary key consists of 3 individual fields. Is there a way to fererence these fields as a group? Right now I have to...

I am trying to clarify where the prefered location is for relationships. I am working as a contract employee to "cleanup" a database created by someone...

I would like to copy a database in access 2003 without the data stored. I currently have a database called 2009 and want to make one exactally like the 2009...

a database program that keeps track of patients, and their records. It would have all the required fields with appointments, and all the necessary requirements...

HELp save the remainder of the hair I have not yet pulled out.! My question is I have a form that has freight and material, and a field for total, when I use...

Why do some programers use Front End/Back End (in other words two .mdb files linked) rather than using one .mdb? What is the whole point?

Brief background: I have a very large 3rd party dbms (30+Gb) from which I need to extract selected data using an odbc link. Among that data is a table which...

I have 3 tables, all with the same field names. I need to create a query which, - Pulls 2 field from table 1, but also adds a new field called "Category", and...

I have a need to design a table that contains: Field1, DateX Field1 will always be either "A", "B" or "C". The DateX will change. For example, for a known...

I am trying to do the same thing, but am not sure what you mean by "set your Form to appear in datasheet view (same look as a Table)" (from Eric's...