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.

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.

--
Build a little, test a little.


"Kris" wrote:

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

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.

"J_Goddard via AccessMonster.com" wrote:

> 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
>
>
> Kris wrote:
> >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.
>
> --
> John Goddard
> Ottawa, ON Canada
> jrgoddard at cyberus dot ca
>
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/For...arted/201001/1
>
> .
>

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.

--
Build a little, test a little.


"Kris" wrote:

> 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.
>
> "J_Goddard via AccessMonster.com" wrote:
>
> > 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
> >
> >
> > Kris wrote:
> > >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.
> >
> > --
> > John Goddard
> > Ottawa, ON Canada
> > jrgoddard at cyberus dot ca
> >
> > Message posted via AccessMonster.com
> > http://www.accessmonster.com/Uwe/For...arted/201001/1
> >
> > .
> >

On Tue, 19 Jan 2010 11:49:02 -0800, Kris <(E-Mail Removed)>
wrote:

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

John W. Vinson [MVP]

Is this a template?

> > 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.
> >
> > "J_Goddard via AccessMonster.com" wrote:
> >
> > > 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
> > >
> > >
> > > Kris wrote:
> > > >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.
> > >
> > > --
> > > John Goddard
> > > Ottawa, ON Canada
> > > jrgoddard at cyberus dot ca
> > >
> > > Message posted via AccessMonster.com
> > > http://www.accessmonster.com/Uwe/For...arted/201001/1
> > >
> > > .
> > >