VBScript, form, validation, and database

I am having a very difficult time trying to validate fields in a form on submit; loading a thank you page and sending the info into a data on the submit button.
This is what I need:
1) A form with required fields so that when the submit button is pressed an error message pops up telling the user to fill in the required field.
2) Once the form is completed (with the required fields), on submit the user will see a thankyou page saying the information has been saved into a database.
3) Once submitted the information provided by the user has to be stored in a database.
This is what I have:
1) A mess!
2) A form (prform.asp) that looks really good but doesn't validate.
3) A thank you page (infosub.asp) with lots of codes that I don't know what they do.
3) A database (projectregistration.mdb) that takes information only if the field is filled (required or not).

If there is anyone who can help me or would like to help me, please contact me at cjsanchez1@hotmail.com

Thanks,
I'm

PS...I tried to attach the files but it seems that it only takes one. Can I get around this?

1) Use javascript to validate your form: here is a link to the first site that came up in my search:
http://javascript.about.com/library...y/aa070901a.htm

2)printing a 'thank you' could be done pretty easily...this is basic ASP

3)form validation can help you get around some of this. you also might need to modify your sql statement to reflect certain fields that need to be updated...maybe use some if statements.

stuff like this is pretty basic ASP. i would suggest taking some time out of your day for a tutorial...it will help.