Reports :: Combo Box Won't Show Dropdown List In Header Area
Mar 28, 2013
I have a combo box in the header area. The record source, Bound Column are set correctly ( I know because I tested it on a form ). In this instance, the user would select from the dropdown list, the name of a member of staff, based on the click-event, and passing the Staff_ID to a variable, this would be used to filter a recordset/recordsource for the report. However, there is no dropdown ( or arrow on combo - so no name can be selected ) ?
How do I move combo box label into the form header area while leaving the actual field title in the detail area in a subform so they looked stacked like the other items??
I have a dropdown list of reports that is supplied by table. I also have listbox that are populate by another table. I want to be able to run the reports from the dropdown and from the listbox ....whatever the selection is to pull that info from the report and display.
With Access 2000, for the On Focus event, typing Me!MyCombobox.Dropdown displays the entries in the drop down list. With 2007 the list appears momentarily and then disappears. Is there a way to keep the list from disappearing
I'm trying to create a report where I can use a section header as a hyperlink to show/hide detail, but only for that section. For example, my customer names are:
Code: ABC Co. ZYX Co. 123 Co.
If I click on ZYX Co., I want it to show the contracts for ONLY that customer:
I have a form where I have two drop down list box.The first list box is called Transaction_Type. It contains three values: Created, Allocated and Sold
The second list box is called Product_Status. It contains 6 items: Allocated, Produced, Reworked, Shipped, To Be Produced, Unallocated.
I have a products form. When a user created more inventory they will selected in the drop down list create, then a quantity. Then I would like the status of the product to update to "Unallocated".
When the user placed an order but doesn't finish it they will choose the status of the inventory to be allocated so I would like the product status to be updated to allocated automatically.
They other status the user will choose them self and do not need to be linked to each other.
In my vba code I have tried with the OnClick and AfterUpdate sub procedures with the following code.
If Me.Transaction_Type.Value = "Created" Then Me.Product_Status.Value = "Unallocated" End If If Me.Transaction_Type.Value = "Allocated" Then Me.Product_Status.Value = "Allocated" End If
Yes when i select "created" from the drop down list it does not change product_status to say "unallocated"
I'm producing PDF reports in a VBA routine in Access through the DoCmd.OutputTo acOutputReport.
The routine works great, however i have now a new requirement and i need to change the report header so to if Country X is selected in a drop-down menu, then only image X is shown on the report header; if country Y is selected then only image Y is shown on report header.
I was simply thinking to make this through the "visible" option of the image, however it doesn't work because i get error "report must be open".
I must create a database for the company that I work for that covers the maintenance history of our stone crusher plant. In this database I have two dropdown lists. The first one is for the equipment and the second one is for the different types of parts that has to be replaced or fixed.
Not all of the equipment uses all of the listed parts, but some parts are used on more than one type of equipment.
I have already created a database that lists all the equipment and another one that lists all the parts.
What I want to do now is create a Yes/No box for each type of equipment so I can mark which parts is used by which equipment.
Then you must be able to select the type of equipment from a dropdown list and then select from a dropdown list that only has the parts that is used by the piece of equipment.
I have made a few cascading combo-boxes that dynamically change based on the data entered into the field above them.. Example:
A SKU is entered, the combo-boxes pull the information for that sku from one or more tables (using SQL Query).
Now... I am having trouble getting these fields to show the first item in the list of possible item specifics. Everything comes in fine, however, I need to form to refresh and repopulate the fields one the SKU loses focus.
On my Class form when assigning students there is a combo box which shows the students names. Once a student is picked in the combo box their name shows up in the subform.
What I would like is a way to NOT show a student in the combo box after they have been selected. Is this possible? Or should I be looking at another way of doing this?
I know that multivalue fields are not the best to use, but I have a simple database that they work fine in. My question is this: Is there a way to show the entire list of choices in the multivalue field on a report? Not just the ones selected, but all of them, whether checked or not? The multivalue field has a list of names and the user selects each name if they repond to a incident (fire, car accident, etc.). My report would show the entire list and count number of responses by each name during a date range. I want to show all of them on the report, with those not selected showing "0".
I have show results of scores on a graph but need to show if those scores fall below, in between or above acceptable limits. For example, lets say the acceptable range is between 10.5 and 15.6 but people can scores between 0 and 50. So what I need to do on a report chart/graph is show the actual scores in columns, let access automatically adjust the scale, but have the area between 10.5 and 15.6 on the scale highlighted or coloured or perhaps indicated by two horizontal lines across the chart/graph.
I have a table that shows "DONE" and "REMAIN" for each "AREA" like below:
Code:
AREADONEREMAIN TOTAL AREA1100200300 AREA2200300500 AREA3200700900
Now I like to make a report that shows "DONE" and "REMAIN" in each AREA with pie chart, now I have problem how I have to do this job for the graph, how should be "row source" of chart control. What query needs on this table?
I have date picker which works correctly in form. When I put that form as subform to reports header calendar shows up but after selecting date on calendar textbox stays blank. Format of textbox is Short Date, Show date picker property is For dates.
I am very new to Microsoft Access, and hope somebody can help me. Apologies for what I am sure is an easy subject - but I dont know what keywords to search on!
Basically, I need to have a drop list of say 5 different products. Now depending on the product will lead to different field boxes (say each product has 15 fields, 10 which are the same, but 5 which are unique to each product). I basically want the form to change dependent upon the product type. As I say I am very sketchy on this, so feel free to treat my like an idiot! If anyone could give me a hint as to what help topic this relates to, or give me a brief overview of what to do, that would be very much appreciated. The information will be downloaded from an ODBC if that makes any difference.
I want to create the dropdown list on the form, the dropdownlist will have 5 values, I want to give out description of each value when the user move the mouse on the value. Does the dropdownlist control have this option?
I am having trouble to link a listbox on a subform (table) tot de main form (table). I would like to use it as an lookup list for the connected records. Already tried a lot but but it doesn't work .
Hi! I have a tables. One is called: products => prdouctID,productName, ProductPrice
I created a dropdown list. To read in the values of productName.
I wanted to have a textbox / label which will update the productPrice. If i select productName as "Pirates", the textbox/label will show $50.00 If i select productName as "Who let them out?", the textbox/label will show $80.00
I have managed to do the dropdown list but cant seem to figure out the label / textbox.
I'm trying to set up a database of books in a small library - each book has a prefix (Maths, English, Art etc) which I want users to be able to pick from a drop down list - I can do this, but the next field is a sub-category - is there a way of populating the dropdown list for the sub-category field depending on the chosen entry in the prefix field. eg if maths was chosen I would like the user to have the choice of number area, volume etc. but a different choice if the prefix was English.
any help very gratfully received - it seems to be a simple problem but it has me stumped.
I am trying to put a DROPDOWN LIST BOX in a access 2003 form, NOT a combo box. I only need this so I can disallow users from manually entering data into the combo box by typing it in. I want them only to be able to choose it from a list. I think that a LISTBOX is the only way to do this, other that using a straight list box, which would use too much room. However I cannot find any way to add this to a form. Any thoughts?
I need to use a selection from a drop down list to change the criteria in a query as opposed to typing text in a parameter box. This is to allow the user to choose from a list and then click on a command button to move to the next query. There are 20,000 records in the table. The series of queries will take the user to 1 or 2 records in 3 or 4 mouse clicks.
The header in a list box is derived from the data source. I have a list box that derives it's data from a select query, now one of the columns in the list box/query is an Expression (Expr1).
My question is, is there a way of replacing the column header "Expr1" with a more meaningful header?
