Search results

I've recreated an example of a navigation form with 3 subforms (CatA, CatB, CatC). When a certain subform is selected I want the the listbox in the selector subform to update to only show that type of category items. I've set a on click event when CatA is selected in the navigation form that...

I've attached a copy of a early build of a dashboard I'm trying to create. What I am trying to do: There are 3 list boxes that change the output of the graph below it after each selection. The VBA I have at the moment works well for the first list box but I'm finding it difficult to add in...

If I have a blank form, and I want to reference a query in a text field, e.g. query name: qry_TotalValue field: TotalValue (numeric) I want that field to be displayed in my blank form. I've tried by click on the control source and selecting the field from the query...

I have 1 table and 2 queries: tbl_Months qry_ForecastV qry_ActualV I have the ForecastV and ActualV queries linked to the tbl_Months via the month field. Instead of getting this: MM/YY Forecast_v Actual_v 11/16 1100 12/16 1000 1200 01/17 600...

I've got a list box field in a table. This field allows users to select multiple inputs. In my case the listing is: Supplier A - 10% Supplier A - 20% Supplier A - 30% Supplier A - 40% Supplier A - 50% Supplier A - 60% Supplier A - 70% Supplier A - 80% Supplier A - 90% Supplier A - 100% Supplier...

I have a report that looks and prints fine on my 22" screen, but when I see it on my laptop screen the charts are massively scaled up. How do I get access to lock the scale/resolution to be as created?

I've got a number of text boxes that have calculations in the control source that work off other fields in the form. There are 32 of these boxes named R1 - R32 I want to run VBA in the background to: 1. Pass through all 32 text boxes - R1 through to R32 2. Ignore any text box values that are...

I have a list box (ReportList) with 5 options Y1 Report Y10 Report Y15 Report Y20 Report Y25 Report I also have a button that when triggered opens any of the selected reports along with a where condition: DoCmd.Open Report Me!ReportList, 2, WhereCondition:="[Page] like '*" & Me.cboPageNumber...