Linking Web form pages to an access db

[badger8]

I would like to take a form that people fill out online, and all the results go into an access table.

Within this table will be people that we have sent an email too, so I would like when a person enters their name within the form that if they already existed in the database all the fields that we have information for already get automactially populate for the contact.

Once the person clicks submit, I would like the database to send them an email thanking them for registering.

I know I'm asking for a few questions, but if anybody can give me some directions in creating what I need aobe would be great.

Thank you
Ray

 

[MikeT]

You will definitley need some server side scripting, such as ASP. ASP will allow you to store the contents of the submitted form to the access database. This is a VERY common question, and its not hard to do, but when you start looking into ASP coding, you'll probably feel overwhelmed. You will need to setup your webserver to handle ASP, which is free if your using IIS or PWS. If your using anything else, you can use PHP instead of ASP (different ballgame).
As far as the form auto-filling, you could do it with some ASP and Javascript. If the database has more than a couple hundred contacts, the page would most likely have to be refreshed after the name is entered to get the rest of the contacts info.
It is possible to do what you want.