Forms

  • Thread starter Thread starter Mary
  • Start date Start date
M

Mary

I have a form being directed into an email.

How do I set-up Access to get that information and put it
in my database?
 
Mary said:
I have a form being directed into an email.

How do I set-up Access to get that information and put it
in my database?
Click to expand...
I assume this is a web based form emailed to you.
Attach your Outlook email as an Access table.

After that it's busywork to open the table, get the information and add it
to a "real " table.

If you have delimiters, all the better. E.G.

Name somebodys name
address a good address
city mycity
state CA

You can open the table in code or use INSERT INTO but basically it's:
With Rst
..addnew
Pos = InStr(YourEmailField, "Name")
!Name = mid ( YourEmailField, Pos + 5, 30) 'or whatever the field width is
Pos = InStr(YourEmailField, "address")
!address= mid ( YourEmailField, Pos + 9, 30) 'or whatever the field width is
etc
..update
or use INSERT INTO.

You can write this in a loop but for me making each set of lines a line on
the form works best.
This is especially true if working with a text file.
 
Back
Top