Hi everyone,
I am new to VBA.
Sometimes a client asks for the same list of products that before so I would like to replicate an invoice (including the items) for the same client, where the order date is the only thing that changes.
Could anyone let me know how to do it using the Northwind example?
The tables used are orders, order details and Customer.
Thanks a lot.
Francisco

A couple of options - and no, I won't be using the Northwind example - I'll use an even more general example.

If Record Selectors are displayed, you could just copy and paste a record, then change the Order Number (or whatever you've called it)
If you need to do something a little more tricky, you could use the Clipboard in a more imaginative way.

Say for example, you have some hidden fields, or there's only certain fields you want copied:
Create a delimited string based on the fields you want to copy,
send it to the clipboard
(http://support.microsoft.com/default...b;en-us;138909)
Go to your new record
Retrieve it from the clipboard
(http://support.microsoft.com/default...b;en-us;138910)
Strip out your delimiters
Put them into the new values

To strip the delimiters out,
http://www.mvps.org/access/strings/str0001.htm
might be helpful

HTH

Steven

I am a loud man with a very large hat. This means I am in charge

Steven,
Thanks for yor help, however what I would like to add a buttom that says "Add Duplicate". It means I have to duplicate:
- the order record/row (having today date)
- the order details records/rows

I am running into problems when I have to duplicate several order details rows. I have no idea how to duplicate them. Nortwind provides the same Orders layout that I have for my invoices.]
I am using Access 97.

Thanks

You could also create an append query and base it off of the primary key of a "selector" form where a user would look up an invoice to duplicate. Set the default value for the field in the table to todays date:

=Date()

That will ensure that your date will be set as today's date.
'----------------
if you are trying to duplicate a complete set of rowa, or maybe line items on an invoice, then use the complete set for the append query.

This are some ideas, hope they work (since I do not know your table structure)




Sal

Thanks for you help, however I do not grasp the idea.

Using the Nortwind example, I would like to add a butoom that allows me copy an order and order details at the end.
On this example the first order contain 3 products, so I would like to add new order with today order date and the 3 products by pressing a button that says "duplicate order".

I can use the clipboard to copy the order fiels however I do not know to replicate the 3 products under the new order.
Again I am new to VBA and I do not find an easy way of doing it.

My question is:
What VBA code I need in the "duplicate order" button?
I would like to use the Northwind because it is very similar to our database.

Thanks a lot.