HELP! With copy button...

getgrounded

New member
Local time
Today, 01:20
Joined
Oct 20, 2007
Messages
3
I am creating a database to input complaint calls my business gets.
The user input the information into the form.
The info goes into database, everything works perfect.

EXCEPT.

I need to include a button which when press will take a copy of the form.
No need for just text...
I'm taking about a screen capture of the form only.
Not a full window...
We have to email each other that we completed the input.
And taking a screenshot is easiest...
Except I only need the form window not the whole screen.

I"ve been going crazy with all of the cmd copy things...
Please help what do I need to do..
I simply want to create focused screenshots.

Or is there something easier to transfer the information inputed into a form, to go to clipboard.
 
Or is there something easier to transfer the information inputed into a form, to go to clipboard.
Yes imo.

Personally I would create a report that looks like the form. Then have a button on your form that runs the report for the current record (the wizard will help you do this). Once you've run the report you can email it.

If you are using MS Outlook then another method is to use vba (code) to create an email using the information entered on your form. There are many posts in these forums about how do this. Take a look at the SendObject method in vba.

If you want to copy/paste then do the following:

Create a new text box and name it CopyBox

Add a new button and in the onclick event, add the following:
Code:
me![copybox].value=me![my first field] & vbcrlf & me![mysecondfield] & vbcrlf & me![my3rdfield]  etc....
me![copybox].setfocus
docmd.runcommand acCmdCopy
You can tailor the first line to suit e.g. you can add text to show what the data means. Note the use of vbcrlf which creates a new line.

When the button is clicked, the fields you've coded will be copied to the clipboard.

hth
Chris
 
Or, you can see about using this one which will give you pretty much, I think, what you want.
Code:
    DoCmd.RunCommand acCmdSelectRecord
    DoCmd.RunCommand acCmdCopy

It will copy the current record and when you paste it, it will have the fields and the header.
 
wait still troubleshooting..

WOW!
Thanks I feel like I'm almost there...

The command BobLardon does work... And appears to be exactly what I want except that the formatting is all off.
When I paste the copy it is totally out of sync... It's pasted across the screen is there any way to format the info?

And then on Stopher the command now says "cannot find "copybox" referred to in your expression" do I need to go back to my orignial table and make a new field?
or are we talking about a text box (hidden) in the form to copy the text to?
Your command might be better suited, since I can format the paste line by line.

PLEASE ADVISE.
 

Users who are viewing this thread

Back
Top Bottom