DBPix objects generating property and method related error messages in Access database
I've got a client, who has an old Access 2003 database application that we are attempting to update to A2016 (32 bit) (latest version she has).
She has about 8 forms in the application which use the dbPix activeX control, but we are getting errors on properties and methods which are documented on the companies web page. I've checked the references and ensured that the ocx file has been added to the project.
I've replaced the dbPix control with an Access image control on one of the forms, which seems to work fine. I'm waiting for info from the client as to whether she wants to proceed with this change on all of the forms.
I have not dug into the code too deeply at this point, but as I understand it, one of the reasons for purchasing the software was to allow the users to connect a digital camera directly to their computer to capture and store the image.
1. Does anyone have any idea why the code behind these forms would be failing with "object doesn't support this property" and other property/method errors?
2. Has anybody used any other freeware that performs this same functionality?
She has about 8 forms in the application which use the dbPix activeX control, but we are getting errors on properties and methods which are documented on the companies web page. I've checked the references and ensured that the ocx file has been added to the project.
I've replaced the dbPix control with an Access image control on one of the forms, which seems to work fine. I'm waiting for info from the client as to whether she wants to proceed with this change on all of the forms.
I have not dug into the code too deeply at this point, but as I understand it, one of the reasons for purchasing the software was to allow the users to connect a digital camera directly to their computer to capture and store the image.
1. Does anyone have any idea why the code behind these forms would be failing with "object doesn't support this property" and other property/method errors?
2. Has anybody used any other freeware that performs this same functionality?
Otherwise we will need some info about the errors you get...
Dale,
Usual deal...check references, make sure the OLE lib is registered (can you bring it up in the object browser), and failing that, a /decompile.
On the references to, I would check any un-checked reference, compile and close, then re-open and un-check the reference. That will force a refresh of the references collection.
<< Has anybody used any other freeware that performs this same functionality>>
DB Pix had that part of the market cornered. But as you found out, the new image control and the ability to control how images are stored in a DB went a long way to negating their advantage.
Still, the lib has the edge in talking to cameras and performance of image operations. I'd keep it if you can.
Jim.
Usual deal...check references, make sure the OLE lib is registered (can you bring it up in the object browser), and failing that, a /decompile.
On the references to, I would check any un-checked reference, compile and close, then re-open and un-check the reference. That will force a refresh of the references collection.
<< Has anybody used any other freeware that performs this same functionality>>
DB Pix had that part of the market cornered. But as you found out, the new image control and the ability to control how images are stored in a DB went a long way to negating their advantage.
Still, the lib has the edge in talking to cameras and performance of image operations. I'd keep it if you can.
Jim.
BTW, Joe Anderson used that control a lot....might want to drop him a note.
Jim.
Jim.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
@John,
It wasn't just about displaying images, it was also about capturing images. I still plan on giving your article a closer look and playing with that concept.
Dale
It wasn't just about displaying images, it was also about capturing images. I still plan on giving your article a closer look and playing with that concept.
Dale
ASKER
Anders hit the nail on the head with the delete and add a new control.
I've been avoiding ActiveX controls for so long now that I had forgotten that I should be able to simply right click on the control and see an option in the shortcut menu to view the properties of the control. I could not see that option with the controls on the current form.
I then added a new control
renamed the old one
gave the new one the same name as the old one
Opened the form, and everything worked.
Thanks again, Smiley!
I've been avoiding ActiveX controls for so long now that I had forgotten that I should be able to simply right click on the control and see an option in the shortcut menu to view the properties of the control. I could not see that option with the controls on the current form.
I then added a new control
renamed the old one
gave the new one the same name as the old one
Opened the form, and everything worked.
Thanks again, Smiley!
Your welcome :)
This is a common problem with ActiveX and the most used solution..but without knowledge about the errors you where facing we were only guessing...at least for one of us : " the Force is strong in you young Luke Skywalker"...
https://www.experts-exchange.com/articles/33716/Defeating-the-device-independent-bitmap-dib-format.html