InfoPath Dev

I have created a form in InfoPath 2007, with one queryfield (city) and 3 datafields (name, subname, address) on it. IP datafields are into a repeating table and primary connection is with an .mdb database table (with 65 datafields and 900 rows). When I query database and reply 'YES' to InfoPath 'large amounts of ...

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 ?  

There is a way to disallow/allow listing out of views in the view menu using VBS code? Thanks.

Solved! Editing Manifest.xsf file, I find my first path and Db two times in connectionString (...;DBQ=\\myfirstpath\mydb.mdb;...;Initial Catalog=\\myfirstpath\mydb"). I don't know why they are present here, but after removed these occurrences and changed Db address into ODBC driver, I work fine with right mdb file. ...

Hi all, for my module I have used an ODBC connection to an Access database (with 23 tables) and all appair to work right. But when I change Database address into ODBC driver, my module appair to access DB at OLD address. How it is possible? I am sure that first time I have used ODBC connection and not a direct path. Also I have tried to change ...

All right, now. Thank you.

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 Greg, thank you for your clear answer, but I have last question. If I use second option and call query() function from code, all datafields on my forms (I have 3 views of datafields) are automatically filled with data after query execution, or I can fill any single field (a lot of fields!) via code?

Hi Greg, thank you for reply. My problem now is to submit a "query_rule" execution after queryfields fill up. Is there a way to submit from code the execution of a "query_rule" (with datafields fill up automation)? Also have you idea for another way to do this? Thanks in advance.

I have a button with code (onclick event) and rule (query submit). Through vbs code I fill query fields, and with query submit rule I try to submit my query, but query appair to start before query fields are filled. There is a way to change priority execution or wait after fields are fill up? Thank you.