Passing values in a hyperlink

[Gordon Hudson]

Hello

Here is what I am trying to do:

Make a hyperlink on a data entry form with its URL built from the values for
fields in that entry on the database.

So, I would go to record 65785 click on the link and it would open a web
page.
The URL contained in the hyperlink would pass the name and address field
values from the database as parameters.

e.g.
https://servername/script.whatever?n...hatever_street
etc

The script would then use those values for its own purposes.
Actually its not a www address, its on the local network but its the same
idea.
What i am trying to do is create some "middleware" to connect the database
to another third party application.
Connecting the application back to the database would be much easier!

I have read the documentation and I don't think its possible to do this, but
I am not an access expert.
I also had a trawl through Google and the Usenet archive with no success.

Any comments?

Should I shoot myself now or persevere?

Thanks

Gordon

[Rich P]

What you are trying to accomplish requires the use of active Server
pages (asp). If your URL points to an asp then your problem is very
simple.

You pick a record. This record will be written to a table that your asp
will read. I am guessing however, that you want other people to access
this webpage. If everyone who is going to see the asp has to click on a
url in your mdb, that would seem a little redundant. You might as well
have the filters in the asp. I mean select the criteria in the asp and
then click on the submit button. Then write the results to the webpage.

As for passing parameters from/through a url, I think you are thinking
of the form post method of an html form submit button that will pass a
name value pair to another html (or asp) page that your form is posting
to.

If I am incorrect in what I think you are thinking then you are using a
scripting technology I am not familiar with. I state this as a
disclaimer to my comments and also to keep up with new stuff (please
share if it is new stuff). Right now I am familiar with asp, aspx, hta,
html, jsp, and how to write an excel page to an html page as far as web
client stuff goes. But you just never know when they come up with
something newer and slicker. Maybe it is possible to pass parameters
from a url in Access.

Rich

*** Sent via Developersdex http://www.developersdex.com ***

[Gordon Hudson]

"Rich P" <rp*****@aol.com> wrote in message
news:pm****************@news.uswest.net...

What you are trying to accomplish requires the use of active Server
pages (asp). If your URL points to an asp then your problem is very
simple.

You pick a record.
That would be the case if the application could access the database but it
can't.
It is closed source so there is no way to make it do that.

What I am trying to do is just pass the values in the URL and use an
intermediate script to
unwrap them and pass them to the application.
In fact I can do this in javascript quite easily without ebven needing any
web server software.

At the moment I copy and paste from the database into an html form but this
seems very wasteful when there must be some way of passing the values.

I suppose I could have an ASP page that took the data from the database and
prefilled a form.
However, this seems a bit of overkill becaus eit woul dmean setting up a web
server on a local machine
for one page.
As for passing parameters from/through a url, I think you are thinking
of the form post method of an html form submit button that will pass a
name value pair to another html (or asp) page that your form is posting
to.

Correct.

As long as I can get the values out of the database in name/value pairs as
part of a URL
I can get them into the other application no problem.
Gordon