Fields Containing Drawings

[chaddiesel]

I have a table of parts that I would like to add a field for drawings.
These drawings are image files that are on different tabs in an Excel
Workbook--1 image/drawing per worksheet/tab. Most of the Excel workbooks
have 2 tabs. I need to print these drawings in a report. I added an OLE
Object field to my table and selected the location of the file on the
network drive with the "link" option checked:


\sharedrive\Drawings\drawing1.*xls


That works fine on the report. It displays the Excel worksheet/drawing on
the report. However, I need to be able to select a specific worksheet/tab.


By changing the field to a hyperlink, I was able to get this link to work
for the appropriate tab:


\\sharedrive\Drawings\drawing1*.xls#WORKSHEET1!A1


However, when I look at this field on the report, it just displays the above
link without showing the Excel sheet.


My question is if there is a way to either set up the OLE Object field to
point to a worksheet/tab or automatically display whatever the hyperlink is
pointing to on the report.
Printing all the worksheets/tabs in the workbook would also work. You might
ask why I want to link to the Excel Sheets. My boss wants to be able to
just drop a new Excel sheet with the same name into a certain folder when a
drawing changes. This is the way we receive the drawings, so I need to do it
this way. Any help would be appreciated.


Thanks,


Chad

 

[neileg]

I understand the problem, but not the solution.

When you have an OLE linked object, Access and the OLE client application have a protocol on handling the data, Access can call the client and the client provides the object.

When you have a hyperlink, all that is stored is the address of the file. When you double click the link, the handling is between Windows and the application, the object appears on the screen but this is nothing to do with Access, all it has done is supply the file address.

If you highlight the drawing in Excel, and right click, you can drag the object into your field, so you can have images from different tabs in the workbook, but they become embedded, not linked, so that does'nt work for you, either.