OHH said:
How can I update the HyperlinkAddress and Display of data in access-table
through Update-Queries.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
UPDATE table_name
SET hyperlink_column = "#
http://www.earthlink.net#"
WHERE <criteria>
The hyperlink address is just a string. The data type of the column
should be Hyperlink. The new URL should be delimited by quotes and the
# sign, as shown above.
I don't know whay you mean by "...and Display of data...through Update
Queries." UPDATE queries don't display data.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBSaaAQ4echKqOuFEgEQIosQCdG6LxEYAl2IddBJsnWqNCaYdJnx0AoPal
Wlj7cz8fj1aEyUvILU5DJgBO
=2OBc
-----END PGP SIGNATURE-----
