Rectangle Tool to create colored boxes
I have a form and have set a background color for it. All of my controls are set to transparent.
I went to use the rectangle tool to draw a box around a group of the controls, worked fine. But, when I tried to change the background color of the box, it put the rectangle on top of the controls instead of behind them. I could not find a feature like there would have been in Word to "send items back".
Thank you for taking the time to report an issue.
What's wrong... Please write below.
DoCmd.OpenForm "DataEntry", , , "ID='Box414'"
Where "DataEntry" is the name of a data entry form and "ID='Box414" is what I want to replace with the name of the rectangle...
I like color-coding, frankly need it, don't want to port out to excel. I've tried induvidual colored rectangles aside the text, however those require a lot of messy code (not to mention a million form controls) and when vertical scroll occurs it's a losing battle because, duh, the boxes don't move with the listbox. Is the impossible possible
yourpercentage.Height = ([Percentage] / 100) * (1440 * 4)
When the report loads.
So the higher the percentage, the higher the bar goes up the page. Simple right? Howevever, my rectangle doesnt go higher. It just varies the white space below, depending on the values.
I want to know know how to set the bottom of the rectangle as the bottom, and the top as the top.
Some background info:
I have a table named tblCompanies. In this table, there is a field named BeenContacted. The BeenContacted field is a checkbox on my form so would take a Yes/No value.
I would like to have a rectangle appear on the report alongside the company's name. I want the rectangle to be green if BeenContacted was True and red if BeenContacted was false for that specific company.
I want to create a data base with only one table. The user will be able to add a new line with a tool (several text boxes to fill the blanks).
One the same panel, I want to display the tool, the table and some other functions (like the sum of a column, or print the table).
I think this very easy to do this (only one table). Yon can see on attachment a powerpoint draft of the panel.
Do you have any ideas or examples to begin my project? For the moment, I have already created the access table and put it into my panel.
I've been able to figure out how to link the combo boxes to each other so that in the first combo box I can select a category "bag" and then the second combo box provides me with the only 2options to go with "bag": "sandwich" or "tool".
Once I have selected "Bag" in the first combo box and "tool" in the second combo box, I then want a list of suppliers that sell tool bags to populate into the subform. I have been working for WEEKS to get the subform to populate data rather than remain empty.
By the time you finish this tutorial, you will understand the following key concepts: how to use message boxes, how to design dialog boxes, how to create a switchboard menu and how to add custom menus to your forms and reports.