Hyperlinks

[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.

 

[storrboy]

How does it fail?
At first glance it looks like there is an extra set of quotes before
[txtNumber]. Also, if you are changing every row in the table, then I
think the Where clause may not be required.

UPDATE tblPrisonerInfo SET tblPrisonerInfo.Photo = "http://
www.state.mi.us/mdoc/asp/otis2profile.asp?mdocNumber=" &
tblPrisonerInfo.txtNumber;

 

[i_takeuti]

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.