Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ServerFilter

Status
Not open for further replies.
GammelNok

GammelNok

Programmer
Jun 21, 2002
32
US
Hi
I am trying to get over the Docmd.ApplyFilter problem in my adp database, backended to SQL2000.

The following code does not filter my form

any ideas welcome

Private sub cmdLeft_Click()
Me.ServerFilter = ""
Me.ServerFilter = "teamEmpStatus = 'Left'"
Me.ServerFilterByForm = True
end sub
 
Sort by date Sort by votes
I did that on an App, but don't have it with me.

I believe I did.

ON OPEN Event of Form
Me.AllowFilters = True
Me.FilterOn = True
Me.ServerFilter = "teamEmpStatus = 'Left'"
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

198311
  • Locked
  • Question
ServerFilter
Replies
1
Views
82
cmmrfrds
cmmrfrds
batteam
  • Locked
  • Question
Question on ServerFilter property 1
Replies
1
Views
72
cmmrfrds
cmmrfrds
sophieK
  • Locked
  • Question
Problem with serverFilter
Replies
5
Views
103
dwight1
dwight1
Fubear
  • Locked
  • Question
ServerFilter Automatically Saving 2
Replies
3
Views
121
Nowell
Nowell
bugs75
  • Locked
  • Question
BuildCriteria and ServerFilters
Replies
0
Views
79
bugs75
bugs75

Part and Inventory Search

Sponsor

Back
Top