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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: notuserfriendly
  • Order by date
  1. notuserfriendly

    Autofilter error (multiple criterias)

    You're right about that, but since I kept getting errors I didn't find it too helpful although it helped, what I had a problem with then was using Ws. I kept on getting the same error. The last posted code did not work without errors. Tried to use Set Ws = Thisworkbook.Worksheets(SheetName)...
  2. notuserfriendly

    Autofilter error (multiple criterias)

    What I really had a problem with was doing it like this. I think, that's why I get the error. Want to use Ws because there are many sheets => less code. Dim Ws As Worksheet Set Ws = ThisWorkbook.Worksheets("Sheet4") If Ws.AutoFilterMode Then Ws.AutoFilterMode = False...
  3. notuserfriendly

    Autofilter error (multiple criterias)

    found it: http://www.contextures.com/xlautofilter03.html but: If ActiveSheet.AutoFilterMode Then ActiveSheet.AutoFilterMode = False End If
  4. notuserfriendly

    Autofilter error (multiple criterias)

    I noticed that the error emerges when filtering the second field. If I change the order of the filterings. It's always on the second filter that creates the error.
  5. notuserfriendly

    Autofilter error (multiple criterias)

    No It didn't help. Get the same error. Does the filter only work if you have a value after doing the first filter? Does one have to disable events or? Kind of clueless on this one
  6. notuserfriendly

    Autofilter error (multiple criterias)

    ...Is Nothing Then Rows("1:1").Select Selection.AutoFilter End If Selection.AutoFilter Field:=1, Criteria1:="<>*XX*", Operator:=xlOr, Criteria2:="<>*DG*" 'A2 && A3 Nonblanks Selection.AutoFilter Field:=2, Criteria1:="<>" Selection.AutoFilter...
  7. notuserfriendly

    Domains behind ip address?

    I suspected that it was kind of difficult but wanted to know if it was easier than I thought. Thanks
  8. notuserfriendly

    Domains behind ip address?

    Hi I'm wondering how to find out/get a list of all domains connected to a certain ip address, is this possible to do? /I
  9. notuserfriendly

    Updating window?

    Hi I'm wondering how to make Excel responding when it's in a sub or function. I've got a function that is supposed to handle up to 10 000 items. The problem is not calculating, the problem is that after a while Excel works kind of a lot and when using other applications at the same time...
  10. notuserfriendly

    Opening xls from a different version of Excel

    If Application.CalculationVersion <> _ Workbook.CalculationVersion Then Application.CalculateFullRebuild End If
  11. notuserfriendly

    Excel keeps crashing when spreadsheet is used

    The information you give doesn't say that much. Some code or adding more precise information would help a lot. For example do you open all worksheets when using the macro or does it open and refresh the queries automatically? 1) The combobox issue I really don't know, never had that problem...
  12. notuserfriendly

    Opening xls from a different version of Excel

    Hi I'm wondering how to cope with the question given by Excel to recalculate the formulas in the opened .xls (happens when an Excel workbook is opened by someone with a newer version of Excel). Do I have to remove alerts and open the file or is it some way to open the file and answer the...
  13. notuserfriendly

    set focus?

    Made it, seems as I missed .checked == true, don't get why it worked once but not in the rest of the loop.
  14. notuserfriendly

    set focus?

    allthough I just noticed that there's something strange in the loop. Since the code after the loop doesn't get executed. Btw it's else if. sorry for all the typos in the code.
  15. notuserfriendly

    set focus?

    Meant this actually works, (doesn't check anything though, but just wanted to see if it was possible), and it will be kind of ugly coding every week like this when I get to next year. document.getElementById('onv[45]').focus(); document.getElementById('onv[46]').focus()...
  16. notuserfriendly

    set focus?

    sorry it was something that happend when trying to make the code look nicer if(document.getElementById('onv['+week+']').checked) { document.getElementById('onv['+week+']').focus(); }elseif(document.getElementById('ofv['+week+']').checked) { document.getElementById('ofv['+week+']').focus(); }...
  17. notuserfriendly

    set focus?

    I came up with this and it almost works, there's only one problem, it only gets the element once. I've put alerts to check it and it only takes the first week. I.e onv43,ofv43 and elv43. startw=43 endw=52 for(week=startw; week<endw; week++) {...
  18. notuserfriendly

    set focus?

    I would like to be able to do something like this: if(strcmp($rowP["v$i"],"0") == 0 ){ $el = "checked onload=\"this.focus()\""; } echo "\t\t<td><input id=\"elv[$i]\" type=\"radio\" name=\"v[$i]\" $el onfocus=\"this.checked=true;hideReason(this.name);\" value=\"else\"></td>\n";
  19. notuserfriendly

    set focus?

    Thanks for the info! [1] Thanks for the advice, will make it easier to code :) [2] Don't know why, removed it :) [3] set it to true but no change [4] added type, had missed it, no change But unfortunately this doesn't solve my problem, which is to set focus on checkboxes depending on if they...
  20. notuserfriendly

    set focus?

    Hi I've got a form that is supposed to show an extra column field if the users makes the a certain choise, this is done by if(strcmp($rowP["v$i"],"1") == 0 ){ $on = "checked "; } echo "\t\t<td><input type=\"radio\" name=\"v[$i]\" $on onfocus=\"this.checked;hideReason('v[$i]');return false;\"...

Part and Inventory Search

Back
Top