Search results

Hi Colin, Thank you very much for the time you have spent looking at my project. Also, I really appreciate your feedback. I am self taught with VBA so a lot of bad habits and/or over complications have crept into my coding over the years. It is very helpful to have direct feedback on what I have...

As I said, no rush. I do appreciate your time helping me with this :)

My main objective was to have the blue progress bar coloured like the traffic light system, as you say. However, since using a modern chart, the requery part of the calendar report code is no longer working so the chart is not updating when the calendar controls are used. The chart updates with...

That's correct, Monday_Machine_Type_Usage_Total_StackedChartReport is the chart report and the chart is named Chart4. No problem, there's no rush to resolve this. Others are welcome to take a look. I am grateful for any help I can get.

I didn't because I wasn't 100% sure on what you meant and you mentioned manually changing the color of the bars and this is what I want to avoid. I was also distracted by learning about modern charts so ended up going down that route.

Hi Colin, I've attached a sample version of the project I'm working on, along with the data. The database will open to the calendar report and you'll see the chart in question under Monday. Above that is the controls to change the work week. Underneath these controls are some helper text boxes...

Hi, I've still not managed to work out the coding to automatically change the color of the bar char bars depending on the bar value (in the style of conditional formatting), so at this moment I have settled for a stacked bar chart as shown below. The blue bar shows the progress as a percentage...

Thanks, that does sound interesting. I'll try and join your meeting later.

The more I play around with modern charts the more I'm finding them unintuitive. What would be simple to do with a classic chart is difficult or seemingly not possible with a modern chart. I'm trying to remove the Y axis values, add grindlines to the X axis (horizontal) and add a custom format...

Thanks so much for the suggestion, I didn't know about the modern charts feature. I do have A365 so I've been playing around with a modern chart and looking at your impressive guide you linked. Is there a way to code the modern chart to automatically change the fill color of the chart bars based...

I'm back to this project after a short break... Thanks for the search suggestion, this has brought up some useful results. I've looked at the one https://stackoverflow.com/questions/49456176/changing-the-color-of-a-bar-chart-in-access-using-vba and the property "SeriesCollection" keeps coming up...

Thanks for the suggestion. You say "set the colors as you desire" so do you mean coloring the chart bars manually? I require the chart colors to dynamically update as the value of "SumOfPercentage" changes for each category.

Hi, Please can I have some help with VBA to dynamically change the color of a bar chart based on the value of "SumOfPercentage". It's frustrating that Access doesn't have a built in conditional formatting option to do this. If value is under 50 - green If value is between 50 and 90 - orange If...

Hi, attached is a sample version of the database. I have only included the calendar section of the database with the traffic light system but you can see the table structure etc.. Double click on the records in the calendar report to open the order form. @JTrilloJ 1. I'm not sure what you...

the database is split, is it just the back end tables you need to see?

Hi Gasman, thanks for your input. This has already been discussed and the managers have a judgement on capacity based on their experience on how many of a product can be manufactured per day. However, this judgement will not be accurate on a daily basis, so we might not be achieving our maximum...

Hi everyone, I am looking for some guidance on how to approach building an automated production planning system into my existing orders/stock database. A little background on our business operations and current set up: We manufacture fire barrier insulation using various machines and staff to...

Amazing, this is working in my set up now, subject to testing. Thank you very much for your help :giggle:

Thanks for this but the combo selection doesn't seem to be making a difference, the code is still updating all rows. I added a record with a new shipment number and it updated the label number even though I selected a different shipment number.

When I run the code it is updating the Label_Number field for all rows in the Pallets table. How do I amend the code so only the rows are updated for a specific Order_Shipment_Number based on a combo box selection?