Results 1 to 11 of 11
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    314
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Trouble registering ACTIVEX component (Access 2000)

    I have found an activex component for triggering TWAIN devices, including scanners, on the internet.
    (VintaSoft Twain control -VSTwain.dll - see http://www.vintasoft.com)
    When I try the examples that come with the trial version for Excel 2000 and Word 2000 they work perfectly.
    But I can't get it to work in Access 2000. I thought I had gone through all the correct steps to register the component
    (TOOLS/ACTIVEX CONTROLS ETC) and have put a reference to the dll in the visual basic screen for my application/database
    but it refuses to work. Tried the regsvr32.exe method too but still no go.
    In the example given the control seems to be properly registered and listed as an object.
    But in my Access application it doesn't appear, although the libary is shown in the Object browswer and all the methods and properties
    correctly listed.
    Am I missing some step here?
    Please elucidate!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Trouble registering ACTIVEX component (Access 2000)

    Have you placed a Twain control on your form? Open the form in design view, click More Controls (the last button) on the Toolbox, select the VintaSoft Twain control, then place it on your form.

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    314
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Trouble registering ACTIVEX component (Access 2000)

    Yes, I worked that much out.
    It's funny: the sample given by VintaSoft is in Excel and it works fine. But now I've figured out how to use, as an alternative, the Kodak Image Scan Activex control that was there in Office 2000 all the time,
    I'm having identical problems in both Access and the same Excel workbook. In both cases the control is present,the references are set in the Visual Basic module and the Twain controls are both registered.
    In both cases (Access and Excel) the relevant object libaries appear in the object browser. But only the original Vintasoft example works - ie the one set up by the Vintasoft setup program.
    It really seems like there is a third thing to do that I am not-so-blissfully unaware of.
    What is it?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Trouble registering ACTIVEX component (Access 2000)

    I'm sorry, I don't have the VintaSoft control (and even if I downloaded it, I couldn't try it out since don't have a scanner), so I fear I can't offer further assistance.

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    314
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Trouble registering ACTIVEX component (Access 2000)

    Thanks anyway Hans. My problem though is more general than scanning or using this particular ActiveX control.
    Can you point me to any good references that explain the procedures for getting these controls properly registered and working in Access VBA?

  6. #6
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    314
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Trouble registering ACTIVEX component (Access 2000)

    Thanks, it's working now. Another case of deliberately poor documentation from Microsoft.
    Seems they are losing interest in imaging applications.

  7. #7
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    314
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Trouble registering ACTIVEX component (Access 2000)

    Yes, I was going to but there are still some annoying little things I want to iron out first.
    Will post a more satisfactory solution in a couple of days time.

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Trouble registering ACTIVEX component (Access 2000)

    Would you care to post the solution? That might be useful to other Loungers. Thanks in advance.

  9. #9
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    314
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Trouble registering ACTIVEX component (Access 2000)

    I have made some progress with the Kodak Imaging ACTIVEX control that comes free with Windows (up to Win 2000 - not after).
    But I have not posted my 'successful' solution because it isn't very successful.
    It seems to be very difficult to set the resolution and JPEG compression in code to any decent level.
    If anyone has solved this let me know but I'm not hopeful as all the rare posts on the web don't seem to have solved it either.

  10. #10
    Star Lounger
    Join Date
    Dec 2001
    Location
    Houston
    Posts
    71
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Trouble registering ACTIVEX component (Access 2000)

    I too wish to create an Access VBA application that will invoke control of a scanner, so I can have my way with it. Did you ever complete the project to your satisfaction? Whether you did or not, can you guide me in the steps required? Apparently you achieved some measure of success, and even if you got stumped by some details, perhaps I can build upon it. I would really appreciate your assistance!

  11. #11
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Trouble registering ACTIVEX component (Access 2000)

    It might be better to post a reply to one of <!profile=DavidHit>DavidHit<!/profile>'s posts, since he is the one who started this thread. He may not see a reply to me.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •