Editable Multiple Cells in One View/List/Form

Hello,

Once again, I need some advices from the Access Gurus here.

I have a list of data. Please refer to sample below:

I need to edit from x1y1-to-x3y4 cells.
It's like editing multiple cells in one view.
Editing the items will be faster when done this way.
What is the best UI Design and table structure for this display?

One more thing...y_Item ROWS are dynamic (as usual). No problem with that.
The thing is that x_Header COLUMNS are dynamic as well.
This makes the UI more difficult to design.
For this, what's the best UI Design?

The case above sounds easy but my head is constantly aching here.
I know there's a better way to implement this.
Hope someone could help me think on this.

-= keirnus =-

re: Editable Multiple Cells in One View/List/Form

First, are you saying that you want to select a range of cells, and type in a value that will be applied to all of them?
Second, I'm not sure what you mean in saying that rows are dynamic and columns are dynamic. Is there any relation between x and y? There must be some motivation here to use a relational database.

re: Editable Multiple Cells in One View/List/Form

I want to select one cell only. Data are inputted or edited per cell only.

Yes, both axeses in the matrix are dynamic. Let's say the data in rows are fruits like Apples and Grapes. The headers in columns are stores that are ordering the fruits. There are variety of fruits. There is a possibility that the company will add more stores who are ordering the fruits or delete one when the contract was not continued. That makes the rows and columns dynamic and can be changed anytime.

I am not good in UI Design. Is there a control in MS Access wherein the data are all displayed in one screen and the data can be edited like the ones in Excel? or is there a better UI Design for this implementation?

re: Editable Multiple Cells in One View/List/Form

In the example you gave, it doesn't make sense to use a grid. Think about how your data would be organized into records, then we can consider the UI.

re: Editable Multiple Cells in One View/List/Form

Just for starters (if you feel ready to start with something which could result in heavily coded solution) you may read the following thread:
Crosstab Behaviour required for Data Input.

Or you may consider a simpler solution - overlaying active cell with little popup form to simulate grid input. If so, then look at Absolute Position of a Control thread.

Regards,
Fish.