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.
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!
All right, now.
Thank you.
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 ?
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.