M
Mark Andrews
I am attempting to use the datasheet functionality in Access2007.
When a user either filters the datasheet or sorts the datasheet the
Form_ApplyFilter event is called.
I have code:
Private Sub Form_ApplyFilter(Cancel as Integer, ApplyType as Integer)
Me.cmdShowAll.Visible = True
end sub
The idea is after filtering the form will show less than all the records (at
least the majority of times with filtering). When this happens I display
the button that lets the user SHOW ALL records.
However if the user just SORTS this same event is called.
What would be the best way to NOT SET my cmdShowAll button to visible?
Coudl I capture before and after filter and orderby properties somehow
etc...?
Thanks in advance,
I couldn't think of an easy way,
been a tough day and my brain is not working so well,
Mark
When a user either filters the datasheet or sorts the datasheet the
Form_ApplyFilter event is called.
I have code:
Private Sub Form_ApplyFilter(Cancel as Integer, ApplyType as Integer)
Me.cmdShowAll.Visible = True
end sub
The idea is after filtering the form will show less than all the records (at
least the majority of times with filtering). When this happens I display
the button that lets the user SHOW ALL records.
However if the user just SORTS this same event is called.
What would be the best way to NOT SET my cmdShowAll button to visible?
Coudl I capture before and after filter and orderby properties somehow
etc...?
Thanks in advance,
I couldn't think of an easy way,
been a tough day and my brain is not working so well,
Mark