Search results

Yes I’m aware that the original request re CF wasn’t resolved. I believe it’s not possible at the moment but will certainly let you know if I hear otherwise I had also asked CoPilot before @June7’s post. It also stated it wasn’t directly possible and gave several alternatives including the same...

I’ve raised it before as an issue. Will do so again but, even if they agree, there are other major new features being worked on that need to be completed first

Its such a basic request but that functionality is not currently available in modern charts There are various axis related properties you can change either in code or from the property sheet: However selecting major / minor units is not available. A significant omission.

Yes I can see what you mean. Either there is an error in the original code you used or (much) more likely I have made a mistake somewhere. I didn't think there is an issue with the RequeryObjects code I used, but that now looks like the problem. As far as I can recall I didn't alter any of your...

You could have just said full VBA support for modern charts is only available in Access 365. Nevertheless, limited support for properties of the chart object are available using code in all versions from 2019 onwards.

All versions of Access including 365 are 'desktop versions'. There is no cloud edition of Access

Glad you're happy with it! As I said (after editing my initial reply), there was no need to requery the chart itself as that happens automatically You can probably remove the Refresh button now as well. When I tested it failed on the Cutomer_Order_Form ... Goods_Out_Search_Button_Click on the...

You can't directly delete columns for linked tables from Access (other than by using DDL queries) However, you can hide any linked table columns that you don't want to use in Access

SUCCESS! Add ONE line to the RequeryObjects sub I showed in post #31 and it updates correctly Private Sub RequeryObjects() Me.Monday_Production_Report.Requery Me.Monday_Machine_Type_Usage_Total_StackedChartReport.Report.Chart4.RowSource = "Monday_Machine_Type_Usage_Chart_Query" '...

I can’t be certain due to the way you’ve coded this but assume that it’s not updating due to how the data source has been built up. All the charts I have ever created update automatically to any data changes at runtime.

Hi Chris Sorry but I can't see any way of applying conditional formatting based on the values of the percentage (blue) bars i've just asked a member of the Access team if he can suggest a method of doing so and will let you know if I get a solution As for the requerying, your chart is based on...

You are only limited to 3 fields using the crosstab wizard. Start with that then add all additional fields manually in the query SQL or query designer window

You said you were struggling with the crosstab query in Access. I asked you to provide the SQL for your attempt at a crosstab query together with the query output.

Just realised this is in the SQL Server forum

What’s the table or query name? Post the query SQL that you use and the results obtained.

Not sure what you mean by 'column folder' You can delete a column (field) in design view You can also do this in datasheet view if Enable design changes for tables in Datasheet view is ticked in Access Options | Current Database

You’re welcome

OK thanks. Can't do anything for now as I have a problem with my Office installation which I'm trying to resolve

Two more questions to speed things up: 1. Am I right in thinking that all you are interested in is the blue progress bars on the stacked bar chart? However, you would ideally like the progress bars to be the colour of the traffic light section where the bar ends. 2. The chart does appear to...

Just to check, the report shortcut is called Monday_Machine_Type_Usage_Total_StackedChartReport, the parameter dialog is Finally the chart control is Chart4 .... I think it will take me a while to work out how this all works and it may not be today. Perhaps others can look at it as well