 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / General MS InfoPath Questions / March 2007How to determine which query is running
Hello, I have to troubleshoot an InfoPath form which has a button on it, the properties of which are to Run Query. The query is totally messed up and I need to fix it but I am not that familiar with InfoPath. The form is connected to an Access database. How do I determine which query this button is running? Thanks very much for any help. > Hello, > I have to troubleshoot an InfoPath form which has a button on it, the > properties of which are to Run Query. The query is totally messed up and I > need to fix it but I am not that familiar with InfoPath. The form is > connected to an Access database. How do I determine which query this button > is running? Thanks very much for any help. Hi Joanne, I am also fairly new to InfoPath but I may be able to help. First place to check is the button properties to look for a rule. Right click the button, select Rules, then modify (if one exists) there should be an action listed to query a database connection. Your form could have several connections - so it depends on who designed it. Go to Tools, Data connections - this will show you all connections. The connections should give you some kind of direction - hope this helps! David Go to Tools > Data Connections. Select the Main connection for your form and click on Modify. Then click on Edit SQL. --- S.Y.M. Wong-A-Ton > Hello, > I have to troubleshoot an InfoPath form which has a button on it, the > properties of which are to Run Query. The query is totally messed up and I > need to fix it but I am not that familiar with InfoPath. The form is > connected to an Access database. How do I determine which query this button > is running? Thanks very much for any help. Thank you so much for your timely response. That cleared things up a lot. I have one more point of confusion. This person has several connections. How do I know that this button is using the main connection? > Go to Tools > Data Connections. Select the Main connection for your form and > click on Modify. Then click on Edit SQL. [quoted text clipped - 7 lines] > > connected to an Access database. How do I determine which query this button > > is running? Thanks very much for any help. When you click on a data connection in the "Data Connections" dialog box, you can check in the "Details" section below what the type is of the data connection. If the form is bound to a database, the Run Query option will use the data connection of type "Retrieve and submit data to database". --- S.Y.M. Wong-A-Ton > Thank you so much for your timely response. That cleared things up a lot. I > have one more point of confusion. This person has several connections. How do [quoted text clipped - 11 lines] > > > connected to an Access database. How do I determine which query this button > > > is running? Thanks very much for any help. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.