ACCESS - Faculty Database

[Kris]

Couple of issues - 1) When creating a new field in design view, I can't
figure out how to keep the information specific to one person. It shows up on
everyone's. 2) When creating a new page in faculty details with new fields,
the field shows up on all pages. Took the tutorial, but didn't cover any of
this.

 

[J_Goddard via AccessMonster.com]

Hi -

I'm not quite sure what your problem is; I assume you are talking about a
table when you "create a new field in design view" . Fields in tables are a
part of EVERY record in the table, whether or not there is any data in the
fields, i.e. every record contains the same number of fields.

I assume your taking about a form when you "create a new page with new
fields". Fields in a form will also be displayed for every record, unless
you use VBA to make them not visible.

I hope this helps - please post a better description of your problem if not.

John

 

[KARL DEWEY]

It sounds like you are trying to use Access the same way you would use Excel
as a spreadsheet. That is the wrong way to use a relational database.

Post what you are trying to do and possibly someone can suggest how to use
Access properly.

 

[Kris]

I used the faculty database for my educational employees. Some of the fields
did not apply and some of these I could modify to meet my needs. In another
case, I needed a specific field to reflect a particular data. I went to the
table and created a column. I then applied this new column with the button
"add existing fields". I ran into some serious problems with 1) the
information would distribute to each faculty member when what I needed was
the information to be specific to the individual. Problem 2 is that I needed
a new page when in design mode of the "faculty details". I right clicked and
added a new page (3). When I went to add an 'existing field' the field was
embedded on page 1 and 2. So I decided to just add a text box on page 3. When
I put in some trial data, it distributed to all other faculty members.

 

[KARL DEWEY]

Your problem 1 - What was the datatype? Did it have a default?

Your problem 2 - You have be sure you on the Tab (page) and not the main
form. If on the main form it will appear on all Tabs.

Your problem 2 - Same questions are 1.

 

[John W. Vinson]

Couple of issues - 1) When creating a new field in design view, I can't
figure out how to keep the information specific to one person. It shows up on
everyone's. 2) When creating a new page in faculty details with new fields,
the field shows up on all pages. Took the tutorial, but didn't cover any of
this.

Don't confuse data STORAGE with data PRESENTATION. They are very different
tasks!

A Table has the same fields for all records. You cannot add a field to some
records, and not to others. You can leave the field NULL (empty) in some
records, but the field will be there.

It's also possible that you are designing your database starting with your
Forms. That's a bit like building a house, and pouring the foundation when
you're halfway done. The tables, and their relationships, are *absolutely
fundamental* and must be done first; only then would you start adding controls
(not fields) to a form or to a tab control.

What are your tables? What fields to they contain? How are they related? What
"design view" are you talking about: table design or form design?

 

[Richard]

Is this a template?

 

[J_Goddard via AccessMonster.com]

Hi -

I went to the table and created a column.

You don't create columns in a table - you add fields. A column is what you
see when you display the table in datasheet view in a form. (Or when you open
a table from the database window)

I then applied this new column with the button "add existing fields".

Where do you see this button? From design view, or elsewhere? (What version
of Access are you using?).

When I put in some trial data, it distributed to all other faculty members.

If the text box is not bound to a field in the form's source table, this is
what happens when you put data in that text box. But the data is not
"distributed to all other faculty members". If the text box is unbound, the
data is not associated with ANY faculty members. In order to have a text box
display data from the table, you must set the "Control Source" property of
the text box to the table field you want to see.

John

I used the faculty database for my educational employees. Some of the fields
did not apply and some of these I could modify to meet my needs. In another
case, I needed a specific field to reflect a particular data. I went to the
table and created a column. I then applied this new column with the button
"add existing fields". I ran into some serious problems with 1) the
information would distribute to each faculty member when what I needed was
the information to be specific to the individual. Problem 2 is that I needed
a new page when in design mode of the "faculty details". I right clicked and
added a new page (3). When I went to add an 'existing field' the field was
embedded on page 1 and 2. So I decided to just add a text box on page 3. When
I put in some trial data, it distributed to all other faculty members.

Hi -

[quoted text clipped - 16 lines]