I did an interesting VBA mod yesterday to copy a customer. This article will document all the code.
There is a form mod to add the 'copy' button, VBA code behind the window to copy the customer, and three stored procedures to do the work.
HTH...