A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Forms with Pages



 
 
Thread Tools Display Modes
  #1  
Old April 16th, 2008, 08:13 PM posted to microsoft.public.access.forms
Mindy
external usenet poster
 
Posts: 87
Default 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  
Old April 16th, 2008, 08:46 PM posted to microsoft.public.access.forms
Golfinray
external usenet poster
 
Posts: 1,597
Default 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  
Old April 16th, 2008, 09:09 PM posted to microsoft.public.access.forms
Mindy
external usenet poster
 
Posts: 87
Default 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  
Old April 16th, 2008, 10:00 PM posted to microsoft.public.access.forms
Golfinray
external usenet poster
 
Posts: 1,597
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:23 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.