Fumpuzzled????

[KeithB13]

Fumbuzled????
Hello all and please help,

I really don't know how to explain this, so here it goes.

I have a database set up that I would like to have excel spreadsheets displayed onto a form in access. The spread sheets contain pictures of engines. I have multiple exel files that contain anywhere from 1 to 15 pictures (i think this is irrelevant) in the same folder.

The file names of the spread sheets match my "Engine_Number" feild in one of my tables.

Each record has multiple fieds. When my engine information is dispayed, ony one engine at a time is displayed on a form.

How can I display an Excel Spreadsheet through a form or subform?

and

How do I change spreadsheets when a different record is displayed?

Thanks for the help,
Keith

 

[neileg]

I don't understand why you are holding pictures in an Excel file. Why not save the picture in a native picture format like a GIF or JPEG? Then you can hold the filename of the image as a field in your database.

Don't hold the images in Access as you will end up with a huge file. There have been plenty of postings in here to do with referencing external images.

 

[KeithB13]

I am holding the pictures in an excel files because I have serveal pictures per unit. Example...

We evaluate engines and transaxles. Depending on the case we may have 2 pictures of an engine or 25 pictures of an engine. I have found it easier to put 25 pictures in to a document than to have 25 different .jpegs. I give the excel file the same name as my engine serial number. The pictures are easier to veiw and can be printed with ease.

Is there a way I can use a macro or cmd button to open the correlating excel file from a form?

I also have one other problem. The company I work for is a little behind the times. I am running office 97 with windows NT and little else. I had to fight to get my help files updated.

Thanks for the help,
Keith

 

[neileg]

You've made one thing easier and the next thing harder!

I would have a table in the databse that holds the name of each image and links this to the ID of the engine/transaxle. But there you go.

If you insist on using your Excel files, use a hyperlink in your database record. Use Access help, or search on here for more info