contact us form from website into Access

  • Thread starter Thread starter nycdon
  • Start date Start date
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!
 
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
 
Back
Top