My Kingdom!! My Kingdom for a solution to this image link problem!!
Friends,
Is there no way to display linked images using an unbound OLE field INSTEAD of an IMAGE field?? I have a main form with linked images shown as thumbnails on a subform. I need to use an OLE field as a picture display as opposed to an Image field, because I want to be able to click on the thumbnails to view the enlarged image and print them. Beyond that, the field needs to accomodate possible PowerPoint presenations as well. I have searched the MS Knowledge base and found one example that supposedly addresses this, but flat out does not work (Q148463). That article was specific to Access 2 , so that may be the problem. For some reason Access won't link a file path to the OLE field.
This is how I have things set up:
I have a command button that allows the user to search for an image on the server and automatically place the images path into a field [ImagePath]. There is some code on the AfterUpdate event of the [ImagePath] text box and Form OnCurrent events which sets the OLETypeAllowed property of the unbound OLE field [Logo] to 1 (Linked), the SourceDoc value to the field [ImagePath] and the Action property to 0 (createLink). This stratey is detailed in Q148463.
This seems like it should work, but it does not. The [ImagePath] text field for the records get updated, but it does not update the OLE field. I have been able to make it work using an Image field instead of OLE using the "picture" property, but again the Image field is inadequate for the functionality that I need.
This doesn't seem like like it should be that complicated of a problem, but I have yet to find the solution. I am certain that this is a fairly normal requirement and that there must be all manner of users out there who regularly utilize this in their own databases.
Any and all help with this, be it an alternate approach or whatever would be greatly appreciated. Thanks
Friends,
Is there no way to display linked images using an unbound OLE field INSTEAD of an IMAGE field?? I have a main form with linked images shown as thumbnails on a subform. I need to use an OLE field as a picture display as opposed to an Image field, because I want to be able to click on the thumbnails to view the enlarged image and print them. Beyond that, the field needs to accomodate possible PowerPoint presenations as well. I have searched the MS Knowledge base and found one example that supposedly addresses this, but flat out does not work (Q148463). That article was specific to Access 2 , so that may be the problem. For some reason Access won't link a file path to the OLE field.
This is how I have things set up:
I have a command button that allows the user to search for an image on the server and automatically place the images path into a field [ImagePath]. There is some code on the AfterUpdate event of the [ImagePath] text box and Form OnCurrent events which sets the OLETypeAllowed property of the unbound OLE field [Logo] to 1 (Linked), the SourceDoc value to the field [ImagePath] and the Action property to 0 (createLink). This stratey is detailed in Q148463.
This seems like it should work, but it does not. The [ImagePath] text field for the records get updated, but it does not update the OLE field. I have been able to make it work using an Image field instead of OLE using the "picture" property, but again the Image field is inadequate for the functionality that I need.
This doesn't seem like like it should be that complicated of a problem, but I have yet to find the solution. I am certain that this is a fairly normal requirement and that there must be all manner of users out there who regularly utilize this in their own databases.
Any and all help with this, be it an alternate approach or whatever would be greatly appreciated. Thanks
