Link an image file using a button

[Guest]

I have a database of a part inventory. The parts have a part number, a batch
number, and the date received. All the parts have documentation that get
scanned and linked to a Bound Object frame for that record. I currently have
to right-click in the frame and choose 'Insert Object' to link the file.
I would like to create a command button that would go to a specified
location (the network folder where the images are stored), then I would
choose the file, and click 'OK' to link it. I currently have a button that
will just go to the folder.
Does anyone have any suggestions?


P.S.

The image files are named with the part number and the batch number in a
specific format. One step better would be to find the file based on the
information in the fields of the current record.

Any help will be greatly appreciated.


Scott 'Beeker' H.

 

[Guest]

Yes, Brother Beeker, you have an interesting situation. You packed a
lot of information in your newsgroup query. I'd attack the problem in VBA (I
can't think of any other way to do it) and would generate computer program
code to retrieve the image file name from a table or construct the name based
on the part and batch numbers as you indicated. Since you have a
predetermined format for file names, you can programatically construct the
file name from known data and then assign that file name to the properties of
whatever control you wish in your application.
This is a solvable problem. Tackle it one piece at a time and if you
have any specific questions regarding the approach, message back to this
newsgroup and someone will take a fresh look at it.