Re: Undocumented Filter?

Tech-Archive recommends: Speed Up your PC by fixing your registry

Klatuu,

I think Tom was referring to the same movie I was, "Army of Darkness,"
starring Bruce Campbell. What I am coming to realize is that AoD must have
paid homage to tDtESS in having Bruce's character have to remember that same
line from tDtESS. So, the line is in both movies, you are just referencing
the original movie, while I did not know that was the source for the AoD line.

BTW, I appreciate your proposed solution, but I have to take into account
the fact that the user might be filtering on multiple fields for different
values. In order to account for them all, each of the fields of each query
would have to be represented in a combobox, and that would just get messy.

I currently re-mask the SQL of the source query by taking a query I've set
aside for this task and rewriting the SQL property...

set qd = currentdb.querydefs("DynamicQuery")
qd.SQL = "SELECT * FROM [" & me.cboEnabledQueries & "]"

That solution gives me a Filter property for the query (since I'm working
with a SELECT query again), but that solution necessitates re-writing the
Filter property:

qd.Filter = qd.fields(0) & " Like *"

....and the OrderBy property, etc.

That gets to be a problem when I have a parameter in the query, too. All in
all, when I change from viewing one query to viewing another that has
parameters, I end up getting prompted 4 or 5 times for the same parameter. It
works, but it is very messy.

If I could just get beyond the crosstab query not having a filter property,
and get at the filter wherever it is being used, I could go away from the
DynamicQuery remasking the SQL, and just show the crosstab query itself.

Anyway, if you have more input, I will continue to follow this thread.
Otherwise, I will post back when I find an adequate solution. I have been
fighting this for so long... I feel like I'm trying to get a 4-bolt rim for a
car tire onto a 5-bolt axle. Things just don't line up in all places at once.

Thanks again.

"Klatuu" wrote:

> That was not Bruce Campbell, it was Micheal Rennie. The movie was made in
> 1951. Bruce Campbell was born in 1958 (June 22 to be exact)
> There is debate on what the phrase actually meant. Some will agree with
> you, others say it means "come get me"; however, I think he said "Never use
> GoTo"
>
> "Tom Lake" wrote:
>
> > > BTW, any reference to a Bruce Campbell movie in your nickname, "Klatuu"?
> >
> > The phrase that Campbell had so much trouble with (Gort, Klatuu barada
> > nikto) is a quote from the movie, The Day the Earth Stood Still. It was an
> > phrase given to Patricia Neal to pass on to the robot, Gort, telling him
> > that Klatuu didn't want him to level Washington D.C. (and possibly the rest
> > of the world!)
> >
> > Tom Lake
> >
> >
> >
.

Relevant Pages

  • Re: Creatinig a database to update in alphabetical order
    ... You can then create a Query which takes all of the records in the ... Some attributes of a movie would be the Title, the studio, ... MovieID Autonumber Primary Key ' links tables together ... Keyword ...
    (microsoft.public.access.gettingstarted)
  • Re: Creatinig a database to update in alphabetical order
    ... John M. it is like you are reading my mind, ... know I am a movie fanatic. ... > should not be routine) displayed as a query datasheet. ... > Keyword ...
    (microsoft.public.access.gettingstarted)
  • Re: SQL Ignorance
    ... It's an informal home user record of his own movie watching ... He's asked me to write a particular query, ... (tblActor.ActorID in the Actor Table,) ... Shirley Temple, Clint Eastwood, Rowan ...
    (comp.databases.ms-access)
  • Re: FormFilter with SQL
    ... I don't think your query is doing what you think it is. ... Group By clause is only performing a DISTINCT operation ... Maybe you intended to use an INNER JOIN to only get the bus ... >>>I copied the SQL into the Filter property but got a "syntax error - ...
    (microsoft.public.access.formscoding)
  • Re: Applyfilter works, sometimes
    ... Don't you think it is odd that using applyfilter you can have a string up to ... set the filter property of the form instead that at 1800 characters it fails. ... What is the form based on: a straight table, a query of a single ... As a work around I tried to set qFilter to the ...
    (microsoft.public.access.formscoding)