Hi everyone. I want to add photos and documents as attachments into my Dog's Profile (frmDogProfile) I acquired code from a guy whom I did my initial Access Training with but he doesn't offer any support. I struggled a few days to get this far and I have finally ended up with two issues.
1) I manage to attach a photo into 'MyPictureFrame' which is an image box and the filename is saved in the 'MyPicture' field, but the picture does not show.
2) The document part is managed through a sub form called 'frmDocument'. I can attach any jpg files and open them, with no problem. When I try to attach any other file types, eg pdf, word, excel, I get an error. The code provides for all those file types.
I am way too inexperienced to figure out where the problem lies and would highly appreciate help from one of the amazingly talented guys in this forum.
I'm also open to any advise or examples of code that would do similar to what I have.
I might just explain the path selection. The path starts off in the directory where the database is saved.
It then creates a path similar to this: c:\Databasefolder\Entity\13\Documents - 13 is the DogID. The photo selected from 'MyPictureFrame' is saved under the DogID folder and the documents under the Documents folder.
1) I manage to attach a photo into 'MyPictureFrame' which is an image box and the filename is saved in the 'MyPicture' field, but the picture does not show.
2) The document part is managed through a sub form called 'frmDocument'. I can attach any jpg files and open them, with no problem. When I try to attach any other file types, eg pdf, word, excel, I get an error. The code provides for all those file types.
I am way too inexperienced to figure out where the problem lies and would highly appreciate help from one of the amazingly talented guys in this forum.
I'm also open to any advise or examples of code that would do similar to what I have.
I might just explain the path selection. The path starts off in the directory where the database is saved.
It then creates a path similar to this: c:\Databasefolder\Entity\13\Documents - 13 is the DogID. The photo selected from 'MyPictureFrame' is saved under the DogID folder and the documents under the Documents folder.
Last edited: