VBA to edit a Query Properties

K

Kit Truong

Hello,

Is there anyway that I can use VBA to modify the properties of a query.
Specifically, a criteria (where condition) a for a date field.

Thanks.

P.S. I know I can pass a filter when opening the query, but that's not what
I want to do.
 
V

Vincent Johns

Kit said:
Hello,

Is there anyway that I can use VBA to modify the properties of a query.
Specifically, a criteria (where condition) a for a date field.
Click to expand...

Short answer is "yes".

One of the properties you can manipulate is the Query's SQL. You can
replace all or part of that, including its "WHERE" condition.
Thanks.

P.S. I know I can pass a filter when opening the query, but that's not what
I want to do.
Click to expand...

OK, then maybe there's something else you want to do. What is it? If
you've already tried replacing the Query's SQL, what happened that you
disliked?

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.
 
Top