automating updates to an ole field from the contents of a Win fold

[B. Meincke]

Our single-table database tracks student information. The table data updates
and appends via a macro (transfer text and a series of queries.) Pretty
simple so far...

My site head is asking for a new field that would contain a photo of each
student. He wants our guidance people to be able to save photos as jpgs to a
shared folder (a subfolder in the same path as the database) using the
subject student's ID number as the image filename (7-digit integer.) He then
wants the new stPhoto [ole?] field in the tblStudent to automatically
populate by looking up and linking to the image file with the matching stID.

I have to admit, I have no idea how to start to write this...or even it is
possible.

Thanks in advance for any advice or suggestions.

 

[Ralph]

Take a look at the Employee table and form in the Northwind database. You can
download it from Microsoft.