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 >