Frontpage 2003 / Access 2003 - Automatically open a hyperlink...

P

Pheidippedes

I am rather new at this, and have tried everything that I know of (which is
limted) to get this to work with no success.

Basically, on the home page of my web site (index.htm), I want the users to
be able to enter into a box an 8-letter code (all alpha characters, not case
sensitive) that will search an Access 2003 database in my _private folder in
a field named "CustomerCode" for an exact match (it must be an exact match).
If that code is found, then I want it to automatically open the correspoding
"CustomerURL" field in a separate window. If it is not found, I want a
message to come up saying something like "Code not found, please try again."
I have created both of these fields in the database as text, so I believe I
have that correct. I have searched all over the internet in Google and MSN
and MSDN for something like this and have found no working examples to use
the code by.

Any help would be greatly appreciated.
 
S

Stefan B Rusynko

Try http://www.outfront.net/spooky/search_form.htm




|I am rather new at this, and have tried everything that I know of (which is
| limted) to get this to work with no success.
|
| Basically, on the home page of my web site (index.htm), I want the users to
| be able to enter into a box an 8-letter code (all alpha characters, not case
| sensitive) that will search an Access 2003 database in my _private folder in
| a field named "CustomerCode" for an exact match (it must be an exact match).
| If that code is found, then I want it to automatically open the correspoding
| "CustomerURL" field in a separate window. If it is not found, I want a
| message to come up saying something like "Code not found, please try again."
| I have created both of these fields in the database as text, so I believe I
| have that correct. I have searched all over the internet in Google and MSN
| and MSDN for something like this and have found no working examples to use
| the code by.
|
| Any help would be greatly appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top