G
Guest
--
Rickster172
Rickster172
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dirk Goldgar
See this link:
http://www.mvps.org/access/api/api0049.htm
API: Copy variables/control contents to memory
Note, by the way, that it's preferred to put your question in the body
of the message, rather than just in the subject.
http://www.mvps.org/access/api/api0049.htm
API: Copy variables/control contents to memory
Note, by the way, that it's preferred to put your question in the body
of the message, rather than just in the subject.
G
Guest
Is there a way to program a button to put info into clipboard?
G
Guest
That is alot of code. What I want to do is put info like Clients Name,
Address, City, State, Zip Code into the clipboard by clicking on a command
button, then load another program and paste that info using control V. --
Rickster172
Address, City, State, Zip Code into the clipboard by clicking on a command
button, then load another program and paste that info using control V. --
Rickster172
D
Douglas J Steele
So what if it's a lot of code? All you need to do is copy and paste that
code into your application once, and then call it the way you would any
built-in function.
code into your application once, and then call it the way you would any
built-in function.
G
Guest
I've just read this stuff on copying into the clipboard. I've not started
programing yet but would like to try installing this. can you tell me where I
copy it to and how I set up a button or whatever to make it work?
programing yet but would like to try installing this. can you tell me where I
copy it to and how I set up a button or whatever to make it work?
D
Douglas J. Steele
Create a new Module (make sure it's not a Class Module), copy everything
that's between Code Start and Code End, paste it into the module, and save
it. (make sure the name of the module isn't the same as any of the routines
within it.
In the Click event of your button, assuming the data you want to put in the
clipboard is in a variable strMyText, put the following code:
Call ClipBoard_SetText(strMyText)
You might also check http://support.microsoft.com/?id=138909 and
http://support.microsoft.com/?id=138910
that's between Code Start and Code End, paste it into the module, and save
it. (make sure the name of the module isn't the same as any of the routines
within it.
In the Click event of your button, assuming the data you want to put in the
clipboard is in a variable strMyText, put the following code:
Call ClipBoard_SetText(strMyText)
You might also check http://support.microsoft.com/?id=138909 and
http://support.microsoft.com/?id=138910
G
Guest
Douglas, thanks for responding! I've looked at your reccomended support
sites but will need a little time to work through them! Meanwhile, at the
risk of sounding a bit of a dumbo, you've said..."assuming the data you want
to put in the clipboard is in a variable strMytext" Where does this
variable live and how does the text to be copied to the clipboard get into it?
sites but will need a little time to work through them! Meanwhile, at the
risk of sounding a bit of a dumbo, you've said..."assuming the data you want
to put in the clipboard is in a variable strMytext" Where does this
variable live and how does the text to be copied to the clipboard get into it?
D
Douglas J. Steele
The variable lives in your code.
You can assign it its value any way you want: you can base it on the content
of one or more text boxes, you can concatenate values by looping through a
recordset, you can use an Input box to get text from the user, or some other
possibility I haven't thought of at the moment.
You can assign it its value any way you want: you can base it on the content
of one or more text boxes, you can concatenate values by looping through a
recordset, you can use an Input box to get text from the user, or some other
possibility I haven't thought of at the moment.