URL and table fields

[Nick J]

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

[MGFoster]

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("Tracking", "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.FollowHyperlink strURL, , True

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQiUfCoechKqOuFEgEQIJlgCdEKiA809r6f/jU4Jg+DCBHYlAj5oAn2r4
yAOTD5ihIUIiGrMbVdycIJoC
=82JU
-----END PGP SIGNATURE-----

[Linda Burnside]

You could try this.

In your form, you must have text boxes named TRACKING and DATE. Build an
event that is triggered by clicking the button and insert the following
code:

On Error GoTo ErrorHandler

Dim Website As String

Website = "http://www.abc123.com/ID?" & Me.TRACKING & "?DATE=" & Me.DATE

Application.FollowHyperlink Website, , True

ErrorHandler:
MsgBox "Error: " & Err.Number & " " & Err.Description
Exit Sub

Linda
"Nick J" <bl*************@blueyonder.co.uk> wrote in message
news:bd******************@fe1.news.blueyonder.co.u k...

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

[Nick J]

Thanks!

--
Kind Regards
Blue Bell Trading

+++ WHEN REPLYING PLEASE DO NOT DELETE ANY OF THE TEXT AS WE NEED IT FOR
REFERENCE +++

Blue Bell Trading
"Nick J" <bl*************@blueyonder.co.uk> wrote in message
news:bd******************@fe1.news.blueyonder.co.u k...

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