Search Form

[motorhome]

I am currently designing a website where I need a search form to search for a name on another page. eg if the user searches for a surname e.g. "Smith" I want the result to publish a list of all the Smiths on that page. The user should then identify which Smith they want and click on the hyperlink to that Smiths page.

Is there anyway I can do this using a vlookup type approach rather than having to search an Access database?

Anyway help would be greatly appreciated.

Kate

[PeOfEo]

I dont even know what vlookup is but you will need some form of server side scripting and a data base to do this type of operation.

[havik]

Agreed, it'd be possible to do it within the same page like this page (http://www.pacs-portal.co.uk/startup_pages/startup_full.htm#Search) does.

Havik

[khaki]

Originally posted by PeOfEo
I dont even know what vlookup is but you will need some form of server side scripting and a data base to do this type of operation. Exactly.

VLOOKUP (and HLOOKUP) are Excel functions (formulas) which takes a specific value from a specific column from within a specified range of cells...
and after the specific value is located...
it allows you to extract a specific value from the same row as where the "looked-up" value resides.
(it's a lot less complicated than I descibe it :rolleyes: )

VLOOKUP (and HLOOKUP) are actually just formulas which allow Excel to do primitive queries (is that a little better? :rolleyes: )

so anyway Kate... (since you already knew all that)...
the point is...
you will need to use SQL/DB to accomplish that same kind of thing on a web page.
AND even so... it doesn't exactly really work across web pages (unless the web pages derive their content from a database).

So... how does that relate to your original question?
sadly... it doesn't :(

The bottom-line is that you really do need to use a database for that kind of thing
(not an option, huh?)

sorry :(

;) k

[PeOfEo]

wait if you can do it in excel wouldny the xp version of access include it, wouldnt ms build that into access?

[khaki]

the question said, " rather than having to search an Access database?"

it appears that Access was not a preferred solution Peo (regardless of the OS being used.... although Kate never even mentioned XP... so what question are you answering? :) )

and besides....
Access uses queries to do that kind of thing. VLOOKUP and HLOOKUP would not be needed in Access... it's an Excel thing.

VLOOKUP(answer, this thread, the non-Access solution)...
;) k

[PeOfEo]

... the bathtub frightens me ... thats what i'll say whenever I have met my match for now on. :p

[khaki]

;)

[motorhome]

Actually Peo you've been a great help. I am running XP and I think I have solved my problem - unfortunately it's mean't using ASP which I'm not terribly hot on. Thanks everyone for your help.

Kate.

[PeOfEo]

oh well, I like asp.net :) I cant wait for my java class to start though because once I get semi fluent at java Im going to pick up a nice book on jsp :)