Sending a string to a web address

  • Thread starter Thread starter Gareth Edmondson
  • Start date Start date
G

Gareth Edmondson

Hi,

Not sure if the title makes sense, but I am writing a small example database
for my sixth form pupils.

I have in the table/form a field called 'Post Code' - an example being 'SA4
3DB'. I have inserted a command button which when pressed I want to be able
to fire up Internet Explorer (easy bit), access www.multimap.co.uk and then
find the post code.

So basically, reading the postcode from the Access field, and putting it
into a url like this one:

http://www.multimap.com/map/browse....=&advanced=&addr3=&pc=SA43DB&cidr_client=none

I know I could cheat by searching every postcode of every example person in
the database, but I would rather it worked on the fly.

I feel I am missing something simple. I thought of this idea...

What if I split the webaddress into several smaller strings and wrote
something like

searchweb = webstring1 + postcode field + webstring 2

So the example above would be

webstring1 =
"http://www.multimap.com/map/browse....r1=&client=public&addr2=&advanced=&addr3=&pc="
poscode field = "SA4 3DB" (read on the fly from the database)
webstring 2 = "&cidr_client=none"

How easy would this be to do? Can anyone point me to an example?

Many thanks for your time,

Gareth Edmondson
 
Go to the VB Editor Help. Search for hyperlink. Look at the example for
Hyperlink Property. I was able to do this by creating invisible textboxes on
the form named strAddress and strSubAddress and assigning the ?query data to
those textboxes.

Jim Evans
 
There is probably an easier way to get post codes. I am not in the UK but I
have seen messages saying it is possible to get a list of post codes from
the postal service.
 
Back
Top