By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,318 Members | 2,116 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,318 IT Pros & Developers. It's quick & easy.

Union Query and Filter By Form, Access crash

P: n/a
Hi everybody
I have an Union Query that works fine. I used this query as the
RecordSource for a Form. That Form is used as a subform in another form.
Everything works fine, except for the "Filter by form" feature. When
the user tries to use Filter by form a messagebox is displayed: "There
are too many controls in this form to perform a filter by form", after
that,when the user exit the Filter by Form mode, Access crash,
displaying a messsage box:" Application error, instruction 0x300d9eeb
refrences memory at "0x00000000", memory can be "read"" (This is in
Win2k, but access closes in WinXp too). I tried to solve this problem by
copying everything to a new form, and then compacting, as is suggested
in some posts, but the problem is not solved. It seems that the problem
is using the form as subform, as I tried using the subform in a form
with only 1 control (a textbox used to establish the form/subform
relation) and the problem is still present. I hope anybody can help me.
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
I can't solve the problem -- I have never experienced this, but a potential
workaround is, instead of using a filter, modify the SQL that is
RecordSoource of the Form embedded in the Subform Control to limit the
records.

Larry Linson
Microsoft Access MVP

"Lenin Torres" <le***@incaflowers.com> wrote in message
news:dg**********@domitilla.aioe.org...
Hi everybody
I have an Union Query that works fine. I used this query as the
RecordSource for a Form. That Form is used as a subform in another form.
Everything works fine, except for the "Filter by form" feature. When the
user tries to use Filter by form a messagebox is displayed: "There are too
many controls in this form to perform a filter by form", after that,when
the user exit the Filter by Form mode, Access crash, displaying a messsage
box:" Application error, instruction 0x300d9eeb refrences memory at
"0x00000000", memory can be "read"" (This is in Win2k, but access closes
in WinXp too). I tried to solve this problem by copying everything to a
new form, and then compacting, as is suggested in some posts, but the
problem is not solved. It seems that the problem is using the form as
subform, as I tried using the subform in a form with only 1 control (a
textbox used to establish the form/subform relation) and the problem is
still present. I hope anybody can help me.

Nov 13 '05 #2

P: n/a
Larry Linson escribió:
I can't solve the problem -- I have never experienced this, but a potential
workaround is, instead of using a filter, modify the SQL that is
RecordSoource of the Form embedded in the Subform Control to limit the
records.

Larry Linson
Microsoft Access MVP

"Lenin Torres" <le***@incaflowers.com> wrote in message
news:dg**********@domitilla.aioe.org...
Hi everybody
I have an Union Query that works fine. I used this query as the
RecordSource for a Form. That Form is used as a subform in another form.
Everything works fine, except for the "Filter by form" feature. When the
user tries to use Filter by form a messagebox is displayed: "There are too
many controls in this form to perform a filter by form", after that,when
the user exit the Filter by Form mode, Access crash, displaying a messsage
box:" Application error, instruction 0x300d9eeb refrences memory at
"0x00000000", memory can be "read"" (This is in Win2k, but access closes
in WinXp too). I tried to solve this problem by copying everything to a
new form, and then compacting, as is suggested in some posts, but the
problem is not solved. It seems that the problem is using the form as
subform, as I tried using the subform in a form with only 1 control (a
textbox used to establish the form/subform relation) and the problem is
still present. I hope anybody can help me.


Larry, in fact I don't want to do any filtering, it's just that when a
user tries to use the Filter By Form feature, the program crashes. Also,
when the user filters in any other way, such as by right clicking in a
field or using the tool bar, everything goes fine. Of course, I am
thinking on the posibility of coding the filtering feature the user is
trying to do using Filter By Form, but I wonder if this is an Access
Bug. Anyway, the only workaround that work for my until now is disabling
Filter By Form feature in that form, with the following code:

Private Sub Form_ApplyFilter(Cancel As Integer, ApplyType As Integer)
if ApplyType = acFilterByForm Then
Cancel = True
End If
End Sub
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.