Message after duplicate a record



I am duplicating a record on a form using code learned on this site:
DoCmd.RunCommand acCmdSaveRecord
DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdCopy
DoCmd.RunCommand acCmdPasteAppend

Works, but when form is closed, the annoying message about "You copied a
large amount of data on the clipboard" displays. Any way to get rid of that?
(I use Ac2000 on W2000)

Daryl S

GG -

After the PasteAppend, try selecting something like a small field and then
do the acCMDCopy. This will replace the clipboard with a small value,
instead of a link to the larger record, and the message won't come up.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question