Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default XL 97 - designing form with zooming capabilities

Hi,

For a Glass House Plants Grower I'm designing an application that
will keep track of his plants.
More specific: at which location exacly in his acres big glass house
are at any given time his plants (so he knows where the plants are that
need pruning after x weeks, that need bigger pots after y weeks etc.)

The plants are on rolling tables.
The tables are on 100+ tracks (lets say: all are laying direction
North-South)
Adjacent to the tracks are 2 extra tracks (1 at the North-side and 1 at
the South-side) laying East-West
On each of these 2 trackts are moving devices (call 'm trains if you
like) that are able to pick up a rolling table from one of the 100
tracks and move it to and "drop" it on another different track.

I'm looking for a good way to present the tracklayout on a form

I tried to use screen-wide "thin" labels presenting the tracks and
small "thin" labels in different color presenting the rolling tables.

That in itself works but probably there is graphically-wise a better
way to do it.

Also I' don't know how to implement some sort of zooming.

One example that I could find that comes close is the Sysinternals
DiskView utility:
http://www.sysinternals.com/Utilities/DiskView.html

Any ideas?

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default XL 97 - designing form with zooming capabilities

Why not just use the worksheet and have the columns be the North-South
tracks with row 1 as the North-side track and the last row as the South-side
track. Assume your tables are numbered, put the number in the cell to
indicate location. (of course you can color the cells as well). Then you
can zoom in and out on the worksheet using the Zoom under view.

--
Regards,
Tom Ogilvy


wrote in message
oups.com...
Hi,

For a Glass House Plants Grower I'm designing an application that
will keep track of his plants.
More specific: at which location exacly in his acres big glass house
are at any given time his plants (so he knows where the plants are that
need pruning after x weeks, that need bigger pots after y weeks etc.)

The plants are on rolling tables.
The tables are on 100+ tracks (lets say: all are laying direction
North-South)
Adjacent to the tracks are 2 extra tracks (1 at the North-side and 1 at
the South-side) laying East-West
On each of these 2 trackts are moving devices (call 'm trains if you
like) that are able to pick up a rolling table from one of the 100
tracks and move it to and "drop" it on another different track.

I'm looking for a good way to present the tracklayout on a form

I tried to use screen-wide "thin" labels presenting the tracks and
small "thin" labels in different color presenting the rolling tables.

That in itself works but probably there is graphically-wise a better
way to do it.

Also I' don't know how to implement some sort of zooming.

One example that I could find that comes close is the Sysinternals
DiskView utility:
http://www.sysinternals.com/Utilities/DiskView.html

Any ideas?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Designing Form MaryMar New Users to Excel 1 August 31st 07 09:14 PM
Designing a Form Ed Excel Discussion (Misc queries) 1 June 28th 06 11:22 AM
Zooming in on a row L. Howard Kittle Excel Discussion (Misc queries) 0 October 25th 05 10:30 PM
Keep the same center while zooming John Keith[_2_] Excel Programming 1 October 7th 05 09:26 PM
designing a form that will update each month Rose Excel Programming 4 August 26th 05 04:11 PM


All times are GMT +1. The time now is 05:45 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"