How use image save in data base or print with other filed

[VINOD_2553]

Hi i just want create a project to school i card
i do evry thing in my project but i have no idea to save photo of
student on icard
simply i want save image in data base or
access imege on form to print icard
please heme me
how can i do this
plese send me code with small project if posible

[debasisdas]

This is how you store and retrieve image from database.

[VINOD_2553]

Ok but in data base of ms acccess how can i saved it and also what is the type of field in ms-accesses

[debasisdas]

May be you can you MEMO field.

[AndreRet]

When you create the field that must hold the photo in Access, create it as 'Binary'. So, when you are saving the picture you will have something like -

rsPhoto!MyPhoto = Picture1.Picture

rsPhoto.Update

'When loading photo --->

Picture1.Picture = rsPhoto!MyPhoto

I hope this will help you out.

[vb5prgrmr]

Andre, I think you had better check the value of the picture property because If I remember correctly, it is just a handle to a memory location, so in short, you will be saving a long value to the database and not the bits of the picture...

Good Luck

[VINOD_2553]

Using the above code type mismatch erroe ocurre

[vb5prgrmr]

That is because the rs.fields("fieldname") = picture1.picture is only saving a long integer to the database that at one time pointed to a memory location where the picture itself was stored. Use debasisdas links above andreret's post or see these...

save http://www.vbforums.com/showthread.php?t=335207
retrieve http://www.vbforums.com/showthread.php?t=346752

and here is a post with a link to a zip that allows you to retrieve a picture from a database without having to go to disk...

http://www.vbforums.com/showpost.php?p=2975462&postcount=35

Good Luck

[santosh5471]

Dear Vinod
To Store the Image in the file use DRIVELISTBOX, DIRLISTBOX AND FILELISTBOX
NOW FIND THE IMAGE FILE. U R MAKING I-CARD PROGRAMME. SO VERY FIRSTLY YOU MUST HAVE SCANNED THE PHOTOS OF THE STUDENTS BY SCANNER OR WEB CAM. NOW AT THE TIME YOU ENTER DATA OF THE STUDENT NAME, GENDER, CLASS, DIVISION,ETC. SAVE THE
DRIVE & "\" & DIR & "\" & FILENAME ...MAY BE JPG OR BMP etc...
WHILE PRINTING IF YOU ARE USING CRYSTAL REPORT... YOU HAVE TO USE OLE OBJECT BY
INSERT --> OLE OBJECT --> BIT MAP AND CHECK .. I HAVE DONE IT ALREADY.. JUST TRY ... IF FAILED ... TRY ONCE MORE ...IF FAILED ... TRY ONCE MORE ... IF FAILED... REPLY ME ... MAI HOON NA .... I WILL SEND THE CODE

ALL THE BEST