[AccessD] Floor Plan Grid

William,

Back a few years ago I posted a question about placing colored boxes on an
Access form. I was futzing with Stephen Wolfram's book at the time. I
believe it was you who mentioned the graphic routines of Stephan Lebans. I
downloaded his stuff and successfully created one of Wolfram's automaton
generators in a 22" x 22" form...which I subsequently made available for
download for my pals on AccessD who had helped me create it.

What I'm driving at is a way to display the colored grid using Lebans'
routines. 2000 rectangles is only a 40x50 grid. My Wolfram automaton
generator creates over 800,000 colored rectangles in just over 3 seconds on
a 2.1 GHz AMD 64. I don't know about the clickability of the generated
rectangles, but methinks one could at least place a co-ordinate system
around the grid, sort of like the labels on spreadsheet columns and rows,
and, perhaps, click on a column indicator and then a row indicator to
pinpoint a square. Since the Lebans routines are so fast, you might be able
to "highlight" the entire column of grid squares at once based on the column
button or indicator you click...similarly for the row indicator. That would
give the user a cross-hair-like thingie for finding a particular grid
square. Yeah, I know it's two clicks instead of one. Whaddaya want fer
nothin'?

Steve Erbach
Neenah, WI


On 11/8/05, William Hindman <wdhindman at bellsouth.net> wrote:
>
> ...need some ideas here ...or if someone knows of something already.
>
> ...Access 2003 runtime compatible.
>
> ...I need to display on a single Access form ...a grid of as many as 2000
> rectangles.
>
> ...the rectangles would represent booths in a trade show floor plan
> ...each
> distinctly numbered
> and each clickable to call detail data ...and each individually colored to
> reflect status.
>
> ...did I mention that I'd like to be able to zoom and pan the grid?
>
> ...I've tried a number of activex products like metadraw ...but all
> require
> compromises I
> don't want to make.
>
> ...did I mention this needs to be reasonably fast in 2.6Mhz, 1gb ram
> workstations?
>
> ...ok ...I'm nuts ...but I thought I'd at least throw it out there ...my
> head hurts from too much
> pounding against the wall :)
>
> ...still no electric as a result of Wilma ...working on a laptop sucks
> bigtime ...but it is work.
>
> William
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>