Access VBA Run Time Error 2465: Application-defined or object-defined error
I have a form named UI(Navigation Form) in MS Access 2010. I have two more subforms SEARCH and RESULTS as tabbed forms in UI. After I search in SEARCH form, when I click the RESULTS tab I want the value from a combo box named 'cmbID' in SEARCH to be displayed in a label named 'lblAIPIDDisp' in RESULTS form and then display additional labels. So, I gave the following code in the navigation Button Click Event:
@zmbd: I am using Access 2010 only. This application is going to be run in different systems. So,I stored the image itself as an OLE Object in the database. It would be difficult for the images to be stored in the same location in every system. So,I didn't store the link to the image in the db.
Is there any way to display the image like I am trying to do? Should I convert the binary stream to an image?
VBA Access: Run-time Error '2176'-The setting for this property is too long
There is an access database table called DemoImageT with a field called Image to store images (using OLE Objects). It has another field called ID which is a text field. It has values 1,2,3..etc. I have an Image holder called ImageBox1 in an Access form. When a button is clicked I want to display the image stored in the table in the image holder on the form. I executed a query and stored the results in a recordset. Then I set the picture property...
Leave a comment: