[AccessD] Floor Plan Grid

William Hindman wdhindman at bellsouth.net
Wed Nov 9 09:15:45 CST 2005


...not a bad idea Steve since I can stick a browser control in an Access 
form :)

...and hey, outlandish requests are the meat that the gurus here feed on, 
eh.

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 9:55 AM
Subject: Re: [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
>>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 





More information about the AccessD mailing list