too large query

[leahf via AccessMonster.com]

We have a form with many parameters for classes in a school. After choosing
parameters, there is a subform that gives a minimum amount of information
about all the classes requested according to the parameters.

On that same form is an option to get two different reports about the
selected classes. I am now to add a new parameter - the language that the
class uses.

I added the necessary fields in the form, queries and reports and everything
worked. However, once I went out of the form and back in again, there was a
message to put in the language field. When I checked, it turns out that the
language field is not in the query.

After adding it and saving it again, everything worked until I got out of the
form. Then the language field disappeared from the query again.

I am assuming that the query is too large (over 30 fields). The query is the
input of the report. Any suggestions?

Thanks.
Leah

 

[John Spencer (MVP)]

A query can have up to 255 fields - so 30 fields is not too large.

Usually when I run into this type of problem, I find out that I have been
building the query string in VBA code and have forgotten to include the field
when I am building the query string. Is that a possibility for you?

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[John W. Vinson]

After adding it and saving it again, everything worked until I got out of the
form. Then the language field disappeared from the query again.

I am assuming that the query is too large (over 30 fields). The query is the
input of the report. Any suggestions?

30 fields is a very modest query. My guess is that the language field has
neither a criterion, nor a sort, nor is its "show" checkbox checked in the
query grid; Access will discard a field from the query if it's not used in any
way!

If this doesn't help please open the query in SQL view and post the SQL text
here.

 

[leahf via AccessMonster.com]

Thank you, thank you, thank you. I felt that this had to be the problem but
until I found the one query that I had not updated with the language field...

Everything is now working.

Thanks again.
Leah

A query can have up to 255 fields - so 30 fields is not too large.

Usually when I run into this type of problem, I find out that I have been
building the query string in VBA code and have forgotten to include the field
when I am building the query string. Is that a possibility for you?

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

We have a form with many parameters for classes in a school. After choosing
parameters, there is a subform that gives a minimum amount of information

[quoted text clipped - 17 lines]

Thanks.
Leah

 

[leahf via AccessMonster.com]

Thanks for your response. As you can see from above, the problem is now
solved.

Leah