Rotating a Button Control

[ShawnB via AccessMonster.com]

Hello,
I was wondering if you guys could help me out. Im currently working in
Access 2007. I have a picture of my companies floor plan. What they want to
be able to do is click a workstation and see a Hardware inventory of that
persons workstation.
The way i planned on accomplishing this was to place the picture in a form,
then place transparent buttons over each workstation, which open the
corresponding inventory report (seemed like a good plan, unsure if there is
another way). In practice it works quite well but my problem is, Some of the
square workstations are rotated 45 degrees.

Now to the question. Is there a way to rotate a button? Mr. Lebans controls
seem to be the way to go, but Im not sure if they are compatable with 07, or
how to add his activeX control to my 07.

Thank you in advance for all of your help, and feel free to suggest
alternative methods.

 

[Linq Adams via AccessMonster.com]

I've read this post now for two days and am still confused by your question.
If the button is going to be transparent, the caption, if any, won't be
visible. So if you want the button to be taller than it is wide, which is
what a "rotated" button would look like, simply size the button so that it's
taller than it is wide.

 

[ShawnB via AccessMonster.com]

What Im trying to do is overlay buttons onto a picture(which is labeled with
stations and office numbers), So they think that they are just clicking on
the pic to get to what they want to see. Due to the arraignment of the
Cubicles in my office, these buttons need to be turned 45 degrees and not 90
degrees. Instead of sitting on a flat edge like the "Reply to Message" button,
i need them to stand on a corner. Essentially i need diamond shaped buttons,
not squares.

 

[Linq Adams via AccessMonster.com]

Sorry, but I've never seen this anywhere. You can't do it with native Access.
If you do it at all, it'll have to be with some third party controls.

 

[ShawnB via AccessMonster.com]

humm, thats what I was dreading. Thanks anyways.

Sorry, but I've never seen this anywhere. You can't do it with native Access.
If you do it at all, it'll have to be with some third party controls.

 

[PWaddington6903]

humm, thats what I was dreading. Thanks anyways.

Don't give up on this yet ... I assume the picture is on the form
using a bound image control - just a standard part of Access. You can
use the "MouseDown" event (or MouseUp event) on the image control to
get the X and Y co-ordinates of where the user clicked on the image.
You then just have to find some way to map those co-ordinates to a
specific desk. If the desk is in a "normal" horizontal position, this
is not difficult - just min and max X and Y values. If the desk is in
a "rotated" position you have a bit more work to do, but figuring that
out is why you get paid the big bucks. I would probably try to create
a table that holds the (X,Y) values that correspond to a specific desk
(many (X,Y) pairs to one desk), that way when the image changes, you
just have to update the table.

Hope this helps a bit.

 

[ShawnB via AccessMonster.com]

Wow, great Idea, ill take a crack at it. Oh and thier getting this from an
Intern hurray slave labor

Thanks again.

humm, thats what I was dreading. Thanks anyways.

[quoted text clipped - 3 lines]
Don't give up on this yet ... I assume the picture is on the form
using a bound image control - just a standard part of Access. You can
use the "MouseDown" event (or MouseUp event) on the image control to
get the X and Y co-ordinates of where the user clicked on the image.
You then just have to find some way to map those co-ordinates to a
specific desk. If the desk is in a "normal" horizontal position, this
is not difficult - just min and max X and Y values. If the desk is in
a "rotated" position you have a bit more work to do, but figuring that
out is why you get paid the big bucks. I would probably try to create
a table that holds the (X,Y) values that correspond to a specific desk
(many (X,Y) pairs to one desk), that way when the image changes, you
just have to update the table.

Hope this helps a bit.

 

[ShawnB via AccessMonster.com]

Huh, turns out they didnt want me to bother with the X,Y coordinates. That
method would have been real neat. The only problem (after figuring out how ot
get the x,y s) that i can think of would be Defining a diamond shape in x,y
coordinates. Ya, a square/rectangle is easy, you just need 2coordinates, but
i know that the diamond would take something more. Thanks again for the help.

humm, thats what I was dreading. Thanks anyways.

[quoted text clipped - 3 lines]
Don't give up on this yet ... I assume the picture is on the form
using a bound image control - just a standard part of Access. You can
use the "MouseDown" event (or MouseUp event) on the image control to
get the X and Y co-ordinates of where the user clicked on the image.
You then just have to find some way to map those co-ordinates to a
specific desk. If the desk is in a "normal" horizontal position, this
is not difficult - just min and max X and Y values. If the desk is in
a "rotated" position you have a bit more work to do, but figuring that
out is why you get paid the big bucks. I would probably try to create
a table that holds the (X,Y) values that correspond to a specific desk
(many (X,Y) pairs to one desk), that way when the image changes, you
just have to update the table.

Hope this helps a bit.