Group:  Other Microsoft Office Products ยป microsoft.public.infopath
Thread: Great form in Access... can I import into Infopath?

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

Great form in Access... can I import into Infopath?
Wendy 27.09.2006 18:28:02
I have created a wonderful Access database that records issues for my
company. I was just informed that I would be keeping records and creating
reports for all areas of our company now (not just mine). This is a national
organization. It is not feasible for me to train someone in each location so
I thought that I could make a form that relates to my database that they
could all fill out that would be perfect. They could fill the form out... it
would get automatically entered into the database and they would never even
have access to my database. My problem lies in trying to link the
information. I have a wonderful form that I have created in Access that I use
for my own entries. Is there a way to extract that form into Infopath? Also
when I try to do this manually it won't allow me to pull from the database my
tables that are used for validation rules. Will I need to do this manually?
--
Wendy Taylor
RE: Great form in Access... can I import into Infopath?
S.Y.M. Wong-A-Ton 29.09.2006 06:36:02
To my knowledge, you cannot import an Access form into InfoPath, but will
have to recreate it manually yourself (use "New from Data Connection" when
creating your form and bind it to your database).
---
S.Y.M. Wong-A-Ton


"Wendy" wrote:

[Quoted Text]
> I have created a wonderful Access database that records issues for my
> company. I was just informed that I would be keeping records and creating
> reports for all areas of our company now (not just mine). This is a national
> organization. It is not feasible for me to train someone in each location so
> I thought that I could make a form that relates to my database that they
> could all fill out that would be perfect. They could fill the form out... it
> would get automatically entered into the database and they would never even
> have access to my database. My problem lies in trying to link the
> information. I have a wonderful form that I have created in Access that I use
> for my own entries. Is there a way to extract that form into Infopath? Also
> when I try to do this manually it won't allow me to pull from the database my
> tables that are used for validation rules. Will I need to do this manually?
> --
> Wendy Taylor
RE: Great form in Access... can I import into Infopath?
Wendy 29.09.2006 13:06:02
Ok I just have one more question about this project... when I create a form
using "New from Data Connection" I keep getting an error saying it cannot
read some of my tables in Access or that they are unconnected. These are the
tables that I use for my pull down menus that just contain a list. Will I
need to enter these in manually?
--
Wendy Taylor


"S.Y.M. Wong-A-Ton" wrote:

[Quoted Text]
> To my knowledge, you cannot import an Access form into InfoPath, but will
> have to recreate it manually yourself (use "New from Data Connection" when
> creating your form and bind it to your database).
> ---
> S.Y.M. Wong-A-Ton
>
>
> "Wendy" wrote:
>
> > I have created a wonderful Access database that records issues for my
> > company. I was just informed that I would be keeping records and creating
> > reports for all areas of our company now (not just mine). This is a national
> > organization. It is not feasible for me to train someone in each location so
> > I thought that I could make a form that relates to my database that they
> > could all fill out that would be perfect. They could fill the form out... it
> > would get automatically entered into the database and they would never even
> > have access to my database. My problem lies in trying to link the
> > information. I have a wonderful form that I have created in Access that I use
> > for my own entries. Is there a way to extract that form into Infopath? Also
> > when I try to do this manually it won't allow me to pull from the database my
> > tables that are used for validation rules. Will I need to do this manually?
> > --
> > Wendy Taylor
RE: Great form in Access... can I import into Infopath?
S.Y.M. Wong-A-Ton 30.09.2006 08:26:01
Is there security of any kind on the database? It is kind of a strange
message to receive.

You can bind the form to one table (using New from Data Connection) and if
you need to get data from other tables to fill drop-down list boxes on the
form, you can create secondary data sources for each one of those "list"
tables and bind the drop-downs to the secondary data sources. Not sure if
this answers your question?
---
S.Y.M. Wong-A-Ton


"Wendy" wrote:

[Quoted Text]
> Ok I just have one more question about this project... when I create a form
> using "New from Data Connection" I keep getting an error saying it cannot
> read some of my tables in Access or that they are unconnected. These are the
> tables that I use for my pull down menus that just contain a list. Will I
> need to enter these in manually?
> --
> Wendy Taylor
>
>
> "S.Y.M. Wong-A-Ton" wrote:
>
> > To my knowledge, you cannot import an Access form into InfoPath, but will
> > have to recreate it manually yourself (use "New from Data Connection" when
> > creating your form and bind it to your database).
> > ---
> > S.Y.M. Wong-A-Ton
> >
> >
> > "Wendy" wrote:
> >
> > > I have created a wonderful Access database that records issues for my
> > > company. I was just informed that I would be keeping records and creating
> > > reports for all areas of our company now (not just mine). This is a national
> > > organization. It is not feasible for me to train someone in each location so
> > > I thought that I could make a form that relates to my database that they
> > > could all fill out that would be perfect. They could fill the form out... it
> > > would get automatically entered into the database and they would never even
> > > have access to my database. My problem lies in trying to link the
> > > information. I have a wonderful form that I have created in Access that I use
> > > for my own entries. Is there a way to extract that form into Infopath? Also
> > > when I try to do this manually it won't allow me to pull from the database my
> > > tables that are used for validation rules. Will I need to do this manually?
> > > --
> > > Wendy Taylor

Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net