If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
dynamically assigned array / user defined grid
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?!? |
#3
|
|||
|
|||
dynamically assigned array / user defined grid
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?!? |
#4
|
|||
|
|||
dynamically assigned array / user defined grid
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. |
#5
|
|||
|
|||
dynamically assigned array / user defined grid
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. |
Thread Tools | |
Display Modes | |
|
|