I currently have a master table (prerelease info) that contains order number, sale price, quantity, cost, serial numbers, etc. My issue is that sometime when the item arrives, it arrives in a partial state. That is, I order 3, and I only get 1. Once this 1 item arrives, I move it into inventory and ship it. What I've been doing is going into this table and copy the record and then reduce the first occurrence by a qty of 1. I would like to generate a function that takes the record and all of its fields and copy them into the same table. I know it would be easier to just keep track of the qty, etc. But each item received has a separate serial number that I would like to track, so it makes things a little more difficult. Does access have such a macro or VBA code to copy and paste a record?
Sami Shamma
@Reply 2 years ago
The solution is in the database design.
you want to track the serial number of (in this example) 3 items. how do you do that now if you received all three items at the same time? it is clear to me that you need a child table that contains amongst other information: Serial Number, Date Received, etc.
Now you can write your "Sub"/"Function" to do receive items
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.
