JPG files in Access

  • Thread starter Thread starter Shulamit
  • Start date Start date
S

Shulamit

I set up a form in an Access 2000 data base that in each
record includes a picture in jpg form. Each picture is
approximately 230k in size, but after I added just 28
records, with pictures, the total size of the data base
was 186MB. Since I need to have a total of about 3000
records, it is obvious that I need to have some way of
shrinking the size the data base takes up. Any
suggestions as to what I should do.

With thanks,
Shulamit
 
Hi. Try using URLs in your database that will lead to the
network location of your JPEG files.
 
I tried adding a hyperlink to my form, but for some reason
I can't make a bound hyperlink so that each record
receives a different picture. Though I added the bound
hyperlink button to the toolbar, it is gray and
inoperable. Have any suggestions?

Thanks,
Shulamit
 
I downloaded the file and tried using it, but I haven't
been able to figure out how to link it to my data base
form so that each individual record points to an
individual picture and not the entire folder of pictures.

Thanks,
Shulamit
 
Shulamit said:
I downloaded the file and tried using it, but I haven't
been able to figure out how to link it to my data base
form so that each individual record points to an
individual picture and not the entire folder of pictures.

Thanks,
Shulamit
Click to expand...
 
Shulamit said:
I downloaded the file and tried using it, but I haven't
been able to figure out how to link it to my data base
form so that each individual record points to an
individual picture and not the entire folder of pictures.
Click to expand...

Actually its only a few lines of code that does it:

Dim strPath As String
strPath = "C:\Images\" & Me.txtFileName
Me.imgControlName.Picture = strPath

Where txtFileName is the name of the text box containing the filename and
imgControlName is the name of the image control.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top