Page Length and Merging Data

Hello! I have two questions.

1. I am trying to create a database, but Access will not allow my page
length to be any longer than 22". I have tried to make it increase the
length, but no luck. Can this be done? I need to add another 23" worth of
fields.

2. I want to take information located in an excel sheet or database and
allow the user to chose a "location", upon chosing the location, it will
populate "all" the fields in the access database with that information. Any
suggestions on how to make this happen?

Thanks so much for all your help,

What I do is either create tabs and separate the one form into two or three
or put command buttons on my form to open other portions of the form. Larger
than 22" is going to be very burdensome on the user I would think.
--
Milton Purdy
ACCESS
State of Arkansas


"txgirl" wrote:

Hello! I have two questions.

1. I am trying to create a database, but Access will not allow my page
length to be any longer than 22". I have tried to make it increase the
length, but no luck. Can this be done? I need to add another 23" worth of
fields.

2. I want to take information located in an excel sheet or database and
allow the user to chose a "location", upon chosing the location, it will
populate "all" the fields in the access database with that information. Any
suggestions on how to make this happen?

Thanks so much for all your help,

On Wed, 28 Apr 2010 05:11:01 -0700, txgirl
wrote:

Hello! I have two questions.

1. I am trying to create a database, but Access will not allow my page
length to be any longer than 22". I have tried to make it increase the
length, but no luck. Can this be done? I need to add another 23" worth of
fields.

2. I want to take information located in an excel sheet or database and
allow the user to chose a "location", upon chosing the location, it will
populate "all" the fields in the access database with that information. Any
suggestions on how to make this happen?

Thanks so much for all your help,

WHOA!!!!! Stop right now.

Relational databases are *different* from spreadsheets. Your limitation will
not be the size of the form; a Form is *nothing but a window*, and is very
much secondary. You're limited to 255 fields, and - in practice - anything
more than thirty or so fields is an enormously wide table. If you need more
fields than will fit on 44 inches high by 10 inches wide on a screen, your
table will not fit this limit.

Secondly, "populate all the fields" from where? Do you just want to display
information pertinant to a location, or do you want to create a new record in
a table?

Access has a steeper learning curve than other Office apps. If you just dive
in starting with Forms you'll end up very frustrated! Design a set of properly
normalized tables *first*, and then work on forms (probably several tables and
a form with several subforms) to fit. Take a look at some of these resources
to get you started; the tutorials at the end of the list would be a good
start.

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

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

Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/

A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

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


--

John W. Vinson [MVP]

Thanks Milton! I am a basic access user and am trying to help my husband
create something for work. I have the information on two different forms. So,
will the tabs or command buttons still work? Or do you recommond another
feature to move from one form to another? I really appreciate the help. - Dawn

"golfinray" wrote:

What I do is either create tabs and separate the one form into two or three
or put command buttons on my form to open other portions of the form. Larger
than 22" is going to be very burdensome on the user I would think.
--
Milton Purdy
ACCESS
State of Arkansas


"txgirl" wrote:

Hello! I have two questions.

1. I am trying to create a database, but Access will not allow my page
length to be any longer than 22". I have tried to make it increase the
length, but no luck. Can this be done? I need to add another 23" worth of
fields.

2. I want to take information located in an excel sheet or database and
allow the user to chose a "location", upon chosing the location, it will
populate "all" the fields in the access database with that information. Any
suggestions on how to make this happen?

Thanks so much for all your help,