The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.
One of a set of tools we're offering as a way of saying thank you for being a part of the community.
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?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
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.
If you are experiencing a similar issue, please ask a related question
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…
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"!
Step 1: Open a new google tab
Step 2: Go to the left hand upper corn…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data.
But that feeling is fleeting. Attacks these days can happen in many w…
Suggested Courses
Course of the Month5 days, 20 hours left to enroll
688 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.