MattBaldry
Self Taught, Learn from the Forums
- Local time
- Today, 00:35
- Joined
- Feb 5, 2019
- Messages
- 293
Hi All,
I have been trying to find a solution for duplicating multiple rows but have been unsuccessful so far. I have a table, tblProductLabour, with 4 fields as below.
ProductID (FPK - Number)
ProductLabourID (PK - AutoNumber)
LabourProcessID (FPK - Number)
ProductLabourQuantity (Number)
I just want a simple VBA code to copy the LabourProcessID and ProductLabourQuantity from one ProductID to another.
I have a feeling this is going to be very simple for the Professor Hulk brains you guys have, but I am just stumped. Normally I find everything I want on here, but I think my brain is broken at the moment.
I know I am going to kick myself with how simple this is going to turn out to be
~Matt
I have been trying to find a solution for duplicating multiple rows but have been unsuccessful so far. I have a table, tblProductLabour, with 4 fields as below.
ProductID (FPK - Number)
ProductLabourID (PK - AutoNumber)
LabourProcessID (FPK - Number)
ProductLabourQuantity (Number)
I just want a simple VBA code to copy the LabourProcessID and ProductLabourQuantity from one ProductID to another.
I have a feeling this is going to be very simple for the Professor Hulk brains you guys have, but I am just stumped. Normally I find everything I want on here, but I think my brain is broken at the moment.
I know I am going to kick myself with how simple this is going to turn out to be
~Matt