Solved

InfoPath 2003 Query returning no values

Posted on 2011-03-09
2
317 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

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…
SEO can be a real minefield to navigate, but there are three simple ways to up your SEO game just be re-assessing your content output.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

770 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