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

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

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

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" <new_2_va_2003@mail.com> wrote in message
news:9b4fb041.0310230437.59e367e6@posting.google.c om...[color=blue]
> 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[/color]

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

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

new_2_va_2003@mail.com (Ken) wrote in message news:<9b4fb041.0310230437.59e367e6@posting.google. com>...[color=blue]
> 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[/color]

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

> Thanks for replying. I put the following code in my imageframe code:[color=blue]
>
> 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.[/color]

Thanks to all responders; having trouble getting a reply thru Google!

Ken

"Jerry Boone" <jerry@gomaps.com.nospam> wrote in message news:<%idmb.842$Oh5.474@newssvr22.news.prodigy.com >...[color=blue]
> 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" <new_2_va_2003@mail.com> wrote in message
> news:9b4fb041.0310230437.59e367e6@posting.google.c om...[color=green]
> > 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[/color][/color]