bring to background

benjamin.weizmann

Registered User.
Local time
Today, 14:01
Joined
Aug 30, 2016
Messages
78
hi :)

I do have one long box (green)
and vba which creates of other red short boxes (which represent fail times)
i would like to assign the red boxes on the long green box so the green is on the background

i understood its problem in access
i would like to hear creative ideas how to deal with it

thanks!!
Ben!
 
set the top and left property of red box to top left of green.
then setfocus on redbox.
then issue
docmd. runcommand accmdbringtofront
 
set the top and left property of red box to top left of green.
then setfocus on redbox.
then issue
docmd. runcommand accmdbringtofront

thanks
I can't setfocus on it
to make it textbox?
 
Last edited:
do they have same size? do you want to cover the green with red.
 
do they have same size? do you want to cover the green with red.

no
they with different size
it one long green
and a lot of short red on the green
(so if I see red - it's fault time, If I see green - it's working time)
 
why dont you just put the all
the red box, side by side.
then put them in front of the green
one to cover it.

if working time change the color
of red box to green.
change it back to red if fault.

or, make the red box Visible
property to No when it is
work time, and make them Visible
if fault time.

those boxes are not for me on xmas, are they?
 
why dont you just put the all
the red box, side by side.
then put them in front of the green
one to cover it.

if working time change the color
of red box to green.
change it back to red if fault.

or, make the red box Visible
property to No when it is
work time, and make them Visible
if fault time.

because it a lot of work and calculation
and its required a lot of controls
now, I calculate the width and the left of any red.. and fit its size and position
 
ok that's great!
can i keep the boxes or
you have used for them this
Christmas?
 

Users who are viewing this thread

Back
Top Bottom