send data from form to data access page

[kirby2fun]

I have created a tabbed form in Access 2002 for our staff to use to track our
files. I would like that information to be sent to a Data Access Page that I
created that would give a summary of the data entered on the form. I would
like for the staff to not even see that Date Access Page. So, on the form
there is a "print" button that would open and print the Data Access Page. I
tried to have it sent a Report, but there are too many fields and is too big
to create a Report. That is why it will be sent to a Data Access Page. Any
suggestions on how I can get the two to work together?

 

[John W. Vinson]

I have created a tabbed form in Access 2002 for our staff to use to track our
files. I would like that information to be sent to a Data Access Page that I
created that would give a summary of the data entered on the form. I would
like for the staff to not even see that Date Access Page. So, on the form
there is a "print" button that would open and print the Data Access Page. I
tried to have it sent a Report, but there are too many fields and is too big
to create a Report. That is why it will be sent to a Data Access Page. Any
suggestions on how I can get the two to work together?

Data is not stored in forms, nor is it stored in data access pages; it's
stored in tables. Either a Form or a DAP can draw data from a Table.

What is your table design? If it has too many fields to fit on a report, it
sounds like it's not properly normalized!

 

[kirby2fun]

What do you mean "normalized"? There is just so much information we need to
track these files. The tabbed form works great because it is simple for our
staff to tab through the screens to enter the data, rather than trying to get
it to fit all on one screen/page. The form doesn't print properly due to the
tabs and amount of data. Since the form and data access page are "linked"
to the same table, is there an easy way to enter the data on the form (I knew
that the information doesn't get stored in the form, it goes to the table...)
and have the data access page pull that information?

 

[John W. Vinson]

What do you mean "normalized"? There is just so much information we need to
track these files. The tabbed form works great because it is simple for our
staff to tab through the screens to enter the data, rather than trying to get
it to fit all on one screen/page. The form doesn't print properly due to the
tabs and amount of data. Since the form and data access page are "linked"
to the same table, is there an easy way to enter the data on the form (I knew
that the information doesn't get stored in the form, it goes to the table...)
and have the data access page pull that information?

I don't understand why a DAP can print the data while a Report cannot.

You may want to look at some of these resources. I'm not at all clear how your
database is structured so I don't know what you need to change (if anything).
I will say that if your table has over 40 or so fields then your table design
is almost surely wrong.

Tables are *fundamental*. Forms, DAPs, and Reports are just tools to manage
and present data stored in tables. You may want to take a look at some of
these resources:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials


Allen's and Crystal's tutorials will be a good start to learning about the
very important topic of normalized table structure.