Newbie Questions

Re: Infopath with Access

sagiu — Fri, 30 May 2008 09:05:41 GMT

Clay,

Thanks for the reply.

Is there a way I can send you the mdb file in zipped format to explain further?

Thanks,

Steve

Clay Fox — Thu, 29 May 2008 13:30:25 GMT

Two things.

1 - make sure you have sample data in each of your three tables when you create the form, InfoPath uses that to set up the fields etc.

2 - Once you have the default form from the wizard.

You can add values to the query fields and then execute a query to load a record from the DB into the data fields.

You then must either edit the loaded record or insert a new record and update the values or have default values.

The submit will not complete if you have not modified the loaded data or if the new data is blank.

I would play with the sample form a bit more and verify you understand how to query, update, and insert new records to the database.

sagiu — Thu, 29 May 2008 11:48:01 GMT

Dear All,

I have created a small database in MS Access with three tables.

Customers (ID and NAME)

Sales (ID, CUSTOMER_ID, REVENUE)

Purchases (ID, CUSTOMER_ID, TURNOVER)

In MS Access these tables are linked via the Customers.ID, Sales.CUSTOMER_ID and Purchases.CUSTOMER_ID.

I have tried to create a form in Infopath to capture this data.

However upon submission, I am getting the following:

"Empty row cannot be inserted. Row must have at least one column value set."

Any ideas???

Thanks