printmedia
asked on
This form or report is based on a query that exceeds the limit for data in a single record
Hi all.
I have an Access 2003 form that is displaying the error: "This form or report is based on a query that exceeds the limit for data in a single record"
When I go to the actual query and enter the itemnumber it gives me the error, if I enter another item the query runs.
The query pumps out 172 fields, I've been reading around and I think it's because the query can't pump out more that 2000 characters per row. Is this true? If so, how can I get this to work?
Thank you in advance!
I have an Access 2003 form that is displaying the error: "This form or report is based on a query that exceeds the limit for data in a single record"
When I go to the actual query and enter the itemnumber it gives me the error, if I enter another item the query runs.
The query pumps out 172 fields, I've been reading around and I think it's because the query can't pump out more that 2000 characters per row. Is this true? If so, how can I get this to work?
Thank you in advance!
Last Comment
Helen Feddema
I would start by taking a look at the problem record. It may have something odd in one field.
By record in this case I mean the query filtered by the item number that triggers the error. It may be based on several tables, so you need to determine which table has the field that might be causing the problem.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Error 7799:
This form or report is based on a query that exceeds the limit for data in a single record.@Exclude any unnecessary fields from the query, or change some of the field types to Memo in the original tables.@@1@@1
Never have seen this error.
mx
This form or report is based on a query that exceeds the limit for data in a single record.@Exclude any unnecessary fields from the query, or change some of the field types to Memo in the original tables.@@1@@1
Never have seen this error.
mx
I have also never seen this error, and I have been working with Access since the beta of v. 1.0!
Microsoft Access
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
