Unbound grid control: Is there one? Other ideas?

  • Thread starter Thread starter Jeremy Hughes
  • Start date Start date
J

Jeremy Hughes

I have a normalised table of measurements from across a
road with 3 fields: lane, pos, metres. At the moment there
are always 4 lanes and 3 positions. I want to display and
edit the values in a fixed grid with 4 columns (lanes) and
3 rows (pos). Each cell showing the metres measured.

I dont expect any data-aware controls will do this so
searched for an unbound grid control that I can populate
manually. I found the DataGrid control but this can only
be data-bound and MSHFlexGrid control which is always read-
only. I there an unbound grid I can use in Acess for this.

Any suggestions for other controls to use, other ideas on
how to do this or references (help, articles, books)
greatly appreciated.

Thanks.
Jeremy.
 
Why do you need an unbound grid ?

A form in datasheet view will allow you to do the editing, but you will have
to put up with the data in a non-normalised table.

Of course if you want to keep the data normalised, you might have to work
around by creating a temporary non-normalised table, populate the datasheet
from this, then write the data back to the normalised table at the end of
the session. A bit of coding, but not too hard.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
Thanks Adrian. Nice idea. I have the basics working now. I
can denormalise the data in a single query and easily
renormalise afterwards.

I want the data in normalised form so that I can run
analytical queries across all readings.
e.g. Select Min(distance) from mytable where Lane = "A".

I didn't want to present the user a normalised datasheet
as it is not a very intuitive way to enter it.

Thanks big time for the suggestion.
 
I had a look at the use of listbox's and continuous forms
on your site. Employing Adrians' idea to denormalise the
data makes either a continuous form or sub-form datasheet
a viable option. I'll have a look at both options.

Thanks for the help.
Jeremy
 
Back
Top