Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Picture in .JPG shows only icon in Access97

Picture in .JPG shows only icon in Access97

Picture in .JPG shows only icon in Access97

Is it possible to view the a real picture in Access that is saved as .jpg (JPG file)?

I tried to insert an object in a OLE Type Field but it showed only the JPEG Icon not the real picture...("View as Icon" is not checked by the way).

I hope you can help me with this one...
I just want to get away of converting all the pictures into Bitmaps.

Thanks!! :)

RE: Picture in .JPG shows only icon in Access97

Here' what I did once
I created a form
Then put an "Image" control on it
then I used this code to load a .JPG into the image control.

Private Sub Form_Current()
    If Me![ID] <> 0 Then
        Me!Image14.Picture = "p:\ViewPhotos\Photos\" & Me![ID] & ".jpg"
        Label20.Caption = "File: " & " p:\ViewPhotos\Photos\" & Me![ID] & ".jpg"
    End If
End Sub
I put this code in the form's on current event


RE: Picture in .JPG shows only icon in Access97

Jofet ... Hey! DougP..... how ya doing pardner.....?

I created a small db for pictures just to see what happened and mine works fine

I got a table with one OLE field
a Form to see what's inside
and a report

in my form it gives me the option of converting the image... so....

I'm also wondering why do you need Access to do the conversions... are you going to be converting batches of files...?

If is just converting files into bitmaps once on a while you can just open the jpg do a copy and then paste it into your bitmap editing program.

If you have any problems you can use Powerpoint as a mediator between the two programs.

If you want send me an e-mail to dogtraining@yahoo.com to send you the small DB I created as an attachment so you can compare with what you have.

I know more about pictures than about Access, but DougP is the man.....yeahhh!...

Like I said.... hope this is of some help.....


Dumboy.! Ouch.! .my brain.....

It's hard to think with only one neuron......Ouch.....!....it hurts when I think......!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close