receiving data form access DB

Last post 12-01-2008 01:15 PM by Hilary Stoupa. 2 replies.

Page 1 of 1 (3 items)
	Sort Posts: Previous Next

11-27-2008 06:12 AM

marinj
Joined on 11-25-2008
Posts 4

receiving data form access DB

Reply Contact

I would like to create info path for submiting and receiving data to and from access database.

I tried to create infopath doc with which contains all data from DB and ID. When I entered ID, DB should retreive data if record with requested ID exists or to enable entering new ID, but DB always return me the first record from DB.

Can someone help me with this?

11-28-2008 04:43 AM In reply to

madhuri
Joined on 07-18-2005
India
Posts 216

Re: receiving data form access DB

Mark as Not Answer Mark as Answer ...

Reply Contact

Hello

Try this code on onclick event

try

{

DataObject adapter = (DataObject)thisXDocument.DataObjects["DataAdpterName"];

adapter.Query();

}

catch (Exception ex)

{

thisXDocument.UI.Alert(ex.ToString());

}

'DataAdpterName' is the DB dataconnectionname.

Madhuri
http://www.ggktech.com

12-01-2008 01:15 PM In reply to

Hilary Stoupa
Joined on 06-20-2008
Posts 13,297

Re: receiving data form access DB

Mark as Not Answer Mark as Answer ...

Reply Contact

Give this tutorial from Office Online a try... It walks through creating a new form from a database as well as querying, submitting, etc.

Hilary Stoupa

Page 1 of 1 (3 items)

InfoPath Dev