Search results

I've tried both snippets of code but nothing happens on the click event.

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...

Spot on Ridders! It works exactly as it should. The only change I'll make is to the kpi.depot (3rd list) I'll set listDepot_AfterUpdate() to build a string that updates the chart to show KPI by depot number instead of state.

Why cant a * option be a default if nothing is selected, along the lines of this: "WHERE tblData.kpi IN(" & strCriteria OR * & ") AND SecondField IN(" & SecondVariable OR * & ") AND ThirdField IN(" & ThirdVariable OR * & ")"

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...

Perfect that worked :)

Yep, I've tried general number, fixed, currency etc. Still giving me the #Name?

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...

http://imgur.com/WocDgnu The links are as in the image. This is all in the query screen.

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...

Thanks for the diagram jdraw I've put together the attached database. I've tried to follow the diagram but I'm stuck on the allocation (query?). Can you please see where its not aligning?

The required volume of a product (in this case 100kg of flour) is provided upstream by the client as a forecast. Lead time is not in this equation. I have a list of all products in tbl_product and supplier in tbl_suppliers and tbl_forecast which has the client forecasts of required product...

Its for a company that purchases cooking material from a handful of suppliers. We know we need 100kg of flour for next month. This is provided to us as a forecast. We then need to be able to easily allocate this 100kg by whatever supplier we choose. Ideally I'd like to have a table that...

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've attached an image to this message. It shows the same report run in the same way but the chart is scaled differently.

My report is using an A4 page as the report layout. I expected the chart to look and be previewed in the same A4 layout irrespective of screensize?

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?

Silly question again The loop cycles each of the controls in the form via the if statement, it looks at the text box value and asks if it is less than VVal (99,999). If this turns out to be true it does what exactly? Sorry I'm still getting my head around loops.

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...

Thank you very much, works perfectly now :)