contact us form from website into Access

N

nycdon

how could I get an emailed form from a website, into an Access database.

Comes as email like-

First Name: John
Last Name: Smith
Country: France
Rate: 100

thanks!
 
W

Wayne-I-M

Hi

You don't sday what programme you're using for the on-line form.

If you are using frontpage or expression then you would be better saving the
on-line page as an .asp then using the wizard to create a database to hold
the e mailed details. This will be an access database (this is what we do on
some websites).

Next import the table (the on-line table holding the form details) into your
normal DB.

You can set up a simple macro to check every 10 mins or whatever.

Here is one method (there are others) to import the results of your on-line
form into your normal DB. You could set up a warning (pop-up form or
whatever) to show if there are new messages.

http://groups.google.com/group/micr...=wayne+external+group:microsoft.public.access

It looks a little complex to do but once it's done it will run forever
(hopefully :)

Good luck



You
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top