dynamically assigned array / user defined grid

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

liz - 23 Oct 2007 22:22 GMT

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?!?

Signature

thanks
liz

Reply to this Message

Peter Hibbs - 24 Oct 2007 12:39 GMT

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.

>I wish to do the following :
>
[quoted text clipped - 5 lines]
>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?!?

Reply to this Message

liz - 24 Oct 2007 21:01 GMT

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.

Signature

thanks
liz

> Liz,
>
[quoted text clipped - 12 lines]
> >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?!?

Reply to this Message

Peter Hibbs - 24 Oct 2007 21:52 GMT

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%20D
emo.mdb'
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.

>Hi Peter
>
[quoted text clipped - 14 lines]
>
>hope this makes a bit more sense and that you can suggest something.

Reply to this Message

liz - 25 Oct 2007 20:25 GMT

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

> Hi Liz,
>
[quoted text clipped - 35 lines]
> >
> >hope this makes a bit more sense and that you can suggest something.

Reply to this Message