VBA to "Copy" text from a field (1 Viewer)

[Leo_Polla_Psemata]

Hi, I have created a table/form in which i store all of my business app passwords.
I use more than 15 applications, each one requires a password that i must change every 30 or 60 days, different format so, not possible to keep one pass for all.
In the form, i would like to create a button, next to password field, this button i would like, once i click, to copy the password that i will paste in my app.
Do you know which method i must use ?

At this moment, i double click the pass, then right click, copy (or cntr +c) and i paste in the application. Simple but there are several "small" problems.
Today, i made mistake, instead of "cntr+c" i typed "cntr+v" and i pasted the previous text i had on my mouse, i was lucky enouph to spot this out and not save the record.

 

[Gasman]

https://www.google.com/search?q=doc...l2j0i5i30l2.7719j0j9&sourceid=chrome&ie=UTF-8

or

https://www.access-programmers.co.uk/forums/threads/copy-string-to-clipboard.66812/

 

[theDBguy]

Hi. Check out the RunCommand method.

DoCmd.RunCommand acCmdCopy

 

[isladogs]

Have a look at the code in my example app SQL to VBA & Back Again - Mendip Data Systems

This uses APIs to copy selected text to the clipboard, paste from the clipboard and to clear the clipboard

 

[MarkK]

Simplest way I have seen is...

Sub TextToClipboard(Text As String)
    ' this is a late bound MSForms.DataObject
    With CreateObject("New:{1C3B4210-F441-11CE-B9EA-00AA006B1A69}")
        .SetText Text
        .PutInClipboard
    End With
End Sub

 

[MajP]

If you want some full featured password manager this one works well and is free. I like it much better than other ones I have tried.

KeePass Password Safe

KeePass is a free open source password manager. Passwords can be stored in an encrypted database, which can be unlocked with one master key.

keepass.info

Has features to automate filling in web pages and apps with user name and password.