By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,698 Members | 1,321 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,698 IT Pros & Developers. It's quick & easy.

Access Display Mapping

P: n/a
Aloha, I don't what it is called but I want to make a floor plan or
map of say 400 storage units.
I have done this before with "Stationary" storage units by creating
text boxes on a form page and using mouse-over to bring up data, but
now I am on a project where the storage units are changeable!

I created a form with subforms and using "conditional formatting" I
was able to do the color-boxes criteria thing, but it is a very large
memory hog and get "cannot any more forms" errors all the time

So is there any free or nominal cost add-on programs that will allow
me to create an easily changeable map. thanks Francis
st******@hawaiiantel.SPAMNOT (replace SPAMNOT with .net)

Jun 3 '07 #1
Share this Question
Share on Google+
1 Reply

P: n/a
I do not know of an Access add-on for doing what you want, but Microsoft
Visio, another software package in the Office family, should handle the
mapping nicely. I believe it can be controlled from Access via COM
automation. Some years ago, I observed an application that was based on a
"spreadsheet visual model" for "mapping" -- it's possible then that you
could do what you want also directly in Excel and use VBA code to utilized
information saved in a Jet (aka Access) database.

Larry Linson
Microsoft Access MVP


"spdas" <ma********@hawaii.rr.comwrote in message
news:11*********************@g37g2000prf.googlegro ups.com...
Aloha, I don't what it is called but I want to make a floor plan or
map of say 400 storage units.
I have done this before with "Stationary" storage units by creating
text boxes on a form page and using mouse-over to bring up data, but
now I am on a project where the storage units are changeable!

I created a form with subforms and using "conditional formatting" I
was able to do the color-boxes criteria thing, but it is a very large
memory hog and get "cannot any more forms" errors all the time

So is there any free or nominal cost add-on programs that will allow
me to create an easily changeable map. thanks Francis
st******@hawaiiantel.SPAMNOT (replace SPAMNOT with .net)

Jun 4 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.