dynamically assigned array / user defined grid

I wish to do the following :

enter a new number or get a number from stored data (can do this bit!!!) -
then use this number to create a table of that size to be displayed on the
form (so can enter data into it).
this number will not always be the same.

i know that this can be done using msflexgrid - but it does not work very
well with access - so i was wondering if there was a better way?!?

--
thanks
liz

Liz,

Could you explain a bit more about what you are trying to do and why a
Flex Grid control will not work in Access.

Peter Hibbs.

On Tue, 23 Oct 2007 14:22:00 -0700, liz
wrote:

I wish to do the following :

enter a new number or get a number from stored data (can do this bit!!!) -
then use this number to create a table of that size to be displayed on the
form (so can enter data into it).
this number will not always be the same.

i know that this can be done using msflexgrid - but it does not work very
well with access - so i was wondering if there was a better way?!?

Hi Peter

on one tab a person can enter a number of cells that are required (actually
the number of pages for a book).
then when they select another tab that number of cells is displayed.
then data can be entered into each cell (relating to the page details eg.
colour).
on a click of a button this data is then stored into a table.

at the moment using the flex grid control does not always allow the user to
enter the number required and it seems to be quite slow for what it is trying
to do.

it would seem obvious to display straight from the table - however this
would mean one long list - which is not easy to look at (sometimes over
200)!!

hope this makes a bit more sense and that you can suggest something.

--
thanks
liz


"Peter Hibbs" wrote:

Liz,

Could you explain a bit more about what you are trying to do and why a
Flex Grid control will not work in Access.

Peter Hibbs.

On Tue, 23 Oct 2007 14:22:00 -0700, liz
wrote:

I wish to do the following :

enter a new number or get a number from stored data (can do this bit!!!) -
then use this number to create a table of that size to be displayed on the
form (so can enter data into it).
this number will not always be the same.

i know that this can be done using msflexgrid - but it does not work very
well with access - so i was wondering if there was a better way?!?

Hi Liz,

Not sure I can but as I understand it you want to show the contents of
a table but only one field and, as you say, showing one field in a
Continuous type form is not convenient. So you want to use the Flex
Grid control to show the field data in multiple columns.

Have you looked at my demo program at :-
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Flex%20Grid%20Demo.m db'
which actually shows an example of this. Also, are you trying to enter
data directly into the Flex Grid cells, if so there is some code to do
that as well in the demo program.

Obviously, populating a grid with that much data is going to be slower
than a conventional form but there may be ways of speeding things up
once you get it working.

Sorry I can't be of more help.

Peter Hibbs.

On Wed, 24 Oct 2007 13:01:00 -0700, liz
wrote:

Hi Peter

on one tab a person can enter a number of cells that are required (actually
the number of pages for a book).
then when they select another tab that number of cells is displayed.
then data can be entered into each cell (relating to the page details eg.
colour).
on a click of a button this data is then stored into a table.

at the moment using the flex grid control does not always allow the user to
enter the number required and it seems to be quite slow for what it is trying
to do.

it would seem obvious to display straight from the table - however this
would mean one long list - which is not easy to look at (sometimes over
200)!!

hope this makes a bit more sense and that you can suggest something.

hi peter

thanks - it appears to be exactly what i needed.
i think that the flexigrid that is currently in place is not used in the
most inefficent way.

thank you for your help
liz


"Peter Hibbs" wrote:

Hi Liz,

Not sure I can but as I understand it you want to show the contents of
a table but only one field and, as you say, showing one field in a
Continuous type form is not convenient. So you want to use the Flex
Grid control to show the field data in multiple columns.

Have you looked at my demo program at :-
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Flex%20Grid%20Demo.m db'
which actually shows an example of this. Also, are you trying to enter
data directly into the Flex Grid cells, if so there is some code to do
that as well in the demo program.

Obviously, populating a grid with that much data is going to be slower
than a conventional form but there may be ways of speeding things up
once you get it working.

Sorry I can't be of more help.

Peter Hibbs.

On Wed, 24 Oct 2007 13:01:00 -0700, liz
wrote:

Hi Peter

on one tab a person can enter a number of cells that are required (actually
the number of pages for a book).
then when they select another tab that number of cells is displayed.
then data can be entered into each cell (relating to the page details eg.
colour).
on a click of a button this data is then stored into a table.

at the moment using the flex grid control does not always allow the user to
enter the number required and it seems to be quite slow for what it is trying
to do.

it would seem obvious to display straight from the table - however this
would mean one long list - which is not easy to look at (sometimes over
200)!!

hope this makes a bit more sense and that you can suggest something.