Rectangle Tool to create colored boxes
Expand a Rectangle or Frame as a border
I have a report where I have several text boxes and Labels that I would like to place inside a rectangle or something similar so that they are enclosed together in the report with a nice border around them and will stay within this border. The rectangle needs to shrink or grow around the labels and text boxes when they grow or shrink
Use Name Of Rectangle For Search
I have a form in Access 2007 with a lot of rectangles on it. I want to display data based on which rectangle is clicked by the user. It seems to me as if the easiest way is to have the key field of the database contain the name of a rectangle (Box100, Box101, Box102..). As an example I have the rectangle name hard coded in (Box414 in this instance) but I would like to have the event get the name of the rectangle clicked and use that as the search criteria
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...
Can a listbox have colored lines? Is it possible by any stretch?
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
Setting height of a rectangle in report when it opens
I have a report which shows percentages and I have a rectangle which changes depending on the percentage. I achieved this by using
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.
Create the Illusion of Colored Tabs
Learn how to Create the Illusion of Colored Tabs. (video tutorial)
Image type form that displays cubicle of search result?
I am trying to create a map type form that will use the rectangle control to represent all the different cubes in an office building and I would like the cube that the person is searching for based on the employee look-up table to change either the rectangle color of the corresponding cubicle or to display an arrow. Are either of these things possible? If not how would I go about accomplishing something similar?
Display coloured rectangle, where colour changes based on table data
It's been a while since I was last here, but I need to scratch your brains for some advice.
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.
Create a tool to fill a table
This is my first project with Access. Tutorials on the internet never correspond to my project.
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.
Using multiple combo boxes to populate a subform
I've created a form and am having difficulty linking my 2 combo boxes to the subform within the form.
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.
On certain forms & reports, I like to block the view several controls at once with a rectangle or a text box-it simplifies the form for the user. It also means I don't have to put in a bunch of Control.visible=true or false statements, but just one for the hider. When certain controls change values or buttons clicked, the rectangle uncovers and makes those controls available.
I am seeing, to me, a weird phenomena. On a columnar form, the top control only in the list always shows through the rectangle. Send to back, front doesn't affect it, it just shows. I found this true in a2003 with XP and a2007 with W
Picture - Problem with Edges of Form
I figured this would be easier to explain with a picture. I have a form and I am not sure why the rectangle - which is set to extend all the way left to right - is not going all the way to the left. I am also wondering what the blue "box with the arrow in it" is. I assume this has something to do with my rectangle not entirely extending.
Conditional formatting on form
I have a form which is bound to a table. The table contains a few records which are shown on the form. There's also a rectangle in the detail section of the form. The backcolor of the rectangle should depend on the value of a field in the record.
Value field Color
Is there a form event which fires per record I can use to accomplish this
Working with Dialog Boxes and Menus
You can create your own dialog boxes and menus. Using the tools presented in this tutorial, you will make your macros behave very much like Access itself--using menus and dialog boxes to improve the user's interface.
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.
Cascading combo boxes using a junction table
I have a Production Data form for users to input their end of shift information into. I would like them to populate the Machine combo box then in turn the Tool combo box would only show the tools used on that machine.
I have a Machine table (macMachine, macDesc), Tool table (tlToolNum, tlToolDesc, tlMinutes/Shift, tlPieces Per Hour, tlCycleTime) and MachineTool (macMachine, macDesc, tlToolNum,tlToolDesc) table for the many-to-many relationship.
I can't figure out how to populate the combo boxes to get the desired results.
Access - a massive tutorial
Access is a unique tool released by Microsoft that provides both the functionality of a database and the programming capabilities to create end-user screens. We've categorized Access into the following topics: Access Exam/Quiz, Forms, Functions, Subforms, Combo Boxes, Modules/VBA Code Text Boxes, Queries, Constants, Reports, Database, Tables, Switchboard, Security, Date/Time, Shortcuts/Hot Keys, Programming Standards and Question & Answer
Create a form by using the Blank Form tool
Access provides several form-creation tools on the Create tab, which you can use to quickly create a form. If these tools do not fit your needs, you can use the Blank Form tool instead. As the name implies, this tool opens a new, blank form, which you can then customize and format the way you want. This can be a very quick way to build a form, especially if you plan to put only a few fields on the form.
Annoying Autocorrection is breaking my form
I have a form with two unbound date text boxes [StartDate] and [EndDate]. then I have a tab control with two queries that filter (or should filter) off these forms.
On the query/subform I have the date field filtered by :
Between Forms![Time Reporting tool]![StartDate] And Forms![Time Reporting tool]![EndDate]. OR thats what it SHOULD say.
Access keeps autocorrecting it to Between
[Forms]![Time Reporting tool]![StartDate] And [Forms]![Time Reporting tool]![EndDate]
A subtle yet destructive difference. I keep getting prompted to enter the date instead of the query referring to the form. When I go to SQL view and correct it there I get the same thing happening: Access breaks my query again.
How do I make it stop
Bridge table between two other tables
I made a tool table with the following fields: Tool ID (PK), department, shop, location, and tool number. A second table with the fields: Set ID (PK), description and qty. I made abridge table with the fields: link ID (PK), tool ID and Set ID.
I made a relationship between the tables - Tool ID (PK) (Tool Table) -> Tool ID (FK) (Bridge Table), Set ID (PK) (Tool Set Table) -> Set ID (FK) (Bridge Table).
I then made a form with a subform using the Tool and Tool Set tables. I can add information in the tool table on the form but when I add information in the Tool Set Table I get the following message: fields cannot be update.
Pulling information from a Table into a Form
I have three Tables and three Forms: Job ID, Tool ID, and Tool Log ID. On the Tool Log Form I want to be able to Log tools in and out. On the Log Form I want it to show 1) Job Name 2)Tool Name 3)Tool Quantity 4)Check-out Date 5)Check-in Date.
I have not had a problem getting it to pull the information from the other IDs for 1, 2, 4, and 5, but when it comes to 3, the Tool Quantity, I want to make sure that the value in the Log Form does not exceed the value in the Quantity Owned Field located in the Tool ID Table/Form.
In other words, I do not want to allow us to accidentally check-in (10) ladders when we only own (9). How do I go about doing this?
Originally I had just included a Quantity Owned Field in the Log ID, and planned to create a validation rule for the check-in/out quantity that said not to exceed the value in Quantity Owned.
In order to do that I tried to pull the value from the Quantity Owned Field in the Tool ID table into the Log Form by using an expression in the Control Source of the Quantity Owned Box.
retrieve name of object user clicks on
I know how to use "Screen.ActiveControl" to retrieve the name of a control that the user clicks on, but how do you retrieve the name of some other object like a rectangle? Screen.ActiveControl does not seem to work for that. I have a form with about 50 rectangles, and I want to retrieve the name of the specific rectangle that the user clicks on.