populate an ole table field with pictures

B

B. Meincke

I hope this is the right venue for this question. Sorry and could you
redirect me, if not...

I have a database that tracks student information. My site head would like a
new field that would contain a photo of the student. He wants our guidance
people to be able to save the photos as jpgs to a serverside photos folder
(within the same folder as the database) using the student number as the file
name. He then wants the ole[?] field in the tblStudent to look up the
picture for each record from the photos folder and populate the table's
stPhoto field with it.

I have to admit, that I am at a loss as to how to write this...as a query,
as a macro... etc.

Thanks in advance for any advice or suggestions.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top