This should be possible,cause I really need this!

  • Thread starter Thread starter Earl.AKA J.Alladien in access forum!!
  • Start date Start date
Hi Karl,

I get following message:
"The expression you entered contains invalid symtax"
And "http" gets highlighted in the query!


KARL DEWEY said:
Try this --
New_Kode: "<img src="http://www.jea.sr/FOTO/" & [KODE] & ".jpg"/>"

--
Build a little, test a little.


Earl.AKA J.Alladien in access forum!! said:
Hello guys,

I have a TEXT field named "KODE" and I want it format it as follwos:

1012 to <img src="http://www.jea.sr/FOTO/1012.jpg"/>
1013 to <img src="http://www.jea.sr/FOTO/1013.jpg"/>

I've been trying but with no success!
Thanks in advance for the help!
Click to expand...
Click to expand...
 
Missed doubling up on the internal quotes

New_Kode: "<img src=""http://www.jea.sr/FOTO/" & [KODE] & ".jpg""/>"

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
Slight typo, I think.

Try

New_Kode: "<img src=""http://www.jea.sr/FOTO/" & [KODE] & ".jpg""/>"

(i.e. two double quotes in a row before the http and after the .jpg instead
of just one)


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


"Earl.AKA J.Alladien in access forum!!"
Hi Karl,

I get following message:
"The expression you entered contains invalid symtax"
And "http" gets highlighted in the query!


KARL DEWEY said:
Try this --
New_Kode: "<img src="http://www.jea.sr/FOTO/" & [KODE] & ".jpg"/>"

--
Build a little, test a little.


Earl.AKA J.Alladien in access forum!! said:
Hello guys,

I have a TEXT field named "KODE" and I want it format it as follwos:

1012 to <img src="http://www.jea.sr/FOTO/1012.jpg"/>
1013 to <img src="http://www.jea.sr/FOTO/1013.jpg"/>

I've been trying but with no success!
Thanks in advance for the help!
Click to expand...
Click to expand...
Click to expand...
 
Hi Doug,

That did it, thanks!!!

Earl.AKA J.Alladien in access forum!! said:
Hi Karl,

I get following message:
"The expression you entered contains invalid symtax"
And "http" gets highlighted in the query!


KARL DEWEY said:
Try this --
New_Kode: "<img src="http://www.jea.sr/FOTO/" & [KODE] & ".jpg"/>"

--
Build a little, test a little.


Earl.AKA J.Alladien in access forum!! said:
Hello guys,

I have a TEXT field named "KODE" and I want it format it as follwos:

1012 to <img src="http://www.jea.sr/FOTO/1012.jpg"/>
1013 to <img src="http://www.jea.sr/FOTO/1013.jpg"/>

I've been trying but with no success!
Thanks in advance for the help!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top