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

B

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.
 
R

Ralph

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

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

Similar Threads

OLE Object field... 1
"Package" error/label when embedding a BMP in OLE field 1
Save data from an ole field into a file 1
OLE Object Data Type Question 8
How do I insert into a OLE Odject Type field at runtime 2
use VB to store data in OLE field 2
Use VBA to create a graphic from a picture in a table 8
Picture from table OLE Object field to report 2

Top