style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
"TimL" <tim_lehotsky> wrote in messageI'm
looking to create an app that would prompt a user to enter floor and desk
number and then display the correct floorplan with the matching desk
highlighted and zoom in on it.
My only real requirement is that it doesn't require the purchase of any
additional software (ie. I could easily do this with AutoCAD and VBA, but
every user would require a AutoCAD license).
I'm considering using VB with EV Active-X control, I have 2 yrs experience
with AutoCAD and VBA, tying it to excel and access, I think this would be the
easiest for me. Although I like the idea ofdoing it with IE, it would be so
much more accessible with the corp. intranet, however my html experience is
limited to frontpage.
Obviously the users of this forum are vastly more experienced than me, I
was curious what your opinions might be. I would think what I'm trying to do
would be common. I just wanted to reach out and see if I'm on the right track.
I'm just starting to research the Express Viewer application program
interface by my plan is as follows:
Using Acad and VBA modify each flooplan dwg so that each desk number has a
rectangle surrounding it and the desk ( I would use the rect. to "highlight").
That rectangle would be on a layer whose name matches the desk number.
Then export the dwg's to dwf
Create a VB form with Bldg #, Floor #, and desk # fields, and the viewer
control. Based on the Bldg and Floor #'s I would know what dwf file to load.
Based on the desk # input I would turn the corresponding layer. Then have the
viewer zoom in on the desk number (this part not sure how to do yet)
AM I on the right track?
I have some floorplans with 700 desks #'s, is there a limit to the number
When I create the rectangles, could I also save a view with the desk #'s
name a later use that to zoom in on the appropriate desk? That could mean as
many as 700 named views.
My thanks to anyone who has taken the time to read my long post.
When the user enters the floor number, I would know which
Access a broad range of knowledge to help get the most out of your products and services.