troubleshooting Question
InfoPath 2003 Query returning no values
I have created a form that uses the customer number in a query field to return customer and equipment data. The data resides in a 2003 access database table named "Customers." When I previewed the form the first time I had no problem populating data. The second time I tried it I recieved an error message stating no query data was found. Not True, data exists.
I deleted the data link, recreated it, restablished my bindings and tried again with no luck. I then copied the SQL statement from InfoPath and pasted it into excel and tried to pull up the data with success.
I'm stumped now. I've looked at the forms permissions and nothing has changed since I created it.
Any ideas on what to check next?
I deleted the data link, recreated it, restablished my bindings and tried again with no luck. I then copied the SQL statement from InfoPath and pasted it into excel and tried to pull up the data with success.
I'm stumped now. I've looked at the forms permissions and nothing has changed since I created it.
Any ideas on what to check next?
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.