473,320 Members | 1,863 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Display image on form via network path.....

Hi,

I have a form in which I need to display an image of our product.
On our server is a folder which contains all the images.
In our MySQL db to which our MS Access 2003 front end is linked, are
paths to the specific image folder for each product.

A variable carries over the required path of the image to the required
form as:

\\server\photos\productA\Image1.jpg

What do I need to use to display this image on our form.
I've tried using the bound & unbound forms, but nothing ever appears ?

Is it possible to display an image on a form, when it resides on our
network server ?

Appreciate your help
David

Nov 13 '05 #1
1 4281
da*********@scene-double.co.uk wrote in news:1124466646.664597.81670
@g49g2000cwa.googlegroups.com:
I have a form in which I need to display an image of our product.
On our server is a folder which contains all the images.
In our MySQL db to which our MS Access 2003 front end is linked, are
paths to the specific image folder for each product.

A variable carries over the required path of the image to the required
form as:

\\server\photos\productA\Image1.jpg


Your path variable: strImagePath

Add a picture control to the form: Name_of_control
Link any picture.

Your field that gets the focus when opening the form: Name_of_that_field

Code behind the "Got focus" event of that field:

Private Sub Name_of_that_field_GotFocus()
Dim strImagePath As String
On Error GoTo PictureNotAvailable
Me.Name_of_control.Picture = strImagePath
Exit Sub

PictureNotAvailable:
Me.Name_of_control.Picture = "path_to_picture_notfound"

End Sub
--

It is I, DeauDeau
(Free after monsieur Leclerc in 'Allo, 'allo)
Nov 13 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: dave | last post by:
Hello there, I am at my wit's end ! I have used the following script succesfully to upload an image to my web space. But what I really want to be able to do is to update an existing record in a...
3
by: Ken | last post by:
I have a database called autographs.mdb that is in the "XYZ" folder in the "database" folder. I have a form in the database that I want to display a photo of the celeb on. The photos are in a...
1
by: Dev | last post by:
Dear Friends, I am passing the image name, size (in bytes) and imgaeformat (like jpg or bmp or pdf) through the network. I want display the image into picturebox without saving image...
2
by: Paul Gorman | last post by:
I am using the control type = file to perform a file upload. When I click on the browse button to go select the image I want to upload it places in the text box a local path (C:\images\image.jpg...
5
by: Peter Lapic | last post by:
I have to create a image web service that when it receives an imageid parameter it will return a gif image from a file that has been stored on the server. The client will be an asp.net web page...
2
by: smorrison64 | last post by:
I have a form that is coded to open a File Dialog boc to pick a picture to display on that particular item on a subform. My form is not based on query, but rather two separate tables (one primary,...
1
by: amritranjan | last post by:
How to retrive image file from MS access database and display this in another JSPpage -------------------------------------------------------------------------------- This is my Jsp code for...
17
by: madasamonkey | last post by:
If someone could take pity and help me out with this before I drive myself completely nuts, then I would really appreciate it. Here's what I'm trying to do: I have an Access 2003 database...
2
by: Tim Streater | last post by:
The following test page is intended to allow the user to choose an image file, and then display it. It works as expected in Safari 3.1.1, FF 2.0.0.14 (Mac), and IE7 (XP). But, it fails in FF...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.