D
Duane
What I am trying to do is, through the use of a form and the base url of the
company website concatenate the prisoners number [PNumber] field and the
base URL of the website.
The base URL is as follows -
http://www.state.mi.us/mdoc/asp/otis2profile.asp?mdocNumber=
The prisoner information is entered into the database via a text file and a
macro using the transfertext method. Unfortunately, the website link is not
available in the text file.
I have tried two different approaches and neither seem to work.
In my table I have the following fields, [PrisonerURL] & [PNumber]. One
scenario, I set the default value of the PrisonerURL field to the base URL
and using VBA I concatenated the PNumber to it. In the other scenario I
used the base URL in a text string and I didn't have a default value in the
PrisonerURL field.
Both scenarios showed the correct string in the field, but the neither one
worked when I clicked on the link. If I copy the URL and paste it into my
browser it works fine.
Any help would be greatly appreciated.
Thanks
company website concatenate the prisoners number [PNumber] field and the
base URL of the website.
The base URL is as follows -
http://www.state.mi.us/mdoc/asp/otis2profile.asp?mdocNumber=
The prisoner information is entered into the database via a text file and a
macro using the transfertext method. Unfortunately, the website link is not
available in the text file.
I have tried two different approaches and neither seem to work.
In my table I have the following fields, [PrisonerURL] & [PNumber]. One
scenario, I set the default value of the PrisonerURL field to the base URL
and using VBA I concatenated the PNumber to it. In the other scenario I
used the base URL in a text string and I didn't have a default value in the
PrisonerURL field.
Both scenarios showed the correct string in the field, but the neither one
worked when I clicked on the link. If I copy the URL and paste it into my
browser it works fine.
Any help would be greatly appreciated.
Thanks