Adding an image to a form (dynamically)

[michaeljohannes]

Hello!

I have never done this before but don't think it would be too hard to set up.

I am working for a construction company at the moment and would like to have a type of image gallery function for the client info form (I called it frmClientInfo).

Basically, when a supervisor takes a picture of the site the user (our secretary) would cross-reference the record and name the picture as the primary key (ID_Autonumber).

For example: Jon Doe has an ID of 100. When Supervisor takes a picture, Secretary uploads the picture, saves it to a specific folder called Images and calls the file "100.jpg".

Then, the form frmClientInfo has a little section where the user can then see Jon Doe's picture called 100.jpg. And! If the picture doesn't exist (because at first the thousands of records will NOT have a picture associated with it) the default picture that shows has some message saying "No picture exists for this client".

I don't think this would be too complicated. I'm just wondering (based on your expertise) if the conceptual idea is a good one?

I always appreciate your expert opinions and suggestions!

Many thanks,
Mike

 

[RuralGuy]

MVP Larry Linson has three methods to get the results you asked for.

 

[michaeljohannes]

wicked! thanks a ton RuralGuy... So helpful...