J
João Nunes
I saw this question posted in another microsoft forum and
it so happens that it askes a question that I need answing
in a very concise manner. So please can you help with
this predicament:
"I am trying to find a 3rd party control (or some other
means) that allows me to display a continuous form, but
showing records stacked horizontally and vertically in a
grid, rather than just vertically as the standard
continuous form does. I have a small square form, which I
want to fill the screen, e.g. if there were 20 records,
they might appear say in a 5 x 4 grid of squares.
One approach might be to simple have 20 fields on the
form. Then loop through the control values yourself and
read/write the records to the table.
Another alternative would be to create a temporary table
just before opening the form with the five fields
sideways. If the data already exists then use some
queries to fill the temp table. When the user closes the
form use some queries to write each non null field to a
table.
I have looked at various TreeGrid ActiveX controls, but
unless I am missing something, they dont appear to do
this. I know it can be done with Borland - is there no way
of doing it in Access?"
Since I´m a new at this sort of programming language I
need a detailed solution to this problem. I am aware of
the fact that a solution to this problem may require an
Active X sort of Rotine, but this sort of mudule doesn´t
interest me right now because of it´s level of complexity.
it so happens that it askes a question that I need answing
in a very concise manner. So please can you help with
this predicament:
"I am trying to find a 3rd party control (or some other
means) that allows me to display a continuous form, but
showing records stacked horizontally and vertically in a
grid, rather than just vertically as the standard
continuous form does. I have a small square form, which I
want to fill the screen, e.g. if there were 20 records,
they might appear say in a 5 x 4 grid of squares.
One approach might be to simple have 20 fields on the
form. Then loop through the control values yourself and
read/write the records to the table.
Another alternative would be to create a temporary table
just before opening the form with the five fields
sideways. If the data already exists then use some
queries to fill the temp table. When the user closes the
form use some queries to write each non null field to a
table.
I have looked at various TreeGrid ActiveX controls, but
unless I am missing something, they dont appear to do
this. I know it can be done with Borland - is there no way
of doing it in Access?"
Since I´m a new at this sort of programming language I
need a detailed solution to this problem. I am aware of
the fact that a solution to this problem may require an
Active X sort of Rotine, but this sort of mudule doesn´t
interest me right now because of it´s level of complexity.