W
Wladdy
Table A has an OLE field called [Image] that needs to be populated
with images found in folder C:\Images.
Each image has a unique path.
Query Q is a select query based only on Table A. Using concatenation,
Q creates a text field called [Image_Path], associating for each
record in A the full path and name of the corresponding jpg file in C:
\Images.
Is there a way to automatically link each [Image_Path] in Q (text)
with the corresponding [Image] in A (OLE)?
Has someone posted some VBA code on how to accomplish a similar task?
Can it be done without VBA?
I use Access 2007.
Many thanks,
W.
with images found in folder C:\Images.
Each image has a unique path.
Query Q is a select query based only on Table A. Using concatenation,
Q creates a text field called [Image_Path], associating for each
record in A the full path and name of the corresponding jpg file in C:
\Images.
Is there a way to automatically link each [Image_Path] in Q (text)
with the corresponding [Image] in A (OLE)?
Has someone posted some VBA code on how to accomplish a similar task?
Can it be done without VBA?
I use Access 2007.
Many thanks,
W.