Images not showing up

[scottgzero]

Hi there,

I have a "minor" problem which most of you will probably have a laugh about


I have set up my Table / Form to have an image for each "item".

Now...when I add the image, it does not show up as the thumbnail JPG. It only appears as the image name.

So instead of seeing a picture, I see 1.jopg (example)

Can anyone help me with a correct hint?

Much appreciated

Chris

 

[maxmangion]

search this forum for images / pictures ... there are several threads covering this issue. Note that ideally, you should not embed your images in the database, but link to them.

 

[scottgzero]

search this forum for images / pictures ... there are several threads covering this issue. Note that ideally, you should not embed your images in the database, but link to them.

Hi there,

thanks for your reply.

I have been searching for a bit, but cannot find help on this specific problem.

My images are "linked", not embedded....and that's what's frustrating me.

I only see image names.....no graphics

Hope someone can help.

Regards
Chris

 

[Sergeant]

Are you using an "Unbound Object Frame"? With this control, I have found that if you link to a .jpg, you just get the name of the imagefile. If you link it to a .bmp, you get the picture.
(I'm using A2K3, WinXPPro)
Sarge.

 

[The_Doc_Man]

Search for my name and topic Picture (or Image) - I've answered this topic in greater detail many times.

1. My approach involves an Image control that is unbound. I play with the properties so that Access NEVER tries to embed any image. I also play with Zoom, Tile, and whatever property it is that maintains aspect ratio so that when it displays, you don't muck the image.

2. Using Form_Current events, I load a new filename (which is in my database) to the .PICTURE property of the unbound control. I don't link or hyperlink or OLE to anything. This is enough to get the job done.

3. If Access won't "translate" the image you gave it, a few possible cases come to mind. Not necessarily shown in order of probability here.

3.a. During Access or Office install, you took the "DEFAULT" install option and therefore didn't get all of the possible image handlers. Go back, reinstall Office. One of the options allows you to selectively install new features that you had not previously selected. Install all of the image handler .DLL files (libraries and "wizards") that it offers to you.

3.b. Your source of that particular image format is flawed. I.e. your .JPG file is not really a JPEG 'cause it is broke. Fix your JPEG originator. Or the problem is the way you transferred the files to this computer and they are corrupted. Anyway, something is wrong with the files.

3.c. Oddball case: Double-click MyComputer to open the "highest" real window on your system. The one that includes your drives & partitions like C:, D:, etc.

From there: Take menu-bar path View >> Options. On the resulting dialog box, select the "File Types" Tab-control. Scroll the file descriptions until you find references to the appropriate image type. E.g. JPEG Image. Now click once on that image type so it is selected. (Don't double-click.) In the bottom part of the box, beneath the scroll box, you'll see three lines:

Extension: will tell you how Windows recognizes the file types
Content Type: shows you how Windows describes this file type
Opens with: Names the program (and shows the icon) for the program associated with this particular file type.

For the file types that don't display right, the file type giving you trouble will have no defined "Opens with" entry. Or it has no entry that you can find in the scroll. For known file types, you can click "Edit" to select a processor if you know one. For graphic images, IEXPLORE is a common choice but far from the only possible choice. You can also add a file type outright.

So instead of seeing a picture, I see 1.jopg

I don't know whether .JPOG is a real file type or just a typo on your part. But if that is the real file type, I know that MY registry doesn't recognize it. I doubt yours would, either. If you really meant .JPEG and it was a fat-finger, that should be OK. If you honestly meant .JPOG then my problem 3.c could be your bug-a-boo.

 

[scottgzero]

Images....

Hi there,

thanks for your reply.

I did indeed make a mistake with JPOG.......I was typing faster than I could think.


I managed to get the images showing. It was an installation that was not done on the initial installation.


I still have a minor problem......if you could help me on this ine, would be much appreciated.


I have a field "OLE Object".

Great!

BUT!! .......I want to be able to LINK my products to pictures from a file.

IE:
Product 1 = AB1.jpg
Product 2 : AB2.jpg

Both images are in C:/images


How can I do this ?

In the datas listing, it say Binary File........not the image name.

Any idea?

Thanks in advance.

Chris