Message after duplicate a record

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)
 
D

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

Similar Threads

Duplicate a subform 6
acPasteAppend Adds Record Instead of Update Record 2
Duplicating a record leaving one field blank for editing 6
Copy record giving three problems 2
Problems when duplicating a record 7
Duplicate Button Baffling Me 1
Duplicate Record Without The Key Field 2
duplicate record except for primary key 2

Top