EXPORT CUSTOM FORM FIELDS TO A DATABASE

Shree · External Since: Nov 02, 2005 Posts: 6

Hello,
I have created several custom fields in a form(Message). I have 7
tabs(layers) in the form since it has to go to seven other people before the
response in received by me. I would like to export it to an Access database
to generate reports.
Can anyone please show me how to code in order to retrieve the data in access.
Thanks in advance.
Shree

Hollis D. Paul · External Since: Dec 29, 2003 Posts: 360

In article <6551B05C-D9CC-4A27-9657-AC102A4722E6.RemoveThis@microsoft.com>,
=?Utf-8?B?U2hyZWU=?= wrote:
> Can anyone please show me how to code in order to retrieve the data in access.
> Thanks in advance.
>
Go to www.outlook-cod.com and/or www.slipstick.com and search on access. I am
sure you can find a sample code there that you can modify for your purposes.

Hollis D. Paul [MVP - Outlook]
Hollis.RemoveThis@outhousebythesound.com
Mukilteo, WA USA

Sue Mosher [MVP-Outlook] · External Since: Feb 11, 2005 Posts: 21627

See http://www.outlookcode.com/d/customimport.htm
--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Shree" <Shree RemoveThis @discussions.microsoft.com> wrote in message news:6551B05C-D9CC-4A27-9657-AC102A4722E6@microsoft.com...
> Hello,
> I have created several custom fields in a form(Message). I have 7
> tabs(layers) in the form since it has to go to seven other people before the
> response in received by me. I would like to export it to an Access database
> to generate reports.
> Can anyone please show me how to code in order to retrieve the data in access.
> Thanks in advance.
> Shree
>

Stephaan · External Since: Nov 14, 2005 Posts: 2

Hi Shree
I have the same problem as you have and I was wondering whether you have
been able to solve it with the responses given. I have browsed through the
presented wites but I have not found something usefull yet
Should you have been able to solve your problem, would you share the result
with me ?
Thanks in advance
Stephaan

"Shree" schreef:

> Hello,
> I have created several custom fields in a form(Message). I have 7
> tabs(layers) in the form since it has to go to seven other people before the
> response in received by me. I would like to export it to an Access database
> to generate reports.
> Can anyone please show me how to code in order to retrieve the data in access.
> Thanks in advance.
> Shree
>

Shree · External Since: Nov 02, 2005 Posts: 6

Thanks Sue,
I tried codes that you indicated.
After I create a table in access with the custom fields that I have in
outlook forms, what should be my next step.
I tried 23.2.1 about the DSN tab in your book, what should I do after that
to get fields in to the access database. I do not know that much coding,
Being a beginner at this, I'm lost. Please help.
Thanks.

"Sue Mosher [MVP-Outlook]" wrote:

> See http://www.outlookcode.com/d/customimport.htm
> --
> Sue Mosher, Outlook MVP
> Author of Configuring Microsoft Outlook 2003
> http://www.turtleflock.com/olconfig/index.htm
> and Microsoft Outlook Programming - Jumpstart for
> Administrators, Power Users, and Developers
> http://www.outlookcode.com/jumpstart.aspx
>
>
> "Shree" <Shree.DeleteThis@discussions.microsoft.com> wrote in message news:6551B05C-D9CC-4A27-9657-AC102A4722E6@microsoft.com...
> > Hello,
> > I have created several custom fields in a form(Message). I have 7
> > tabs(layers) in the form since it has to go to seven other people before the
> > response in received by me. I would like to export it to an Access database
> > to generate reports.
> > Can anyone please show me how to code in order to retrieve the data in access.
> > Thanks in advance.
> > Shree
> >
>

Shree · External Since: Nov 02, 2005 Posts: 6

I tried the same, but to no avail. I will let you know if I come up with
anything.
Shree

"Stephaan" wrote:

> Hi Shree
> I have the same problem as you have and I was wondering whether you have
> been able to solve it with the responses given. I have browsed through the
> presented wites but I have not found something usefull yet
> Should you have been able to solve your problem, would you share the result
> with me ?
> Thanks in advance
> Stephaan
>
> "Shree" schreef:
>
> > Hello,
> > I have created several custom fields in a form(Message). I have 7
> > tabs(layers) in the form since it has to go to seven other people before the
> > response in received by me. I would like to export it to an Access database
> > to generate reports.
> > Can anyone please show me how to code in order to retrieve the data in access.
> > Thanks in advance.
> > Shree
> >