Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Inserting picture into database
- Thread starter zalmey
- Start date
HarleyQuinn
Programmer
Hi,
Don't know if this is exactly what you are after but it might be a help:
Cheers
Harleyquinn
Don't know if this is exactly what you are after but it might be a help:
Cheers
Harleyquinn
fredericofonseca
IS-IT--Management
the getchunk method mentioned on the link given is the way to go.
I am also pretty sure that this has already been discussed on tek-tips, so I suggest you do a search on forums/faq´s.
Regards
Frederico Fonseca
SysSoft Integrated Ltd
I am also pretty sure that this has already been discussed on tek-tips, so I suggest you do a search on forums/faq´s.
Regards
Frederico Fonseca
SysSoft Integrated Ltd
Hi Zalmey
It might be better to just save the path of the image to your database than to save the image itself as this could bloat your database.
I normally copy the image to a directory within my app path first then save the path and image name to the database.
![[bigcheeks]](/data/assets/smilies/bigcheeks.gif "[bigcheeks] [bigcheeks]")
It might be better to just save the path of the image to your database than to save the image itself as this could bloat your database.
I normally copy the image to a directory within my app path first then save the path and image name to the database.
Homersim2600
Technical User
DeltaTech,
Would you do that with a Hyperlink? If so, do you have any ideas on how to format a column in a database so that the hyperlink will activiate; especially when the database was created with VB, and not MSAccess? I do not have any access to MSAccess in order to format the column correctly. Thanks for any suggestions...
LF
Would you do that with a Hyperlink? If so, do you have any ideas on how to format a column in a database so that the hyperlink will activiate; especially when the database was created with VB, and not MSAccess? I do not have any access to MSAccess in order to format the column correctly. Thanks for any suggestions...
LF
Hi Zalmey
I am not clear as to what you are trying to achieve, but in my apps, the picture displays on a form, say employee form to display employee records. When an employee's record is selected, the field containing the details of the image is read, and the image (if any) is loaded in to the image/picture box control.
If you want to present a series of links for the user to click on and see the available images, you could read and load all available image details to a control (or controls) and trap the control's click event to display the image.
Finally, in Access 2000, you can select Hyperlink as a data type, although I have not used this yet, and perhaps someone who has may be able to help.
Good luck.
I am not clear as to what you are trying to achieve, but in my apps, the picture displays on a form, say employee form to display employee records. When an employee's record is selected, the field containing the details of the image is read, and the image (if any) is loaded in to the image/picture box control.
If you want to present a series of links for the user to click on and see the available images, you could read and load all available image details to a control (or controls) and trap the control's click event to display the image.
Finally, in Access 2000, you can select Hyperlink as a data type, although I have not used this yet, and perhaps someone who has may be able to help.
Good luck.
- Thread starter
- #7
Hi DeltaTech
I am going to develop a form in which when i click on the image control the scanner will go online and i am able to scan a picture which will then i get in that control box. I want to save the picture in the database for the future useage. If i save the picture and only save the path i am not able to get the picture in the crystal report. if u have any solution for the problem plz.........
i want to use the Vb+Crystal Report
Thanx all
I am going to develop a form in which when i click on the image control the scanner will go online and i am able to scan a picture which will then i get in that control box. I want to save the picture in the database for the future useage. If i save the picture and only save the path i am not able to get the picture in the crystal report. if u have any solution for the problem plz.........
i want to use the Vb+Crystal Report
Thanx all
- Status
Similar threads
