Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 227
  • Last Modified:

MS Access How To Place a Rectangle Over a Subform. Bring To Front Send To Back Not Working.

I would like to place a rectangle over part of a subform to make the subform look more transparent.


db104.jpg
0
Dustin Stanley
Asked:
Dustin Stanley
  • 11
  • 11
1 Solution
 
Rey Obrero (Capricorn1)Commented:
try setting the BOX property Back Style to Transparent

the send to back should work even if the BackStyle of the Box is set to Normal
0
 
Dustin StanleyEntrepreneurAuthor Commented:
I actually want the box. I colored the box differently so you could better see it. I want the box over the subform and then I was going to color it the same as the background to hide part of the subform. Thanks for your time!
0
 
Rey Obrero (Capricorn1)Commented:
in the design view of your form, right click on the BOX > Position > Send to Back

if that don't work, upload a copy of your db
0
Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

 
Dustin StanleyEntrepreneurAuthor Commented:
BOX > Position > Send to Back
That doesn't work. i have tried several times. It covers Labels fine but not the subform.


upload  a copy of your database

What is the best option to remove all information and make a copy of the database structure only to upload?
0
 
Rey Obrero (Capricorn1)Commented:
just create a blank db, import the related forms subform and tables
remove sensitive info from the table or create dummy data

upload the new db
0
 
Rey Obrero (Capricorn1)Commented:
did you try, opening the subform in design view and add the box, then send to back?
0
 
Dustin StanleyEntrepreneurAuthor Commented:
did you try, opening the subform in design view and add the box, then send to back?
yes
0
 
Dustin StanleyEntrepreneurAuthor Commented:
I am working on the upload now. I would want the box to be Bring to front. Not Send To Back.
0
 
Dustin StanleyEntrepreneurAuthor Commented:
This is a split database so would you want me to just upload the front end?
0
 
Rey Obrero (Capricorn1)Commented:
yes, the front end has the forms
0
 
Dustin StanleyEntrepreneurAuthor Commented:
It is in the form called frmSkusEntry. After I changed the one rectangle  back style to transparent I couldn't click on it to delete it so I added another rectangle.
0
 
Rey Obrero (Capricorn1)Commented:
where is the db?
0
 
Dustin StanleyEntrepreneurAuthor Commented:
Sorry I will try and re-upload it. I thought it went through.
Database1.accdb
0
 
Rey Obrero (Capricorn1)Commented:
which part are you trying to cover?
is the controls in subform sbfrmProdLocations?
0
 
Rey Obrero (Capricorn1)Commented:
you have BOX125 and inside the box you have three subforms....
0
 
Dustin StanleyEntrepreneurAuthor Commented:
I am trying to cover the bottom row of sbfrmProdlocations.   sbfrmProducts is layered over sbfrmProdlocations. When I type into sbfrmProdloactions Quantity it generates a add new record row temporally until I click out of the box and at that point the add new record row is removed. So I am trying to cover that action and make it more clean looking. I'm learning as I go.

you have BOX125 and inside the box you have three subforms....

Yes correct. I need box 158 to cover sbfrmProdlocations.
0
 
Rey Obrero (Capricorn1)Commented:
can you upload a copy of the BE, so I can see how the forms are laid out in form view
0
 
Dustin StanleyEntrepreneurAuthor Commented:
I am working on it now and putting a few pieces of dummy data in. Look I just started learning this stuff about 2 months ago so to you this may all seem very crazy but I am doing what I know and what will work.
0
 
Rey Obrero (Capricorn1)Commented:
I don't think what you are trying to do is not possible.
0
 
Rey Obrero (Capricorn1)Commented:
I  think what you are trying to do is not possible.
0
 
Dustin StanleyEntrepreneurAuthor Commented:
I  think what you are trying to do is not possible.
That is probably true. I basically just want to put a square over the datasheet subform. Sounds simple but not in an Access World.
0
 
Dustin StanleyEntrepreneurAuthor Commented:
This sounds about right. Thanks for your time.
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

  • 11
  • 11
Tackle projects and never again get stuck behind a technical roadblock.
Join Now