How do you clear the clipboard from VB Code?

[kramerica]

I have a form in Access 97 that copies the "current Record" and pastes it as a new record using the "duplicate Record" feature built into the wizard. When I close the form I get a warning that say's 'You have copied a large amount of data onto the clipboard.. ' How do I clear the clipboard from Visual Basic code after I duplicate my record in order to avoid this annoying warning!?

 

[THoey]

I have the Access 97 Developer's Handbook by Litwin, Getz and Gilbert (SYBEX). In chapter 18 they briefly mention this as an API call. The code on the CD uses:

Private Declare Function adh_apiEmptyClipboard _
Lib "user32" Alias "EmptyClipboard" () As Integer

Hope that helps... Terry M. Hoey

 

[Databaseguy]

Have you tried using the recordsetclone instead ??

 

[Sameal]

I am not sure about Access 97 but in Access 2000 you can turn a lot of confirming messages off in Tools->Options. Maybe a good place to start looking.

Sameal

 

[THoey]

I wouldn't turn off the messages just for this, you might have another error message that you miss. You either need to find the way to clear the clipboard or find the specific error message and handle it. Terry M. Hoey