MS Access: Editing cell in Listview

[keirnus]

Hello,

I am back and got a new question.

I have various data to be displayed in a table.
I think a listview will do. I want to edit the value
of a certain cell (column,row). The process is done by
clicking the cell first then edit.

Is this possible?

I searched the net but there's nothing yet for MS Access.

Help is greatly appreciated.


keirnus

 

[LPurvis]

Through a control you'd need an ActiveX DataGrid (or FlexGrid, Hierarchical FlexGrid etc) for that.
But when working in Access it's so trivial to use forms that there's rarely any need for an external alternative.
i.e. Use a form.

 

[keirnus]

Through a control you'd need an ActiveX DataGrid (or FlexGrid, Hierarchical FlexGrid etc) for that.
But when working in Access it's so trivial to use forms that there's rarely any need for an external alternative.
i.e. Use a form.

Thanks for your reply, LPurvis.

Seems like the listview control cannot do the job.

I researched the other day and stumbled to what you said.
About DataGrid or FlexGrid. I tried checking in my MS Access 2003
and got none of those. There is nothing in my References.
How can I get these DataGrid control or FlexGrid control?

Regarding the display of my data and how it is edited, it's kinda difficult
to make my own form. I need to display my data in a list format with
vertical and horizontal scrollbars. That way, the size of the screen is
maintained no matter how many data are there in the list. Then, in
the list, data should be editable right then and there. Example is when
I click a cell, a textbox appears for the user to edit the data. After
editing or when the focus is somewhere else, data is edited and done.

If there is any control that can perform these logics aside from DataGrid
and FlexGrid, please let me know.

I know what to do with my data but I don't have the right control yet.

Asking help from the Access gurus,
keirnus

 

[LPurvis]

As I refered to earlier (but without detail or further explanation) the controls mentioned are ActiveX controls.
They're found in the ActiveX controls list (Form Desgin View, Insert > ActiveX Control).

It sounds to me though that a datahseet form is still really enough for you - unless you can't predict at all the datasource that will be displayed (and even then there are ways of making the form meet your needs).

Have you looked at a datasheet form as a subform (to limit the size).

Cheers.

 

[keirnus]

As I refered to earlier (but without detail or further explanation) the controls mentioned are ActiveX controls.
They're found in the ActiveX controls list (Form Desgin View, Insert > ActiveX Control).

It sounds to me though that a datahseet form is still really enough for you - unless you can't predict at all the datasource that will be displayed (and even then there are ways of making the form meet your needs).

Have you looked at a datasheet form as a subform (to limit the size).

Cheers.

Haven't tried using it as a Subform but I seem to know the display.
It is the same as the display of the database.

But in the Datasheet, all cells are editable.
I want specific columns (only) to be editable.
The rest are uneditable.

Is it possible for Datasheet?
If not, is there any way to support this?

 

[LPurvis]

If you lock the textbox controls in form design view they are locked in datasheet view. Just don't lock the controls you want to edit.

 

[keirnus]

If you lock the textbox controls in form design view they are locked in datasheet view. Just don't lock the controls you want to edit.

oic...you mean I'm going to have many Datasheets?
Editable columns will have their own datasheet while
uneditable columns have different datasheet. Going
to lock the datasheets which are uneditable.

Is this what I should do?
If there is a better way to do it, how?

 

[LPurvis]

I'm not following you now I'm afraid.
My understanding is that you wanted a single control which would display data. You only wanted some of this data to be editable - but it would be editable through that control (in the cells displayed).
A cell of a datasheet is a control on the form (a textbox, combobox, checkbox etc).
If you lock that control - it's also locked in datasheet view.
If you use that datasheet form as a subform then you have it displayed on your main form as a control.
One datasheet - as I understand your requirements.

 

[keirnus]

Hello LPurvis,

I think I now know what you mean.
I tried playing some of the properties of the Datasheet.
I enabled Locked to one of the columns and in deed
they are uneditable. Currently, it is just difficult for
the user to determine which one is editable and which
is not. Guess I have to play with the other properties.

Anyway, the datasheet idea can already suit what I need.

Thanks for your help.

 

[keirnus]

Hello LPurvis,

I am now using the Datasheet.
I can edit data which are unlocked columns
and cannot edit to those which are locked.

But the user can add new row data in the bottom part.
How to disable this?

Hope you could still help me on this.

 

[LPurvis]

Just specify the AllowAdditions property for the form in question.

 

[keirnus]

Just specify the AllowAdditions property for the form in question.

Works like charm!

Thank you, LPurvis!