Results 1 to 5 of 5
  1. #1
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    1,919

    Read one line of text from Windows Clipboard

    How does one read one line of text from Windows Clipboard in VBA?

  2. #2
    Mickjav is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Mar 2019
    Location
    Margate, Kent
    Posts
    123
    Just asked my friend google that exact question and got a lot of results but not sure which will help you.

    But what I might do is past all the data into a unbound field then grab the first line from that.

  3. #3
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    1,919
    In retrospect, my OP thread title question is a bit misleading given the problem has more to do with using the clipboard to asynchronously communicate between Access apps.

    I have a DB with a message-board that supports communication between apps that I can augment to solve the problem. I just thought there might be a common VBA functionality that I'd not yet come across. Terry Kreft wrote some VBA code several years ago that I've used for ages to put text on the clipboard and it can also be used to "get" data off the clipboard. I could use that in a pinch but it doesn't have anything that addresses synchronization between apps open at the same time. Using the message-board approach just involves a bit of waiting for app to app response but at least not vulnerable to unintended user actions involving the clipboard but unrelated to the apps.
    Bill

  4. #4
    Mickjav is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Mar 2019
    Location
    Margate, Kent
    Posts
    123
    Can't the apps talk to each other are we talking two ms programs ?

  5. #5
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    1,919
    Two totally independent Access DBs running asynchronously. One wanting services normally provided by the 2nd. It's a little different if the 1st app Shells to the 2nd app, in which case the 2nd app would be dedicated to the requests of the 1st app. It's all manageable, just a question of what the independent apps happen to be involved with at any given time. With my message-board approach, the servicing app simply needs to periodically check the board to see if there's a command on the command stack that requires its services.

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

Similar Threads

  1. Replies: 1
    Last Post: 04-04-2018, 02:33 PM
  2. Replies: 6
    Last Post: 09-29-2017, 04:58 PM
  3. 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
  4. Read text file with LF
    By SteveG in forum Programming
    Replies: 8
    Last Post: 12-24-2011, 09:57 AM
  5. Replies: 1
    Last Post: 03-13-2010, 08:38 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