Split a list into two halfs

  • Thread starter Thread starter Peter Meier
  • Start date Start date
P

Peter Meier

Hello,

I am fairly new to Access and I can´t seem to find a way to realize a Form
which should replace an Excel sheet that was filled manually. This form
has too many fields so in Excel we made a print view of the table that
splits all rows so that we have a page that consists of two lists. The one
at the top of the page shows the first 20 fields and the list below shows
one field that is also in the upper list (a number that helps to see which
line in the two lists belong together) and the last 20 fields.
Any hints how to realize this in Access? Best would be an option to let
Acess to this automatically when printing, but if it is necessary to
create a form whith two subforms, I will do that. In fact I tried it, but
I always see only one record in both lists.

Best regards,
Daniel (using Access 2002)
 
If you've simply moved an Excel data structure over into Access, you will
find that you have to struggle mightily to get Access to do what should be
(and are) simple things. This is because Access is a relational database,
and the underlying table structure that you need sounds like it is a
spreadsheet.

Please provide more information about the kind of data you are working with,
and check into Access HELP on normalization.
 
Hi Jeff,

sorry if I did not make myself clear. I certainly know the difference
between a spreadsheet and a relational database. :-)
I just need a form that presents records in a way that looks like I
described. In fact its all about warehouse management and products with
lots of attributes.
I worked on it thew last few hous and I created a form with two subforms,
both related to the same table. Now I can see a record in both lists (each
list containing half of the number of attributes a record consists of) and
as long as I do not scroll in one of the two lists it looks good. If I
could synchronize both lists, so that both scroll simultaneouly, it would
be great. Is this possible?

Regards,
Daniel
 
Peter

Just so long as you also realize that the structure of your data in tables
does NOT have to be the way your forms present that info...

The reason I mentioned spreadsheet v. relational is because it is unusual
for a well-normalized structure to need that many data elements. Perhaps
some of your attributes could be extracted to "child" tables...?
 
Hi,

yes it is unusual but the structure was given to me and the aim is to be
ablke to print something that looks the same as what they created manually
with excel before.
Changing the structure maybe a good idea but it is not wanted and I HAVE
to do this in another way. Anyways, it would not get very much easier
because they want these two lists on one page and they contain information
about the same products.
I think I will find a way to do it like they want me too. Maybe I have to
limit record sets to the maximum amount displayable on one page so that I
don´t need to synchronize the two lists (subforms).

Greetings,
Daniel (not using my personal email adress)
 
Back
Top