Inserting a picture from a webcam into a bound OLE object control on a FORM.

Posted on 2006-05-17
Last Modified: 2008-02-01
Using ACCESS 2000
We have a form with a bound OLE control in which the user RIGHT CLICKS, selects INSERT OBJECT, then chooses CREATE NEW, scrolls down and selects Microsoft Photo Editor 3.0 Scan, then clicks OK.
This then opens up Microsoft Photo Editor with a capture popup from the Logitech Camera software where they capture the picture, Crop it, then go up to the FILE menu and choose update.   The captured pic is inserted into the OLE control.

What we would like, is a button that performs as many of the steps as possible.  For example if it the code or macro could only start the insert command and the users had to do the rest, that would be good.  (this would at least elimnate the right click and eliminate the possibility of them making a wrong choice on the drop down menu.   If the code or macro could go even further and select Microsoft Photo Editor 3.0 Scan, that would be GREAT.    

I have a related question that I will post about displaying the bytes a picture is taking up so I can tell if the user has taken the picture at the correct resolution and cropped it the way they are supposed to.

Any help would be greatly appreciated.
Question by:TechGuise
    LVL 65

    Accepted Solution

    As photo editor is seperate and all,

    How about using Macros? (not Access macros but Windows Macros)

    Author Comment

    I've never done Macros outside of Excel & Word.  Seems like I used to play with them back in Windows 3.1.  I guess I don't even know where to start.   Right now I'm working on the code you gave me for my other question (thanks a million by the way).   It's a little over my head, but I'm looking at it.
    LVL 65

    Expert Comment

    alright, good learning exercise though eh :)

    with this question, I wouldnt know how to code it as Ive not done much to do with external things like this.
    I know with Access u have automation, code that allows u to access other office products, but I am not aware of anything like this. It might be worth a check on for something.

    I came up with the idea of macros as I couldnt think of anything else, doh!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
    Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now