InfoPath Dev

I'm not sure what the SQL manager query window is, but I ran it through Access, and it worked. Is SQL manager query window a utility in InfoPath? If so, where do I find it? The SQL syntax was part of the problem, as it turns out... The SQL syntax, while it works in Access, didn't work in InfoPath. I had to change the * wildcard indicators to ...

I realize that. I was wondering if there was a way to cast a memo type to a Infopath-usable type. :0)

Hello, Is there a way I can cast an Access memo type to another data type that is InfoPath friendly?

Hello, I'm trying to perform a simple wildcard query through InfoPath. The query works when I run it in Access, but it doesn't do anything when I run it through InfoPath. The query is below: select [ID],[Name] from [tDisc] as [tDisc] WHERE tDisc.Name LIKE ''*acro*'' I got the syntax for the wildcard from a Microsoft Knowledge Base ...

that was it! I spent so much time trying to figure this out, and it was something so simple I overlooked. Good eye, and thanks.

I have what I believe to be the correct XPath for the above image: dfs:queryFields/q:tDisc/@Name I was able to get it using a little trick shown on this blog: http://egrigg9000.com/mtpub/archives/000064.html I still get an error in my script, and I'm not sure why: Object required File:script.js Line:32 My function is incomplete, but here is ...

For example, I'm trying to figure out the XPath of the Name attribute as pictured below:

Hello, What's the best way to determine the XPath of a control in a form? I have a text field for example. It seems to me I should be able to right-click the text field in the design view, and be able to view the XPath somewhere in the properties dialog, but this is not the case. What's the best way to determine the XPath of an element in a ...

Thanks Greg. It looks like the code behind is the way for me to go. In case anyone is curious, I found a useful article on how to do it here: http://enterprise-solutions.swits.net/infopath2003/article.php?t=query-access-database-list-numbers&c=infopath2003

Hello, I've set up an InfoPath form that connects to an Access db. The form is used to search for titles of software cds. I need the form to return a list of titles even if the whole title was queried for. For example, if I type in 'Microsoft' I need the form to return every title that contains 'Microsoft'. The SQL should look something like ...