ACCESS - Faculty Database
in [Getting Started]
|
Prev: Custom Sequential Numbering
Next: Thank You
From: Kris on 19 Jan 2010 14:49 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.
From: J_Goddard via AccessMonster.com on 19 Jan 2010 15:20 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: KARL DEWEY on 19 Jan 2010 15:26 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.
From: Kris on 19 Jan 2010 16:13 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: KARL DEWEY on 19 Jan 2010 19:09
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/Forums.aspx/access-gettingstarted/201001/1 > > > > . > > |