Image: Red X; Can I change the X to another image for the web sit

S

sandrocket

I am posting pictures using a DB link and it is working. But if I dont have
a picture the resutls shows the standard red x with no picture. Instead of
the X, I would like to replace it with "No Picture available". Can I do
this? Can it be changed for only this web site? Or web page?
 
J

John Malone

Sure 8)

Make an Image "Not Available"
put it in the images folder
(or where ever you have the others...)
Link to them in the database
(like you have the others)
The nice thing is the picture will have the same name for all of the entries
that don't have pictures.
So you can copy & paste it (the name) into one after the other in the DB.

HTH
--
John Malone
==============
|I am posting pictures using a DB link and it is working. But if I dont
have
| a picture the resutls shows the standard red x with no picture. Instead
of
| the X, I would like to replace it with "No Picture available". Can I do
| this? Can it be changed for only this web site? Or web page?
 
S

sandrocket

That would work John but I may have hundreds or thousands. And the manual
intervention would be difficult. Two ways I imagined are how to substitue my
new image for the red x or how to detect the error and insert my new image
but I dont know how to do either at this point. There may be other ways.
 
J

John Malone

That's Cool!!! Kathleen... Thanks!!!

I was thinking you would / could do a find null value in the field and
replace with the stock image name.
Even for thousands it wouldn't take but a few seconds.
But if subsequent entries are made omitting the image name you could still
have problems. (in the future)
Your way takes care of that..... Kool!!!
--
John Malone
==============
message | Here's something that may help:
|
http://groups.google.com/group/micr...63595fa6dc7c?q=image&rnum=48#5a6663595fa6dc7c
|
| --
|
| ~ Kathleen Anderson
| Microsoft MVP - FrontPage
| Spider Web Woman Designs
| web: http://www.spiderwebwoman.com/resources/
|
|
| | > That would work John but I may have hundreds or thousands. And the
manual
| > intervention would be difficult. Two ways I imagined are how to
substitue
| > my
| > new image for the red x or how to detect the error and insert my new
image
| > but I dont know how to do either at this point. There may be other
ways.
| >
| > "John Malone" wrote:
| >
| >> Sure 8)
| >>
| >> Make an Image "Not Available"
| >> put it in the images folder
| >> (or where ever you have the others...)
| >> Link to them in the database
| >> (like you have the others)
| >> The nice thing is the picture will have the same name for all of the
| >> entries
| >> that don't have pictures.
| >> So you can copy & paste it (the name) into one after the other in the
DB.
| >>
| >> HTH
| >> --
| >> John Malone
| >> ==============
| >> | >> |I am posting pictures using a DB link and it is working. But if I
dont
| >> have
| >> | a picture the resutls shows the standard red x with no picture.
| >> Instead
| >> of
| >> | the X, I would like to replace it with "No Picture available". Can I
| >> do
| >> | this? Can it be changed for only this web site? Or web page?
| >>
| >>
| >>
|
|
 
S

sandrocket

Kathleen, yes, that is what I was hoping for. These solutions should work. I
am using your suggested picture link in my DB and it points to the image in a
folder and that is working. Below I cut/pasted this new solution but I have
one question. How do I insert the select statement? SQL? I am using a
pre-defined DB query to get my record from the DB. Or is ths Javascript that
should go into my web page? If I pick on the picture in my page where the
red x is presented it looks like this:
<img border="0" src="PicLib/<%=FP_FieldLink(fp_rs,"Picture")%>">
Also, the image size. Where do I put that code?

And Kathleen, you are a wizzard ! -- Thank you. Paul


1/
Make a 1 pixel transparent dot call it shim.gif
add a custon query like this
select Field1, Field2, iif(isnull(YourImageField), 'shim.gif',
YourImageField) As YourImage From yourtable
this way youll either get the Image or the transparent dot if theres no
image
2/
You can set either just the hieght or just the width
<img height=100 src="image.gif">
or
<img width=100 src="image.gif">
They will display in proportion
 
K

Kathleen Anderson [MVP - FrontPage]

If your record source is a View (a query in your Access database), I don't
think you can do this. If you used the DBRW to generate your query, you can
edit the SQL by switching to Code view, make your changes in the SQL in the
gray colored code, and save your changes while you're still in Code view.
Or, you can rerun the wizard and modify the SQL in the Custom Query window.


--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top