By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,455 Members | 2,293 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,455 IT Pros & Developers. It's quick & easy.

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

P: n/a
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\graphics\photo.jpg). 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\photo.jpg" in the table but
then it won't display in the form.

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

Ken
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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.google.c om...
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\graphics\photo.jpg). 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\photo.jpg" in the table but
then it won't display in the form.

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

Ken

Nov 12 '05 #2

P: n/a
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***********@mail.com (Ken) wrote in message news:<9b**************************@posting.google. 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\graphics\photo.jpg). 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\photo.jpg" in the table but
then it won't display in the form.

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

Ken

Nov 12 '05 #3

P: n/a
Ken
> Thanks for replying. I put the following code in my imageframe code:

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

Private Sub ImagePath_AfterUpdate()
On Error Resume Next
MyPath = "E:\Programs\CFusionMX\wwwroot\Starsigners\h5zrig1 u\"
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.com.nospam> wrote in message news:<%i***************@newssvr22.news.prodigy.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.google.c om...
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\graphics\photo.jpg). 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\photo.jpg" in the table but
then it won't display in the form.

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

Ken

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.