Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

InfoPath 2003 Query returning no values

Posted on 2011-03-09
2
Medium Priority
?
338 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
[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
 
LVL 28

Accepted Solution

by:
clayfox earned 2000 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

Free Tool: Subnet Calculator

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.

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…

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.

Join & Ask a Question