Search results

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

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

Hi everyone, I'm hoping for some assistance in automating label numbers for pallets. I currently have a manually entered Pallet_Number field that stores the pallet number for each item on a shipment and groups the items together so they can be printed on individual pallet labels. However, each...

Thanks for the suggestion, I've tried to implement the code and I'm getting a Compile error for .Controls in lngQtyLast = Nz(.Controls("Zone" & vZone & "_Quantity"), 0). Any thoughts?

Thanks! That removed the error and I got the code working using the following: If strZone = "None" Then lngQtyLast = Nz(!Product_Quantity, 0) Else If strZone = "A" Then lngQtyLast = Nz(!ZoneA_Quantity, 0)...

Hi everyone, I'm trying to add an optional variant to the below inventory control code. I would like the code to output the current inventory for a particular zone of the warehouse if specified when calling the code. If a zone isn't specified, the code will return the current inventory for all...

Wow @arnelgp that works beautifully! If only I'd found your post on that thread when doing my research, I wouldn't have needed to create my own thread. Thank you very much for the post. And thank you to everyone who contributed :)