dbTalk Databases Forums  

Saving a picture into my database

comp.database.ms-access comp.database.ms-access


Discuss Saving a picture into my database in the comp.database.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
matx
 
Posts: n/a

Default Saving a picture into my database - 05-15-2004 , 01:19 PM






I am designing a stock control system for a college project.

I am making a item entry form so that a new item can be entered. once
the details have been entered, my client can choose a suitable picture
for it that is shown when choosing the product to buy later.

I have got some code which gets a picture and adds it to a picture box
on my form. but i want to save this to my database as text format.

how do i do this?


This is the code i used to assign the picture to a image box

Private Sub Command14_Click()

Image15.Picture = LaunchCD(Me)

End Sub


Thanks in advance

Reply With Quote
  #2  
Old   
GJT
 
Posts: n/a

Default Re: Saving a picture into my database - 05-18-2004 , 08:45 AM






You should really not store images in the database as this will cause
excessive database bloat.

What you should do is provide a link to the image stored in a separate
location.

You may want to check out the following article:

How to include a bound picture on form -
http://www.microsoft-accesssolutions...image_form.htm

Regards

www.microsoft-accesssolutions.co.uk

***********************************

matx3001 (AT) hotmail (DOT) com (matx) wrote in message news:<bc8d0f0d.0405151019.54592e75 (AT) posting (DOT) google.com>...
Quote:
I am designing a stock control system for a college project.

I am making a item entry form so that a new item can be entered. once
the details have been entered, my client can choose a suitable picture
for it that is shown when choosing the product to buy later.

I have got some code which gets a picture and adds it to a picture box
on my form. but i want to save this to my database as text format.

how do i do this?


This is the code i used to assign the picture to a image box

Private Sub Command14_Click()

Image15.Picture = LaunchCD(Me)

End Sub


Thanks in advance

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.