[AccessD] Floor Plan Grid

William,

Don't get me wrong, I ain't no authority on embedded spreadsheets. But your
requirements are outlandish. My REAL first thought was to try doing it with
ASP or ASP.NET <http://ASP.NET>. VBScript or VB.NET <http://VB.NET> code to
display a table grid by reading the current status of each "cell" from a SQL
Server table or view. Each cell can be individually colored based on the
status; and each cell can contain, say, an anchor that displays the grid
co-ordinates. The anchor could fire a server-side routine to display another
window to allow the status of that cell to be changed.

The zooming could, I believe, be handled with JavaScript. The panning by
scroll bars.

How fast would a 40x50 grid (or whatever makes 2000 cells) render? Good
question. I'm just beginning to think more along the lines of browser-based
solutions than standard Access approaches.

Steve Erbach

On 11/9/05, William Hindman <wdhindman at bellsouth.net> wrote:
>
> ...hhmmm ...an embedded spreadsheet grid?
>
> ...that would mean I'd have to learn Excel :(
>
> ...plus ...these are runtime installs without Office being a given.
>
> ...but ...when all else seems lost, maybe :)
>
> William
>
> ----- Original Message -----
> From: "Steve Erbach" <erbachs at gmail.com>
> To: "Access Developers discussion and problem solving"
> <accessd at databaseadvisors.com>
> Sent: Wednesday, November 09, 2005 8:56 AM
> Subject: Re: [AccessD] Floor Plan Grid
>
>
> > William,
> >
> > Another thought: is this something that might be more appropriate in a
> > Data
> > Access Page or as an embedded spreadsheet grid?
> >
> > Steve Erbach
> > Neenah, WI
>