I was asked by a colleague if there was a way to discover what filters were on so I came up with this bit of code to flash the filtered columns:
Sub huntTheFilter2()
On Error GoTo Jumpout
FiltCols = 0
For Each filt In Worksheets(ActiveSheet.Name).AutoFilter.Filters
If (filt.On) Then...
checked out that 819017 but I've nothing listed there (and precious little in the way of USB devices - just a mouse). The machine is configured pretty well as when I got it in December (just a lot more on it). Also removing all my 'Network places' and disconnecting the network I still get it (I...
No success. I also tried raising this value further to 12000 as I counted 9800 folders (155,000 files - ok I play a few games...) but again no joy (incidentally the latest TweakUI does effect the same change in the registry). I even took it to 99999!.
I tried the removal of the zip service...
Just begun to experience the above problem (browsing My Computer in XP Home). In my ignorance I actually tried reducing the number of folders remembered to 100! (btw I think I did this using the newest TweakUI) - I'll be going home tonight to set it higher as suggested.
However I remember having...
I get a similar message 'You can't carry out this action at the present time' (I suspect it is actually the same).
I've had this problem ever since we were forced to move to Access2000 (the problem never ever appeared in Access97).
Basically I have a 'datasheet/spreadsheet' style subform which...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.