SQL Database Integration

Re: Execute queries stored on Access DB and return list result on Infopath form

Matt Faus — Mon, 25 Jun 2007 08:24:33 GMT

Hi Raoul,

You might want to take a look at this blog post, it should help you out: http://www.infopathdev.com/blogs/matt/archive/2006/01/09/Create-a-Multi_2D00_View-Master_2F00_Detail-using-a-Query-Filter.aspx

If you don't want to use code you can convert the sample give to Rules quite easily.

Re: Execute queries stored on Access DB and return list result on Infopath form

Raoul — Thu, 21 Jun 2007 11:22:08 GMT

Sorry Matt, but I have met another problem. How can I send a parameter (year) to a query stored on Access Db and then refresh view for display all returning records ?

Re: Execute queries stored on Access DB and return list result on Infopath form

Raoul — Wed, 20 Jun 2007 17:49:15 GMT

All right, now.

Thank you.

Re: Execute queries stored on Access DB and return list result on Infopath form

Matt Faus — Tue, 19 Jun 2007 09:06:44 GMT

Hi Raoul,

If you already have the connection to the Access DB, this should be pretty easy. If you open the Data Source taskpane and look at the connection that is pointed to Access you should be able to expand the dataFields to see a repeating table that represents all of the rows in your Access query. If you drag-n-drop this repeating group node onto the view you can create a repeating table control that will display all returned records once the form is opened.

I hope this helps!

Execute queries stored on Access DB and return list result on Infopath form

Raoul — Mon, 18 Jun 2007 07:50:23 GMT

Hi all,

I have a primary connection to an Access Db for edit my tables, but now I need to execute some queries stored on Access DB and return list results (list only, like Access list result) on infopath form . Can you help me?

Thanks in advance.