If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Forms with Pages
I interviewed with a company that was using an Access Form and for each job
in my history I was entering the info on a new page of the form, also other information was stored on different pages. I am at a new job now, building a database that contains the following tables: employee information, emergency info, and certifications. I would like to build a form, so that when we get a new employee, I can enter all of this info into all of the tables with one fell swoop. Because it is so much info, I would like to have each table have their own page. Can anyone tell me how to do this? I'm familiar with building forms, but now also I am doing it on Access 2007. I've just never come across how to attach another page. |
#2
|
|||
|
|||
Forms with Pages
If you are saying you would like to have one table per page, that is not the
right way to do it. Have one mainform and two subforms. The mainform would contain employee information and the subforms would be linked to the mainform (let the subform wizard do that for you) and one subform would show emergency info, the other certifications. "Mindy" wrote: I interviewed with a company that was using an Access Form and for each job in my history I was entering the info on a new page of the form, also other information was stored on different pages. I am at a new job now, building a database that contains the following tables: employee information, emergency info, and certifications. I would like to build a form, so that when we get a new employee, I can enter all of this info into all of the tables with one fell swoop. Because it is so much info, I would like to have each table have their own page. Can anyone tell me how to do this? I'm familiar with building forms, but now also I am doing it on Access 2007. I've just never come across how to attach another page. |
#3
|
|||
|
|||
Forms with Pages
Size-wise, there is too much info to be organized on one screen.
Logically, I would break it down by table, but I don't have to do that... Can I create pages with the subforms? I've never used a subform. "Golfinray" wrote: If you are saying you would like to have one table per page, that is not the right way to do it. Have one mainform and two subforms. The mainform would contain employee information and the subforms would be linked to the mainform (let the subform wizard do that for you) and one subform would show emergency info, the other certifications. "Mindy" wrote: I interviewed with a company that was using an Access Form and for each job in my history I was entering the info on a new page of the form, also other information was stored on different pages. I am at a new job now, building a database that contains the following tables: employee information, emergency info, and certifications. I would like to build a form, so that when we get a new employee, I can enter all of this info into all of the tables with one fell swoop. Because it is so much info, I would like to have each table have their own page. Can anyone tell me how to do this? I'm familiar with building forms, but now also I am doing it on Access 2007. I've just never come across how to attach another page. |
#4
|
|||
|
|||
Forms with Pages
When you go into design view on your mainform there is an icon for subforms.
The subform wizard will walk you through it. The other option (look at the help files on tabbed pages) is put each form on a tab. That might be easier you a newer user than trying to build subforms. You just put tabs (like if you had tabs on a book to find your place) on one form (as many as you need) then you put one form on each tab. You can scroll through each tab until you find the info you need. "Mindy" wrote: Size-wise, there is too much info to be organized on one screen. Logically, I would break it down by table, but I don't have to do that... Can I create pages with the subforms? I've never used a subform. "Golfinray" wrote: If you are saying you would like to have one table per page, that is not the right way to do it. Have one mainform and two subforms. The mainform would contain employee information and the subforms would be linked to the mainform (let the subform wizard do that for you) and one subform would show emergency info, the other certifications. "Mindy" wrote: I interviewed with a company that was using an Access Form and for each job in my history I was entering the info on a new page of the form, also other information was stored on different pages. I am at a new job now, building a database that contains the following tables: employee information, emergency info, and certifications. I would like to build a form, so that when we get a new employee, I can enter all of this info into all of the tables with one fell swoop. Because it is so much info, I would like to have each table have their own page. Can anyone tell me how to do this? I'm familiar with building forms, but now also I am doing it on Access 2007. I've just never come across how to attach another page. |
Thread Tools | |
Display Modes | |
|
|