Applying filters from VB

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

What I have here is probably a syntax problem, but as usual I can't find a solution looking through the help or ms website

I'm trying to apply a filter on a report from VB

I define the string I want as a filter and then pass it to the Me.Filter, and it works fine when I have one parameter, ex. my string i
myFilter = "myNumber = '1'
I'm trying to filter on two parameters, but I don't know how to tell Access, it always gives me a "operator absent" message

Thanks for the help.
 
-----Original Message-----
Hi,

What I have here is probably a syntax problem, but as
Click to expand...
usual I can't find a solution looking through the help or
ms website.
I'm trying to apply a filter on a report from VB.

I define the string I want as a filter and then pass it
Click to expand...
to the Me.Filter, and it works fine when I have one
parameter, ex. my string is
myFilter = "myNumber = '1'"
I'm trying to filter on two parameters, but I don't know
Click to expand...
how to tell Access, it always gives me a "operator absent"
message.
 
Wow, I'm having finger problems today. Sorry for double
post:

Me.Filter = "Number=1 AND Answer='Right Answer'"

Keep in mind, that numbers are not enclosed in quotes, but
strings are. Dates are enclosed in #'s.

Chris Nebinger

-----Original Message-----
Hi,

What I have here is probably a syntax problem, but as
Click to expand...
usual I can't find a solution looking through the help or
ms website.
I'm trying to apply a filter on a report from VB.

I define the string I want as a filter and then pass it
Click to expand...
to the Me.Filter, and it works fine when I have one
parameter, ex. my string is
myFilter = "myNumber = '1'"
I'm trying to filter on two parameters, but I don't know
Click to expand...
how to tell Access, it always gives me a "operator absent"
message.
 
Back
Top