Sendkeys Copy has changed

Posted on 2011-04-18
Last Modified: 2012-06-27
I used to be able to use:

SendKeys "^C"
MsgBox ("Contact Email copied:  " & Me.Contacts_Email)

And I would get in the clipboard:

now I get

Microsoft Office Access
Contact Email copied:

What the heck is going on? How do I get JUST the field I wanted copied?
Question by:hgj1357
    LVL 75

    Accepted Solution

    I'm not quite following.
    But, try this:

    DoCmd.RunCommand acCmdCopy
    MsgBox ("Contact Email copied:  " & Me.Contacts_Email)

    LVL 2

    Author Closing Comment

    Simple. But that changes the way I have done that particular thing for the last 15 years!!

    LVL 75

    Expert Comment

    by:DatabaseMX (Joe Anderson - Access MVP)
    I guess we got lucky ...

    You are welcome ...

    btw ... what version of Windows and Access ?

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now