Copy/Paste Function

[AccessHawaii]

I'm trying to perform a copy paste function for screenshots. I have a field in the table set to "ole" and I know you can copy and paste screenshots into it by using the keyboard but I was wondering is there anyway that you can set it up so when the user gets the screen capture, they can click on a command button and it will automatically paste the screenshot into the ole field? If anyone knows how to do this, I'd greatly appreciate it if you could tell me how.

 

[sfm6s524]

If your form has a "Bound Object Frame" set to your tables OLE field, perhaps named oleScreenShot, your button code could look like:

Me!oleScreenShot.SetFocus
DoCmd.RunCommand acCmdPaste

 

[sfm6s524]

Oh yeah....Be warned that table will get awfully large!

 

[AccessHawaii]

Thanks for the advice, it worked like a charm. I know what you're talking about with the images taking up a lot of space, the images are only going to be stored until I view them and then delete them so the table won't grow too big. Thanks again.