ACCESS - Faculty Database
in [Getting Started]
|
Prev: Custom Sequential Numbering
Next: Thank You
From: John W. Vinson on 19 Jan 2010 19:34 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 19 Jan 2010 19:36 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 20 Jan 2010 12:57
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 |