Message after duplicate a record

  • Thread starter Thread starter gg
  • Start date Start date
G

gg

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)
 
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.
 
Back
Top