Recent content by ChrisMore

  1. C

    VBA to Conditionally Format a Chart

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

    VBA to Conditionally Format a Chart

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

    Automated Production Planner

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

    Automated Production Planner

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

    Automated Production Planner

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

    Automated Production Planner

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

    Automatic Label Numbering

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

    Automatic Label Numbering

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

    Automatic Label Numbering

    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?
  10. C

    Automatic Label Numbering

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

    Automatic Label Numbering

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

    Automatic Label Numbering

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

    Automatic Label Numbering

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

    Automatic Label Numbering

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

    Automatic Label Numbering

    It says xlsx files aren't supported so I'll have to paste it instead: Pallet_ID Order_Shipment_Number Ordered_Item_ID Pallet_Number PalletCount Label_Number Pallet_Item_Quantity 0 0 0 1 10001A 100 1 1 1 10 2 10001A 101 1 2 1 10 3 10001A 102 1 3 1 10 4 10001A 105 1 4 2 1 5 10001A...
Back
Top Bottom