theKruser
Registered User.
- Local time
- Today, 17:56
- Joined
- Aug 6, 2008
- Messages
- 122
I would like to be able to create a button on a form that will call a query/report and copy the results in plain text to the clipboard.
I am assuming the best way would be to create a hidden text box on the form and assign it's value with VBA, then use the acCmdCopy method. However, I am not sure how to call a query in VBA and assign the default value to a query result.
This problem is further compounded by the need to copy the results of a form with subform to the clipboard in other forms.
PLease help if you can. I am lost and on a deadline. Thank you in advance for your help! Have a nice day.
I am assuming the best way would be to create a hidden text box on the form and assign it's value with VBA, then use the acCmdCopy method. However, I am not sure how to call a query in VBA and assign the default value to a query result.
This problem is further compounded by the need to copy the results of a form with subform to the clipboard in other forms.
PLease help if you can. I am lost and on a deadline. Thank you in advance for your help! Have a nice day.