Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General MS InfoPath Questions / December 2005

Tip: Looking for answers? Try searching our database.

InfoPath "The query returned large amounts of data..."

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
mtarabochia - 02 Dec 2005 23:58 GMT
I am using an infopath form connected to an access database. I sometimes get
an error message when running a query saying.
"The query returned large amounts of data and rendering your form may take
some time."
Is there a way to fix this?
Shiraz Cupala - 03 Dec 2005 06:05 GMT
Hello,
What is happening here is that the size of the return results have crossed a
threshold internal to InfoPath that causes this dialog to display. I don't
recall offhand what the threshold is.

Some techniques to avoid this dialog are to restructure your query to return
smaller sets of data and then page thru it, or to set query parameters to
filter the data you query for.

For example you could have some dropdown boxes that allow the user to select
values in certain data fields and then use those values as query parameters
to only return records with those values.
Signature

Shiraz Cupala
http://www.autonomysystems.com

> I am using an infopath form connected to an access database. I sometimes get
> an error message when running a query saying.
> "The query returned large amounts of data and rendering your form may take
> some time."
> Is there a way to fix this?
mtarabochia - 03 Dec 2005 19:15 GMT
The query field is connected to the ID of the record. I am using this
function to refresh the form. We don't have the service pack installed for
users so I cannot use the refresh feature available with the service pack.
The query field on the form that causes the problem is read only and
automatically fills in when the form is submited and the new ID number is
generated from the access database. Sometimes it works fine and sometimes it
gives the message listed above.

> Hello,
> What is happening here is that the size of the return results have crossed a
[quoted text clipped - 14 lines]
> > some time."
> > Is there a way to fix this?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.