Search results

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?

Thanks very much for your assistance, I shall attempt to implement this into my database set up :)

Amazing, thanks so much. I'm just wondering, can the below part of the code be ordered by Pallet_Number? Set rs2 = db.OpenRecordset("select pallet_number, label_number from table1 " & _ "where ((order_shipment_number) = '" & ![order_shipment_number] & "') and...

Thanks, that's an amazing start! The trouble I can see is the 'PalletCount' field doesn't exist in my database's Pallets table. This was only a helper column for the excel formula to work. Therefore, I would need to add this field to the Pallets table and your code would also need to build that...

I feel like there is starting data and expected final output, unless I am misunderstanding you. The column headers highlighted in blue are starting data and the green column is the expected final output.

Yes, each shipment has its own set of label numbers and pallet numbers starting from 1