Displaying form as a search result

[Guest]

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.

 

[Stefan B Rusynko]

See http://support.microsoft.com/default.aspx?scid=kb;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/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


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

 

[Guest]

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]

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/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| 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.aspx?scid=kb;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/FrontPageNewsGroups/tabid/53/Default.aspx
| > _____________________________________________
| >
| >
| > | 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.
| >
| >
| >

 

[Guest]

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