Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.
Solved
InfoPath 2003 Query returning no values
Posted on 2011-03-09
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?
2 Comments
Just for a test I would run throught the new form wizard for a database form on a brand new form and see what happens.
Just dump all of the data on the form and see if you can query and insert or update.
This would see if there is an issue with the particualr from or something witht he table structure or something.
Just dump all of the data on the form and see if you can query and insert or update.
This would see if there is an issue with the particualr from or something witht he table structure or something.
Featured Post
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Before you can digitally sign infopath forms, you must have a digital certificate. Microsoft Certificate Services will need to be enabled on a Windows Server 2008 to facilitate the creation and verification of the digital certifciates on the web ser…
Read this post to discover how will you get your first iPhone App Approved by Apple. Make these necessary changes to prevent rejection of the app.
The video will let you know the exact process to import OST/PST files to the cloud based Office 365 mailboxes. Using Kernel Import PST to Office 365 tool, one can quickly import numerous OST/PST files to Office 365. Besides this, the tool also comes…
Watch the video to know the simple way to remove or recover or reset lost or forgotten passwords of Outlook PST file. With Kernel Outlook Password Recovery tool such operation is very easy to perform. It is a freeware with limitation to use with 500…
Suggested Courses
Course of the Month7 days, 13 hours left to enroll
584 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.