Solved

InfoPath 2003 Query returning no values

Posted on 2011-03-09
2
314 Views
Last Modified: 2012-05-11
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?
0
Comment
Question by:jefjar
2 Comments
 
LVL 28

Accepted Solution

by:
clayfox earned 500 total points
ID: 35094872
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.
0
 

Author Closing Comment

by:jefjar
ID: 35116293
Creating the new form lead me back to the Database and the query that was being performed there.
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

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…
In this article, you will read about the trends across the human resources departments for the upcoming year. Some of them include improving employee experience, adopting new technologies, using HR software to its full extent, and integrating artifi…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

706 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now