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
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