ApplyFilter

  • Thread starter Thread starter Barry Shadduck
  • Start date Start date
B

Barry Shadduck

Hello,

Trying replace hard code "Telecom & Network Mgt" by
reading it from a file and placing it into the ApplyFilter
command line.

Hard code example:
DoCmd.ApplyFilter "[LOC] = ""Telecom & Network Mgt"""

Want to replace hard code with
DoCmd.ApplyFilter "[LOC] = " & coord![LOC]

Any one know the syntax for this, double quotes, single
quotes, bars, or what??????????????

Thanks
 
Thanks Ken! Works like a charm!
-----Original Message-----
DoCmd.ApplyFilter "[LOC] = '" & coord![LOC] & "'"

--

Ken Snell
<MS ACCESS MVP>

Hello,

Trying replace hard code "Telecom & Network Mgt" by
reading it from a file and placing it into the ApplyFilter
command line.

Hard code example:
DoCmd.ApplyFilter "[LOC] = ""Telecom & Network Mgt"""

Want to replace hard code with
DoCmd.ApplyFilter "[LOC] = " & coord![LOC]

Any one know the syntax for this, double quotes, single
quotes, bars, or what??????????????

Thanks
Click to expand...


.
Click to expand...
 
You're welcome.

--

Ken Snell
<MS ACCESS MVP>

Barry Shadduck said:
Thanks Ken! Works like a charm!
-----Original Message-----
DoCmd.ApplyFilter "[LOC] = '" & coord![LOC] & "'"

--

Ken Snell
<MS ACCESS MVP>

Hello,

Trying replace hard code "Telecom & Network Mgt" by
reading it from a file and placing it into the ApplyFilter
command line.

Hard code example:
DoCmd.ApplyFilter "[LOC] = ""Telecom & Network Mgt"""

Want to replace hard code with
DoCmd.ApplyFilter "[LOC] = " & coord![LOC]

Any one know the syntax for this, double quotes, single
quotes, bars, or what??????????????

Thanks
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top