Image path in Access 2000 database; want to display photo in form and on web

Ken

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 "graphics" folder
that is on the same level as the "xyz" folder. The only way I can seem
to make it work is to put the entire path including hard drive in the
table (c:\database\gr aphics\photo.jp g). But I also want to upload the
database to the web and so the local PC info will not be recognized.
So I'm sure I only need to have "\graphics\phot o.jpg" in the table but
then it won't display in the form.

Seems like "\graphics\phot o.jpg" would display the photo in the form
but it does not.

Ken

Nov 12 '05 #1

Subscribe Reply

5919

Jerry Boone

Going to take some coding...

For the web side, look into using ASP (vbscript enabled web pages),
connecting to the database using ADO (activex data objects), and working
with Server.Mappath for getting the folder the images are stored in. A good
ASP book goes a long way here. It's possible this may all be more than you
want to do with the learning curve involved.

Good luck!

:)
"Ken" <ne***********@ mail.com> wrote in message
news:9b******** *************** ***@posting.goo gle.com...

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 "graphics" folder
that is on the same level as the "xyz" folder. The only way I can seem
to make it work is to put the entire path including hard drive in the
table (c:\database\gr aphics\photo.jp g). But I also want to upload the
database to the web and so the local PC info will not be recognized.
So I'm sure I only need to have "\graphics\phot o.jpg" in the table but
then it won't display in the form.

Seems like "\graphics\phot o.jpg" would display the photo in the form
but it does not.

Ken

Nov 12 '05 #2

MeadeR

since you'll be using a web server for the images - why not have both
the web code and access code reference the URL....

ne***********@m ail.com (Ken) wrote in message news:<9b******* *************** ****@posting.go ogle.com>...

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 "graphics" folder
that is on the same level as the "xyz" folder. The only way I can seem
to make it work is to put the entire path including hard drive in the
table (c:\database\gr aphics\photo.jp g). But I also want to upload the
database to the web and so the local PC info will not be recognized.
So I'm sure I only need to have "\graphics\phot o.jpg" in the table but
then it won't display in the form.

Seems like "\graphics\phot o.jpg" would display the photo in the form
but it does not.

Ken

Nov 12 '05 #3

Ken

> Thanks for replying. I put the following code in my imageframe code:

Private Sub Form_Current()
On Error Resume Next
MyPath = "E:\Programs\CF usionMX\wwwroot \Starsigners\h5 zrig1u\"
Me![ImageFrame].Picture = MyPath & Me![ImagePath]
End Sub

Private Sub ImagePath_After Update()
On Error Resume Next
MyPath = "E:\Programs\CF usionMX\wwwroot \Starsigners\h5 zrig1u\"
Me![ImageFrame].Picture = MyPath & Me![ImagePath]
End Sub

That let me keep just the file name in the text field. Do you see
anyhting wrong with the code? I am uploading the database to a web
page and that seems to work locally.

I am linking the files; the ImageFrame field is the image control.
Thanks to all responders; having trouble getting a reply thru Google!

Ken

"Jerry Boone" <je***@gomaps.c om.nospam> wrote in message news:<%i******* ********@newssv r22.news.prodig y.com>... Going to take some coding...

For the web side, look into using ASP (vbscript enabled web pages),
connecting to the database using ADO (activex data objects), and working
with Server.Mappath for getting the folder the images are stored in. A good
ASP book goes a long way here. It's possible this may all be more than you
want to do with the learning curve involved.

Good luck!

:)
"Ken" <ne***********@ mail.com> wrote in message
news:9b******** *************** ***@posting.goo gle.com...
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 "graphics" folder
that is on the same level as the "xyz" folder. The only way I can seem
to make it work is to put the entire path including hard drive in the
table (c:\database\gr aphics\photo.jp g). But I also want to upload the
database to the web and so the local PC info will not be recognized.
So I'm sure I only need to have "\graphics\phot o.jpg" in the table but
then it won't display in the form.

Seems like "\graphics\phot o.jpg" would display the photo in the form
but it does not.

Ken

Nov 12 '05 #4

Similar topics

1966

Error " Invalid Parameter Used" when I try to display an image

by: Wally | last post by:

I am trying to display images from an Access 2000 database and I get an error "Invalid Parameter Used" when I execute the code line "picBLOB.Image = Image.FromStream(stmBLOBData)" in my Visual Basic .Net application. I have researched MSDN for help and found the example article 321900 (see below) and set up a test and everything works fine when I use SQL Server 2000 but when I modify the code and use data from Access 2000 using an...

.NET Framework

4734

ASP image from SQL Server

by: MVM | last post by:

I am using SQL server and ASP to create a webpage and display images directly from the database. My code is working fine, the issue I am having is when a photo is not in the database. For example, we have a table of homes and a table of photos. Not every home has a photo. So when I search the photo table for a photo that does not exist I want to display a "No Image Found" gif. Below is my code. homedetail.asp: <img...

ASP / Active Server Pages

6404

Image database

by: Artco News | last post by:

I was wondering if any one of you have some tips on how to display my images when I browse each record in a form. I have the following data structure on my access database: ImgID: text ImageDir: text Description: memo Note: memo

Microsoft Access / VBA

1593

Image not longer shows up in database record-windows reinstall

by: ken | last post by:

I had to reinstall Windows 2000 Pro and of course Access 2000. I HAD each record displaying a photo but now it does not show them. The WEIRD thing is that when I upload the database to my website...the image shows up! Is there a setting in Access that I need to chnage because of the reinstall? Thanks. Ken

Microsoft Access / VBA

10112

Access not showing image on the form just the filename

by: needin4mation | last post by:

Hi, I have an Access 2002 - 2003 database. I am using Access 2003. Whenever I link an image all it shows is the filename. Not the image. Other versions of Access can link the image just fine. The properties look the same whether I use XP or 2003 versions of Office. If I take an earlier version of Access and link the image, it puts the image. I can also see the image in 2003. If I link the image using 2003 it only shows the filename....

Microsoft Access / VBA

10416

Relative path & image

by: Ruymán | last post by:

Hello!, is possible use relative path in access? for example use "photo\image1.jpg" instead of "c:\db\photo\image1.jpg", I try it but I cann't, but in Visual Basic if is possible. Other question but relationated, Is posible don´t put a path to the picture in the image control (in desing) ? The Database will be move frecuntly and it will give error in the form load

Microsoft Access / VBA

1938

Image linking for Report

by: Parasyke | last post by:

I have a report that I want to print for a product specification sheet with a photo of the product. I have the photos stored in a separate folder from my Access 2000 database. I have a form that when I choose a product all the info for that product appears on the form appropriately, including the image path (e.g. C:\ABCcompany\Prods\Item894654.jpg). The form's data appears appropriately on the report for that item. How can I place an image...

Microsoft Access / VBA

2986

How to retrive image file from MS access database and display this in another JSPpage

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 image upload in database: -----------Upload.jsp---------------- <html> <head> <title>Account Details </title>

Java

2134

Uploading image in ASP

by: Parul Bagadia | last post by:

Hello, I am making a project in ASP where am embedding VBscript in it.. Its about sth like a social networking site.. Am making it in Microsoft Expression Studio. Here i want to provide user with an option by which he can upload and view his image. my database is Oracle, what am doing is am providing user with an option of browsing; that comes automatically in Express studio.; with input box of type File,.. where you have a button written...

ASP / Active Server Pages

9314

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. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

9174

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

9074

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

7953

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 launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6634

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

4725

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

3158

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

2520

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

2110

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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General