Unbound grid control: Is there one? Other ideas?

[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.

 

[Adrian Jansen]

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

 

[Jeremy Hughes]

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.

 

[Albert D. Kallal]

Note sure how you want to lay this out, but have you considered using a
continues form?

Take a look at the following screen shots, and see if it gives you some
ideas:

http://www.attcanada.net/~kallal.msn/Articles/Grid.htm

 

[Ragnar Midtskogen]

I suppose you mean continuous form?

Ragnar

 

[Jeremy Hughes]

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