Results 1 to 2 of 2
  1. #1
    Alaska1 is offline Advanced Beginner
    Windows Vista Access 2003
    Join Date
    Oct 2010
    Posts
    55

    Turning off Clipboard option with Duplicate Record

    I have created a duplicate record button on a form. It works fine, but everytime I closed the database, it states a large amout of data has been copied to the clipboard etc. You have to choose yes or no to close it. Is there a way to turn that off?

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    is there an option to not copy data like that?

    I can't remember if there is or not. try:

    http://www.tek-tips.com/viewthread.cfm?qid=1227582 OR

    http://www.mvps.org/access/api/api0049.htm

    or simply call the API:
    Code:
    Declare Function EmptyClipboard Lib "user32" Alias "EmptyClipboard" () As Long
    the returns most likely are 0 and 1, 0 stating a failed call and 1 stating success.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Duplicate last record to next record in form
    By jdhaldane in forum Forms
    Replies: 4
    Last Post: 12-17-2010, 04:22 PM
  2. Clipboard on Duplicate Record
    By Alaska1 in forum Access
    Replies: 5
    Last Post: 12-02-2010, 10:25 AM
  3. If duplicate record, go to original record
    By BigBear in forum Forms
    Replies: 2
    Last Post: 10-06-2010, 02:58 AM
  4. If duplicate record, go to original record
    By islandboy in forum Access
    Replies: 51
    Last Post: 06-02-2010, 04:17 PM
  5. Turning Combobox to Dropdownlist
    By jonny in forum Access
    Replies: 1
    Last Post: 10-19-2009, 04:33 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums