Embed image

[stuart_adair]

Hello all,

I'm just about to start a new project which will include the building of a new Access database at work to help manage the complaints processes. I've been asked if it would be possible for an image to be embedded into a form.
For example, a complaint is received and is scanned and stored in a file. When the user is entering the details of the complaint on the database they link the image with the form in some way so you click on an action button and the letter appears.

I'm not sure it can be done so thought I'd ask you clever lot.

Oh, and I'm sure I'll have lots more questions as things progress

Thanks

Stu

 

[Simon_MT]

I wouldn't embed an image.

If you create a file with the same reference as the Complaint then you can referentially access the image relating to that complain. No overhead in the database and the images only appear as and when required.

Simon

 

[vbaInet]

I wouldn't embed an image.

If you create a file with the same reference as the Complaint then you can referentially access the image relating to that complain. No overhead in the database and the images only appear as and when required.

Simon

Following on from what Simon MT said, you would create a folder that will store these images and ensure that the filename is using. Maybe a combination of the complaintID and short date. Just an idea

 

[stuart_adair]

Thanks for the replies. I could also add a hyperlink on the form to allow the user to navigate to where the letters are stored...

Again, just thinking outside the box if I was really clever I could transfer a unique record number from the complaint to a SQL script that searches for the matching file in the folder and opens it - Sounds like another one for you lot at a later stage

Stu