FilterForm via VBA

  • Thread starter Thread starter Don
  • Start date Start date
D

Don

I know I am close, I just don't have the quotes in the
right spot....

I have a button in which I want to apply a form filter
the Field I want to filter is called AssignedTo. I want
to filter it based upon a variable called ITTech stored in
the database

Me.Filter = "AssignedTo=" & ITTEch
'Me.Filter = "AssigedTo = 'ITTech'"
Me.FilterOn = True

I've tried single quotes, but then doesn't that use ITTech
as literal text (which of course I don't want)

Also....

Can I filter on two fields in code easily? Say,
AssignedTo = ITTech and Status <> "Resolved" ?

Thanks in Advance for any insight. I am enjoying learning
VBA, but am beginning to realize the importance of exact
syntax.

Don
 
Don said:
I know I am close, I just don't have the quotes in the
right spot....

I have a button in which I want to apply a form filter
the Field I want to filter is called AssignedTo. I want
to filter it based upon a variable called ITTech stored in
the database

Me.Filter = "AssignedTo=" & ITTEch
'Me.Filter = "AssigedTo = 'ITTech'"
Me.FilterOn = True

I've tried single quotes, but then doesn't that use ITTech
as literal text (which of course I don't want)
Click to expand...

If ITTEch is a text field...

Me.Filter = "AssignedTo='" & ITTEch & "'"
Me.FilterOn = True

Also....

Can I filter on two fields in code easily? Say,
AssignedTo = ITTech and Status <> "Resolved" ?
Click to expand...

Me.Filter = "AssignedTo='" & ITTEch & "' AND Status = 'Resolved'"
Me.FilterOn = True
 
I know I am close, I just don't have the quotes in the
right spot....

I have a button in which I want to apply a form filter
the Field I want to filter is called AssignedTo. I want
to filter it based upon a variable called ITTech stored in
the database

Me.Filter = "AssignedTo=" & ITTEch
'Me.Filter = "AssigedTo = 'ITTech'"
Me.FilterOn = True

I've tried single quotes, but then doesn't that use ITTech
as literal text (which of course I don't want)

Also....

Can I filter on two fields in code easily? Say,
AssignedTo = ITTech and Status <> "Resolved" ?

Thanks in Advance for any insight. I am enjoying learning
VBA, but am beginning to realize the importance of exact
syntax.

Don
Click to expand...
About the variable: By stored in the database do you mean in the
module? And what is the scope of the variable? Is it module level or
procedure level? And what is it's type?

Assuming the variable is of type text:
Me.Filter = "AssignedTo='" & ITTEch & "'"

Note I've put single quotes before the second double quote and between
the last 2 double quotes.

Yes you can use multiple fields for filtering. Think of it as an SQL
WHERE clause without the WHERE:

Me.Filter = "AssignedTo='" & ITTEch & "' AND Status <> 'Resolved'"

Note the single quotes again.

- Jim
 
Jim...

if it matters, ITTech is a Public variable I sotred in a module called Misc

Does this matter?
 
Forgive my silly question....

Is there a rule a thumb where I should use single quotes vs. When I use
double?
 
It only matters in terms of scope. A public variable is in scope for
the instance of the application. Unless a runtime error occurs - that
might cause it to be reset. But, no, type is most important.
 
I don't know of a single rule of thumb. To keep in mind: some strings
can include single or double quotes - O'Conner or 10' 45" - for
example.

You could use a Chr(34) instead to wrap your string values. Which
handles single quotes fine.

To manage single and double quotes you can wrap them in a constant for
double, double quotes. Like...

const cQuote="""" 'Thats two quotes

Me.Filter = "AssignedTo=" & cQuote & ITTEch & cQuote

- Jim
 
Back
Top