Great form in Access... can I import into Infopath?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Wendy - 27 Sep 2006 19:28 GMT

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?

Signature

Wendy Taylor

Reply to this Message

S.Y.M. Wong-A-Ton - 29 Sep 2006 07:36 GMT

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

> 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
[quoted text clipped - 8 lines]
> 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?

Reply to this Message

Wendy - 29 Sep 2006 14:06 GMT

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?

Signature

Wendy Taylor

> 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
[quoted text clipped - 14 lines]
> > 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?

Reply to this Message

S.Y.M. Wong-A-Ton - 30 Sep 2006 09:26 GMT

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

> 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
[quoted text clipped - 20 lines]
> > > 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?

Reply to this Message