Hi,

I have a form that our employees fill out to log the calls. Form works
great, sends the information to database. For search, I am able to search
for the records and have a table set to show results in Database result
region.

Now what i want to do is to create one of the result fields as a hyperlink,,
which will take to the original form that was filled out by rep. So if
anther rep wants to modify it, they can just enter their comments andmodify.
I am not sure how to create a hyperlink so that I can get the form.

See http://support.microsoft.com/default...b;EN-US;237805

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPa...3/Default.aspx
_____________________________________________


"shikha" <(E-Mail Removed)> wrote in message news:81C7E829-BB9A-44D6-BBDA-(E-Mail Removed)...
| Hi,
|
| I have a form that our employees fill out to log the calls. Form works
| great, sends the information to database. For search, I am able to search
| for the records and have a table set to show results in Database result
| region.
|
| Now what i want to do is to create one of the result fields as a hyperlink,,
| which will take to the original form that was filled out by rep. So if
| anther rep wants to modify it, they can just enter their comments andmodify.
| I am not sure how to create a hyperlink so that I can get the form.

Hi Stefan,

Thank you for your help. It is not working, I have created the ID as
hyperlink, when I click on ID, it takes me to page not found.

Any suggestions, what I may be doing wrong?

"Stefan B Rusynko" wrote:

> See http://support.microsoft.com/default...b;EN-US;237805
>
> --
>
> _____________________________________________
> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> "Warning - Using the F1 Key will not break anything!" (-;
> To find the best Newsgroup for FrontPage support see:
> http://www.frontpagemvps.com/FrontPa...3/Default.aspx
> _____________________________________________
>
>
> "shikha" <(E-Mail Removed)> wrote in message news:81C7E829-BB9A-44D6-BBDA-(E-Mail Removed)...
> | Hi,
> |
> | I have a form that our employees fill out to log the calls. Form works
> | great, sends the information to database. For search, I am able to search
> | for the records and have a table set to show results in Database result
> | region.
> |
> | Now what i want to do is to create one of the result fields as a hyperlink,,
> | which will take to the original form that was filled out by rep. So if
> | anther rep wants to modify it, they can just enter their comments andmodify.
> | I am not sure how to create a hyperlink so that I can get the form.
>
>
>

The hyperlink needs to be valid url (not just any DB field)
See http://www.asp101.com/samples/ for std asp samples


--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPa...3/Default.aspx
_____________________________________________


"shikha" <(E-Mail Removed)> wrote in message news:9D3DCE72-392B-4F80-AEF2-(E-Mail Removed)...
| Hi Stefan,
|
| Thank you for your help. It is not working, I have created the ID as
| hyperlink, when I click on ID, it takes me to page not found.
|
| Any suggestions, what I may be doing wrong?
|
| "Stefan B Rusynko" wrote:
|
| > See http://support.microsoft.com/default...b;EN-US;237805
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| > http://www.frontpagemvps.com/FrontPa...3/Default.aspx
| > _____________________________________________
| >
| >
| > "shikha" <(E-Mail Removed)> wrote in message news:81C7E829-BB9A-44D6-BBDA-(E-Mail Removed)...
| > | Hi,
| > |
| > | I have a form that our employees fill out to log the calls. Form works
| > | great, sends the information to database. For search, I am able to search
| > | for the records and have a table set to show results in Database result
| > | region.
| > |
| > | Now what i want to do is to create one of the result fields as a hyperlink,,
| > | which will take to the original form that was filled out by rep. So if
| > | anther rep wants to modify it, they can just enter their comments andmodify.
| > | I am not sure how to create a hyperlink so that I can get the form.
| >
| >
| >

Hi Stefan,

I will try using the script from the site you gave me, and I used log in
script from that site, when i tried to login, I got the error

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Could not find file '(unknown)'.

/districtcal/database1_interface/Results/login_db.asp, line 59

any idea why? I am really sorry to bother you and appreciated your help,
have my project due this monday, and I am missing login and connecting the
form to teh file.

Thank you sooooooooooo much,

Shikha


"Stefan B Rusynko" wrote:

> The hyperlink needs to be valid url (not just any DB field)
> See http://www.asp101.com/samples/ for std asp samples
>
>
> --
>
> _____________________________________________
> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> "Warning - Using the F1 Key will not break anything!" (-;
> To find the best Newsgroup for FrontPage support see:
> http://www.frontpagemvps.com/FrontPa...3/Default.aspx
> _____________________________________________
>
>
> "shikha" <(E-Mail Removed)> wrote in message news:9D3DCE72-392B-4F80-AEF2-(E-Mail Removed)...
> | Hi Stefan,
> |
> | Thank you for your help. It is not working, I have created the ID as
> | hyperlink, when I click on ID, it takes me to page not found.
> |
> | Any suggestions, what I may be doing wrong?
> |
> | "Stefan B Rusynko" wrote:
> |
> | > See http://support.microsoft.com/default...b;EN-US;237805
> | >
> | > --
> | >
> | > _____________________________________________
> | > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> | > "Warning - Using the F1 Key will not break anything!" (-;
> | > To find the best Newsgroup for FrontPage support see:
> | > http://www.frontpagemvps.com/FrontPa...3/Default.aspx
> | > _____________________________________________
> | >
> | >
> | > "shikha" <(E-Mail Removed)> wrote in message news:81C7E829-BB9A-44D6-BBDA-(E-Mail Removed)...
> | > | Hi,
> | > |
> | > | I have a form that our employees fill out to log the calls. Form works
> | > | great, sends the information to database. For search, I am able to search
> | > | for the records and have a table set to show results in Database result
> | > | region.
> | > |
> | > | Now what i want to do is to create one of the result fields as a hyperlink,,
> | > | which will take to the original form that was filled out by rep. So if
> | > | anther rep wants to modify it, they can just enter their comments andmodify.
> | > | I am not sure how to create a hyperlink so that I can get the form.
> | >
> | >
> | >
>
>
>