From: John W. Vinson on
On Tue, 19 Jan 2010 11:49:02 -0800, Kris <Kris(a)discussions.microsoft.com>
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]
From: Richard on
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/Forums.aspx/access-gettingstarted/201001/1
> > >
> > > .
> > >
From: J_Goddard via AccessMonster.com on
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




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.
>
>> Hi -
>>
>[quoted text clipped - 16 lines]
>> >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 http://www.accessmonster.com

First  |  Prev  | 
Pages: 1 2
Prev: Custom Sequential Numbering
Next: Thank You