Here's my problem: I'm trying to monitor RFC's in combination with a visio workflow diagram.
For this purpose I created an access-database with RFC's.
On a single form (of a rfc) there is a OleObject which is linked to the workflow diagram.
Over this diagram several buttons are placed. One specific button changes the status of the RFC.
OleObject Properties:
Source Doc is the vsd document
class=Visio.Drawing
When the form opens I use
Me.OLEvisioDocument.Action = acOLECreateLink
(if I don't the drawing doesn't show)
but if the form is opened, it shows the visio drawing with BUTTONS BEHIND THE DRAWING.
How can I get the buttons to the front using vba?
Or is there another way to solve this problem
Microsoft Access
Last Comment
Jeffrey Coachman
8/22/2022 - Mon
Scott McDaniel (EE MVE )
Do you need to toggle the buttons to show at times, but at other times to NOT show?
If so, then considering that you're using OLE methods, I'd suggest you use a Tab control. Place your OLE container on one page, and your buttons on another, then show/hide the tab pages as needed. Tab pages are given an "index", and you use that to toggle the page. For example, if I have a Tab control named tbMyTab, I'd do this:
tbMyTab = 0 '/shows the first page
tbMyTab = 1 '/shows the second page
OLE containers can do some strange things in Access, so it's best to isolate them in cases like this.
=============================
If not, and if you're looking to "float" the buttons over the OLE container, then I'd suggest you consider other options, like moving the buttons to the top/bottom/side of the OLE container perhaps.
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
LSMconsulting: i want to see the diagram and the buttons at the same time
boaq2000: access 2007: Bring to FRONT/BACK: is this possible in vba??
I also use a tggle button in the form heading. If i change the value the diagram the buttons appear in front of the daigram. But not just on opening the form.
Unlimited question asking, solutions, articles and more.
Jeffrey Coachman
FWIW, when a typical OLE object (Bound Object Frame) receives the focus, it will automatically "Move to the front"
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
If so, then considering that you're using OLE methods, I'd suggest you use a Tab control. Place your OLE container on one page, and your buttons on another, then show/hide the tab pages as needed. Tab pages are given an "index", and you use that to toggle the page. For example, if I have a Tab control named tbMyTab, I'd do this:
tbMyTab = 0 '/shows the first page
tbMyTab = 1 '/shows the second page
OLE containers can do some strange things in Access, so it's best to isolate them in cases like this.
==========================
If not, and if you're looking to "float" the buttons over the OLE container, then I'd suggest you consider other options, like moving the buttons to the top/bottom/side of the OLE container perhaps.