Displaying a .jpeg as linked OLE in a Form

8 New Member

Having trouble displaying a jpeg in an Access 2003 form. Have read in Access Forms Dummy Book the an anomaly is present in Access 2003 that does not allow JPEG images to be displayed because Office 2003 does not include MIcrosoft Photo Editor. It says I need to convert the file to a BMP or DIB. Has anyone had this problem and is there anyway to work around it. Coverting my photos is just more work I would like to avoid.

Feb 20 '08 #1

Subscribe Reply

3279

missinglinq

3,532

Recognized Expert Specialist

You might have a look at this site:

http://www.ammara.com/articles/access-jpg.html

The DBPix program mentioned has a good reputation.

Welcome to TheScripts!

Linq ;0>

Feb 20 '08 #2

FishVal

2,653

Recognized Expert Specialist

Hello, Walter.

You may find a solution in The BLOB (not the movie!) article.

Regards,
Fish

Feb 20 '08 #3

sierra7

446

Recognized Expert Contributor

Hello again Walt

I see you are having problems displaying pictures. I've heard about this problem and read the Microsoft kb article about Access 2003

However my Access 2003 computer displays graphics OK for me and does not have Photo Editor (photoed.exe) anywhere on any-drive. If I double click an graphic file either BMP or JPG it's displayed in something called 'Windows Picture and Fax Viewer'

I can display picture ok using an Access Unbound Image Control. In the On_Current event of the form I load the image using ;-

Expand|Select|Wrap|Line Numbers

If Me!GPath <> "" Then Me!Image8.Picture = Me!GPath

where GPath is a textbox holding the path and filename of the graphic and Image8 is the name of the image control.

There may be an issue with a Graphics Loading Bar displaying momentarily when loading jpgs but a registry fix from this reference will stop it.

The disadvantage of using this method as everybody will tell you is that path to the graphic is stored in the database, so if the location is changed the picture can not be displayed. Surprise! But at least the graphics do not bloat the database.
S7

Feb 27 '08 #4

Similar topics

9562

CGI Proplem displaying image

by: matthiasjanes | last post by:

Hi, Maybe someone of you can help me. I'm trying to display an image in memory(open file) with an cgi script - but it want work proberly: I'm running an Cgi webserver (CgiServerGui.py). both files are in the /cgi/ folder

Python

4666

Images Not Displaying

by: Mark Sargent | last post by:

Hi All, response.write FilePath gives this path, ImageName.jpeg but the image(s) doesn't display in the below code. What am I missing..? Cheers. <%Response.Write FilePath%> Original Image:<BR> <IMG SRC="<%=Server.MapPath("ImageUploads\") & FilePath%>"><P> Thumbnail (50% reduction):<BR>

ASP / Active Server Pages

3213

Jpeg displaying as base64 string in browser

by: Magnus | last post by:

Hi, I'm programatically posting an image using multipart/form-data. It sends to the server OK, but when I try to view it in the browser, it is still in the base64 string I sent it as: /9j/4AAQSkZJRgABAQAAAQABAAD/2wBDAAUDBAQEAwUEBAQFBQUG etc.... I've been through the form I built over and over: string PostData = ""; PostData +=...

.NET Framework

2205

Linked images not displaying

by: Woodmon | last post by:

I'm observing issue with linked images not displaying in either Firefox 1.5b2 or IE6 when running on Win XP (they display fine in either browser on W2k). Example problem HTML is: <a href="largepict.html" title="Blah" alt="Blah" target="_new"> <img src="images/smallpict.jpg" /></a> For the image to display in either browser on XP I have...

HTML / CSS

11827

Export of form with 2 graphs As a JPEG

by: David Lauberts | last post by:

Hi Wonder if someone has some words of wisdom. I have a access 2002 form that contains 2 graph objects that overlay each other and would like to export them as a JPEG to use in a presentation. I can do this individually for each graph but this does not help me as I need both on the same JPEG. I thought I would try an export the form that...

Microsoft Access / VBA

3471

Strange Access 97 Behavior in Displaying Images

by: Dalan | last post by:

At first I was not certain what could cause Access 97 from displaying most jpeg images, but not all. After further testing, it seemed that all original images of less than 275 pixels per inch or less would display, but those close to 300 pixels/inch or greater would not (MS Access cannot recognize the file format xxx.jpg). The larger, original...

Microsoft Access / VBA

862

displaying Multi Content

by: Panther240 | last post by:

I am displaying a Pie Chart in a browser.I am coding using C# in ASP.net.I am using System.Drawing and System.Drawing.Imaging. I had selected Response.ContentType = 'Image/jpeg" I have other controls in the page like Text Controls which do not get displayed if I select Response.ContentType = 'Image/jpeg" I want to dispaly Text controls in a...

ASP.NET

2577

Problem displaying a database image on a web form

by: Jeronimo Bertran | last post by:

Hello, I am using a rendering aspx page to display a database image on an Image control. When the database record is retrieved, I am saving the bitmap to a session variable for the rendering aspx to load. Here is the code on the rendering page: CODE FOR ImageForm.aspx private void Page_Load(object sender, System.EventArgs e)

ASP.NET

3291

bound ole ctrl only displaying path

by: Jon Weston | last post by:

I'm setting up an Access2003 database with pictures. I put a bound ole picture ctrl on a form that's source is the table that contains the pictures and follow ALL the directions for embedding a picture. The ctrl in the form only displays the filename of the picture. The underlying table, when opened in table view, shows the word "package"...

Microsoft Access / VBA

7612

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...

Windows Server

7924

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...

C / C++

6284

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...

Career Advice

5219

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...

C# / C Sharp

3653

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...

Networking - Hardware / Configuration

3640

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2113

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1213

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

937

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

General