User Profile
Collapse
-
can you please tell me how to use the query window... -
I removed all filter code from the form
but still i can not see the data in the form
this form displays the list for componets
which it collects from this query
Private Sub Query_Switch()
Dim the_query As String
the_query = _
"SELECT R35_PFUS_Annex. *, R21Components.C omponentName, " & _
" R21Components.C omponentCount, R21Components.R emark,...Leave a comment:
-
I am inserted the
Me.filter = " "
in the Private Sub Form_Load()
Private Sub Form_Open(Cance l As Integer)
but still i am facing the same problem
and also the form includes a sub
Private Sub Btn_Filter_off_ Click()
fi_cnt = fi_cnt + 1
Me.Filter = ""
Me.Btn_Filter_o ff.Caption = "Filter_off " & fi_cnt
...Leave a comment:
-
Handling filters in Ms Access 2000 forms
Hi,
I am working on a form which currently does not show data after it has opened.
but i can see the data only when i remove the filters from the form, after opening the form
form displays the componet list which it get from the query.
the problem is
that i have not introduced any kind of filters in the form
in fact in on load and on open properties i inserted ...
No activity results to display
Show More
Leave a comment: