Results 1 to 2 of 2
  1. #1
    merebag is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Sep 2016
    Posts
    19

    Copy to Clipboard using MSForms.DataObject for Access 2013

    I have VBA code that I used in my Access 2010 project app and in converting to 2013, the process to load records into the clipboard using the MSForms.Dataobject is not working. I get the Compile Error: User-Defined type not defined. Am I missing a control that needs to be added or is there another way to perform this task in 2013?



    (see the attachment)
    Attached Thumbnails Attached Thumbnails msforms.png  

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,870
    I don't use MsForms, but my guess is that you have a missing reference. Check your references and see if any have MISSING...

    Update via Google:

    For using MSForms.DataObject in your code you need library “Microsoft Forms 2.0 Object Library”.

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

Similar Threads

  1. btn macro what can copy text to clipboard
    By TriFith in forum Import/Export Data
    Replies: 6
    Last Post: 07-01-2016, 02:45 AM
  2. Copy To Clipboard - Max Length?
    By fredz in forum Access
    Replies: 3
    Last Post: 05-31-2014, 02:03 PM
  3. Copy items in a column to the clipboard
    By kevinscomp in forum Access
    Replies: 1
    Last Post: 08-07-2013, 06:57 PM
  4. Replies: 2
    Last Post: 12-05-2012, 09:39 PM
  5. Use VBA to copy table contents to the clipboard?
    By Deutz in forum Programming
    Replies: 3
    Last Post: 10-21-2010, 10:59 PM

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