D
Duane
I have a db with about 1100 prisoners in it. I created a field to store the
link to our website. The field is a hyperlink data type.
The website is done in asp. The base
http://www.state.mi.us/mdoc/asp/otis2profile.asp?mdocNumber=. I created an
update query as to concatenate the prisoners number to the base of the url
but it doesn't work. If I copy an url from the website and paste it into
the textbox on my form, it works fine.
UPDATE tblPrisonerInfo SET tblPrisonerInfo.Photo =
"http://www.state.mi.us/mdoc/asp/otis2profile.asp?mdocNumber=" & "" &
[txtNumber]
WHERE (((tblPrisonerInfo.txtNumber)=[txtNumber]));
Any help would be greatly apreciated. Thanks in advance.
link to our website. The field is a hyperlink data type.
The website is done in asp. The base
http://www.state.mi.us/mdoc/asp/otis2profile.asp?mdocNumber=. I created an
update query as to concatenate the prisoners number to the base of the url
but it doesn't work. If I copy an url from the website and paste it into
the textbox on my form, it works fine.
UPDATE tblPrisonerInfo SET tblPrisonerInfo.Photo =
"http://www.state.mi.us/mdoc/asp/otis2profile.asp?mdocNumber=" & "" &
[txtNumber]
WHERE (((tblPrisonerInfo.txtNumber)=[txtNumber]));
Any help would be greatly apreciated. Thanks in advance.