Hi, I've got a query without WHERE part. Is there any way I can add WHERE part
from code. I see there is filter property for form but what if I deal with
list box and it's corresponding query (record source). Can I use filter for
list box and how?
thanx
alek_mil
.
Re: Undocumented Filter? ... I think Tom was referring to the same movie I was, "Army of Darkness," ... I currently re-mask the SQL of the source query by taking a query I've set ... That solution gives me a Filter property for the query (since I'm working ... > That was not Bruce Campbell,... (microsoft.public.access.modulesdaovba)
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)
Re: Queries in VBA without SQL ... you can not use a query in a form's Filter property.... you can use a criteria such as: ... It seems wasteful to me to write a SQL... (microsoft.public.access.formscoding)
Re: How to re-populate DBgrid after doing a search ... You set the filter property of the query to the search condition or you open ... >> Run the same SELECT statement that you ran the first time.... (borland.public.delphi.database.ado)
