Interactive Userform

[Continental Translations]

Not too sure if this is the correct NG, but here goes....

I am in the process of creating a website
([url]http://www.continental-translations.com[/url] - well someone is creating it for
me) and I am hoping to put an interactive userform in the website.

Basically I have an MS Access Database set up so that I can pick a language
pair, insert how many words, and then it will search the database and come
back with a price, based on the info from the database. Is there anyway I
can do this on a website? I have heard I need to use ASP or something?

Have a look at this website to see what I mean:-

[url]http://www.thetranslationbank.co.uk/onlinequote.asp[/url]

Any help would be appreciated!

Thanks

PS: I'd need a step-by-step guide as I'm not that clued up.
PPS: I am using MS FrontPage 2000 to create website

[Bullschmidt]

<<

Not too sure if this is the correct NG, but here goes....

I am in the process of creating a website
([url]http://www.continental-translations.com[/url] - well someone is creating it
for
me) and I am hoping to put an interactive userform in the website.

Basically I have an MS Access Database set up so that I can pick a
language
pair, insert how many words, and then it will search the database and
come
back with a price, based on the info from the database. Is there anyway
I
can do this on a website? I have heard I need to use ASP or something?

Have a look at this website to see what I mean:-

[url]http://www.thetranslationbank.co.uk/onlinequote.asp[/url]

Any help would be appreciated!

Thanks

PS: I'd need a step-by-step guide as I'm not that clued up.
PPS: I am using MS FrontPage 2000 to create website

>>

Here's a possible SQL statmeent I just put together on a sample database
getting the highest invoice number (which is akin to number of words in
your case) up to or including the desired invoice number which may or
may not exist. And for that invoice number it gives the customer number
(which is akin to the price in your case).

SELECT TOP 1 tblInv.InvID, tblInv.InvCustID
FROM tblInv
WHERE (((tblInv.InvID)<=1011))
ORDER BY tblInv.InvID DESC;

And in the above the 1001 for the invoice number is hardcoded but here
is how to do something like that in a non-hardcoded manner (although in
your case the multiple fields aspect may not apply):

Classic ASP Design Tips - Search Criteria on Multiple Fields
[url]http://www.bullschmidt.com/devtip-searchcriteria.asp[/url]

And [url]www.asp101.com[/url] has a Samples area with some short database examples.

Best regards,
J. Paul Schmidt, Freelance ASP Web Developer
[url]http://www.Bullschmidt.com[/url]
Classic ASP Design Tips, ASP Web Database Demo, ASP Bar Chart Tool...


*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!