Re: access crashing after filter

On May 8, 4:36 pm, "BruceM" <bam...@xxxxxxxxxxxxxxxxx> wrote:
For one thing, -1 is True and 0 is False, assuming that B_Completed,
B_Waived, and B_Loss are Yes/No fields.

I have tried with "=0", "<>0", "=TRUE", "=FALSE". All fail

Perhaps you have left out some code, but you don't seem to have declared
tRst.

Declared at the form module level

One line of code is: Set tRst = Me.Recordset
Later, there is: Set Me.Recordset = tRst
In between, nothing affects either Me.Recordset or tRst. You define tRst as
Me.Recordset, then you define Me.Recordset as tRst, but to what end? The
filter and the recordset are two different things. Nothing in your posted
code affects the recordset. If you do have occasion to define Me.Recordset,
you can just use:

With regrads to above and below comments - I think you've
misunderstood. I'm using ADO recordsets generated from MS SQL Server
instance. MS Access cannot filter such Recordsets in the normal way -
ie using the form properties .Filter and .FilterOn

To filter such a Recordset - the recordset itself has to be filtered
and then re- set to the forms recordset. Just applying the filter on
the ADO recordset will not do. Hence:
Set tRst= Me.Recordset
tRst.Filter = "my filter" ' not enough to filter the form
Set Me.Recordset = tRst ' set the filtered recordset for the form

However, IF there is another way to do this, i'm very interested to
know :)


Me.Recordset = strRS (where strRS is a string that you use as a SELECT
statement). What is the intention of the Recordset code?
It may be helpful to set the code to break on all errors. If the code does
not reach the debug line, try adding debug lines elsewhere. For one thing,
make sure that tRst is what you expect (assuming you need it at all).
When I apply a filter I use:
Me.Filter = fil
Me.FilterOn = True
I am not quite familiar with the approach you have taken, but I expect that
you specifically need to apply the filter, not just define it.

On another note, Value is the default property for a combo box, so there is
no need to specify:
If cmbFilter = "None"
There is no harm to specifying Value, but you may as well simplify where you
can.

MS Access is giving me so much trouble!

Riyaz

.

Relevant Pages

  • Re: access crashing after filter
    ... SQL server and an ADO recordset. ... results in the recordset tRst being redefined as a filtered recordset, ... recordset without specifically applying the filter. ...
    (microsoft.public.access.forms)
  • Re: access crashing after filter
    ... Set tRst = Me.Recordset ... filter and the recordset are two different things. ... ElseIf cmbFilter.Value = "Completed" Then ...
    (microsoft.public.access.forms)
  • Re: Help with Microsoft help on linking Access to Outlook
    ... in the criteria cell in the graphical query builder. ... use as the source in the routine. ... the same filtered recordset every time. ... choose themselves what fields to filter on. ...
    (microsoft.public.access.formscoding)
  • Re: Help with Microsoft help on linking Access to Outlook
    ... should build the SQL, using a query, then paste it into your code. ... the same filtered recordset every time. ... choose themselves what fields to filter on. ... Set MyRS = MyDB.OpenRecordset" ...
    (microsoft.public.access.formscoding)
  • Re: Help with Microsoft help on linking Access to Outlook
    ... and have the query point to the combo box to get its value. ... the same filtered recordset every time. ... choose themselves what fields to filter on. ... Set MyRS = MyDB.OpenRecordset" ...
    (microsoft.public.access.formscoding)
Loading