Nick J wrote:
Hi,
I have 2 fields in a table named TRACKING and DATE.
How do I go about having a command button so that the 2 fields are put into
a url then launched in a web browser?
Basically it works like mail merge...for example
http://www.abc123.com/ID?<<TRACKING>> &DATE=<<DATE >>
Any help would be great...
Kind Regards
Blue Bell Trading
+++ WHEN REPLYING PLEASE DO NOT DELETE ANY OF THE TEXT AS WE NEED IT FOR
REFERENCE +++
Blue Bell Trading
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Have you tried FollowHyperlink ?
' Get the tracking & date values. u could also use a query
' but this is simpler to show.
strTracking = DLookup("Tracki ng", "table_name ", "<criteria> ")
strDate = DLookup("[Date]", "table_name ", "<criteria> ")
' use Replace() function to put in values
dim strURL as string
strURL = "http://www.abc123.com/ID?|1&DATE=|2"
strURL = Replace(strURL, "|1", strTracking)
strURL = Replace(strURL, "|2", strDate)
' Open in internet browser
Application.Fol lowHyperlink strURL, , True
--
MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQiUfCoechKq OuFEgEQIJlgCdEK iA809r6f/jU4Jg+DCBHYlAj5 oAn2r4
yAOTD5ihIUIiGrM bVdycIJoC
=82JU
-----END PGP SIGNATURE-----