Image Options

[loopy4eva]

Ok,

I've mostly taught myself Access over the past 5-6 years, and gotten not too bad at it, I usually use other peoples databases and Google to solve what i cannot do myself, so i decided to try a forum to put some of the harder questions out there.

I am making a system for a small library in our town, they want to take a photo of every item and have it appear when they look it up in the computer. not too much hassle I thought, WRONG...
i was going to simply embed the image in the database, until i found out there was over 5K books (not a small library now, are we...) so i found a code that loaded the image of a book that was located in a specified file, and as long as the image name was the same name as the book code (my primary key/reference number) it would find it and load, not too bad but its a little dodgey, as in if a book number image appears to not be in the file, it keeps the image of the previous book. so that option is pushed to the back.

i the found the employees section in the sample northwind database, liked the way it was structured, it felt more solid than the last option, my problem is (as i'm not too confidant with my VB coding yet) i cannot make it work in my database it keeps highlighting some random script that i cannot understand too much.

so my question to you is what other options of image storage/reference is there? keep in mind that the ladies who will be using the system is not too computer savvy so as basic as possible. or perhaps one of you can tell me why my north wind stuff isn't working to well

thanks anyway, and sorry for the long-winded question.

 

[MStCyr]

Hello

For this particular application, you would be better to link to the image instead of storing it, as this would increase the database bloat. An example of how this is done can be found at:

http://www.access-programmers.co.uk/forums/showthread.php?t=108698

Best regards

Maurice

 

[loopy4eva]

Thanks, But how would i adapt that so it works in reports as well?

 

[Davros]

hi
i had the same problem. what I did was create a Query By Form. the output was a form based on this query which the report was based on. alternatively just base the report on the query by form [QBF]. one thing you should remember. if your image is 250kb or above you will have problems printing 30+ records at the same time. AND always link your images as this saves on database bloat.
try this thread

http://www.access-programmers.co.uk/forums/showthread.php?t=112910.

sorry i'm not that good at explaining things. if your still desperate i'll see if i can strip my database down and send it to you

 

[MStCyr]

Thanks, But how would i adapt that so it works in reports as well?

Hello

It should work exactly the same way, but then I haven't tried this in a report.

Maurice

 

[Simon_MT]

I handle images by dbpix but I believe the principles should be the same:

Before you do anything else, the "GetImage" process make the image control invisible.
Only set this control to visible if the image is found, you remove reiterations.

Forms: I put the "GetImage" function OnCurrent.
Reports: I create a Sub Report on the Parent Detail. The Sub Report basically has the Image Control and Image File Name. Function on the Sub Report Detail OnPrint is GetImage.

Simon