Hi,

I very new to access. What exactly I want is that users will take a screenshot of an application and paste it in the form by possibly an unbound ole object or whatever is suitable or suggested. There are other fields in the form to be filled up. How can I do the same without asking the user to actually save the image in a preferred location. Please help me out as I am in a great fix.

Thanks a ton in advance!!

Sujoy

This is actually complex. Yopu might check with the Techsmith people, makers of Snag-It one of the top screen capture utilities. They may be able to suggest a way to generate a screen capture within Access. But normally if a user is doiung a screen capture, they will be saving the captured image. If you just paste it into a OLE filed within Access this will cause database bloat.

I am using the tool for my office so won't be able to use any other software... sob... What I was doing was to right click and insert the pic... like as in we write... docmd.runsql insert into command text0.value same way what should I use to write the same for Ole objects... space won't be a concern as we do have loads of space to breathe...

Thank you for your time hope my questions don't bug u...

Space is a concern for performance reasons, not just storage capacity. Also remember that an Access file can't exceed 2G. Storing images can cause it to quickly reach that limit.

I would strongly recommend that you recommend to the office to get a site license for Snag-It. In either case, you need to educate users on saving images and storing them for a link. What I would do is after they start the record using the recordID as the image file name.