Search:

Type: Posts; User: zaza

Page 1 of 13 1 2 3 4

Search: Search took 0.66 seconds.

  1. Replies
    2
    Views
    2,365

    VS 2017 Re: Treeview AfterLabelEdit and Sort

    Thanks jmc. There's also some funny business when you change the node.name too. Wrapping the whole thing with the ignore does seem to avoid the random re-labelling issue.
    I still get the begin-edit...
  2. Replies
    2
    Views
    2,365

    VS 2017 [RESOLVED] Treeview AfterLabelEdit and Sort

    Trying just to allow a user to edit a label, and when they're done the treeview sorts alphabetically. Sounds simple, right?

    I find that a) it always begins editing the first node on the list after...
  3. Replies
    4
    Views
    2,444

    Re: Turn off KeyTips in Office 07

    Really? Put your left thumb on Alt, your left middle-finger on E and your ring finger on S. Then just roll them from thumb to ring as quickly as you can. Obviously you need to have something on the...
  4. Replies
    9
    Views
    19,492

    Re: Coordinates, Vectors and 3D volumes

    These are just general coordinate transforms, so they will work between any two coordinate systems howsoever defined.

    If you were to use them to define both your "world" system and your "user"...
  5. Replies
    4
    Views
    2,444

    Turn off KeyTips in Office 07

    Not a programming question, more of a functionality question. Does anybody know if and how one can turn off KeyTips in Office 2007?

    KeyTips are the letters that pop up above menu items when you...
  6. Re: Quick! Someone sum up the last 6 years of ChitChat history!

    visualAd and his spleen

    wossname and his grumpiness

    NoteMe and his bad speeling

    mendhak and SandPaper, Frogect Rotamiton, etc

    oceanebelle and hairball, the token girls
  7. Replies
    22
    Views
    2,098

    Re: Odd Round behaviour

    Well, I stand corrected.

    It does this in Office 2002 as well. I am quite surprised, but I guess it goes to show that it isn't as common an occurrence as I had feared.

    Cheers chaps.
  8. Replies
    22
    Views
    2,098

    Re: Odd Round behaviour

    Yes, what I mean is that in any given operation which gets an evaluation, the default output is Integer unless there is something in the operation to coerce it differently.

    So in your example,...
  9. Replies
    22
    Views
    2,098

    Re: Odd Round behaviour

    It works if there's anything in the operation that is classed as Long. Doesn't matter where it is.

    I don't have an older version of Office on this PC but I'm almost certain that this has changed;...
  10. Replies
    22
    Views
    2,098

    Re: Odd Round behaviour

    Indeed, it is definitely the actual calculation rather than the dimensioning of the variable. What seems odd to me is that this code:


    Public Sub test()
    Dim x As Integer
    Dim y As Long
    ...
  11. Replies
    22
    Views
    2,098

    Re: Odd Round behaviour

    Also, MSDN claims here that integer data types really no longer exist and that they are all Long behind the scenes, irrespective of how they are declared.
    Maybe they meant that they are converting...
  12. Replies
    22
    Views
    2,098

    Re: Odd Round behaviour

    Right, I think I understand what's going on here but not why.

    The following will break:


    Public Sub test()
    Dim x As Long
    x = 1
    Debug.Print 32767 + 1
    End Sub
  13. Replies
    22
    Views
    2,098

    Re: Odd Round behaviour

    No, that still breaks.

    Slightly worryingly, this also breaks with an overflow error:


    Public Sub test()

    Dim x As Long
    x = 1600 * 21
  14. Replies
    22
    Views
    2,098

    [RESOLVED] Odd Round behaviour

    Something odd I've noticed in VBA.

    If you evaluate Round(16 * 1000/100,1) you will get 160.

    If you do Round(16 * 10000/1000,1) you will generate an overflow exception.

    If you put a tiny...
  15. Replies
    1
    Views
    814

    MsOf10 Re: Ontime from class module

    Found an answer. You call the macro in single quotes within the double quotes, and double-double the parameter.

    So:

    Application.OnTime Now()+TimeValue("00:00:05"), " ' MyMacro ""MyParameter""...
  16. Replies
    1
    Views
    814

    MsOf10 [RESOLVED] Ontime from class module

    Does anybody know how to run a macro using OnTime in Excel VBA that's in a class module rather than in a standard code module?
    Or, alternatively, to pass parameters to the proc?

    In summary, I...
  17. Replies
    10
    Views
    1,675

    Re: Microsoft's Magic !!!

    Somewhat late to the party, I'm afraid, but on the topic of absurd translations into Wingdings I wondered what you get if you type AL QAEDA.

    Answer:
    - Towers :(
    - Plane
    - Two towers down
    -...
  18. Replies
    13
    Views
    3,463

    Re: My brilliant idea- the Yotamarker

    Well, that depends on a number of things. One is the remit of the patent. US only, Europe only, Asia only, worldwide etc. Another is validity of use...you don't patent a name but an idea. If you're...
  19. Replies
    13
    Views
    3,463

    Re: My brilliant idea- the Yotamarker

    Applying and granting are not the same thing.... :afrog:
  20. Replies
    13
    Views
    3,463

    My brilliant idea- the Yotamarker

    I've had a great idea for a website and mobile app. It's going to be amazing.
    The idea is that using your mobile phone, you take a photo of some really cool stuff that you find in shops, like woolly...
  21. Re: Differences when querying between Access and Excel

    The name isn't actually QUERY, that was just for illustrative purposes. The thing is that there's nothing populating the database, all that's in there is a load of links to files (which define the...
  22. Differences when querying between Access and Excel

    I've inherited an Access db which is used as the source for a dataset in Excel. Excel connects using ADO and Jet.OLEDB and runs a simple select:

    SELECT
    QUERY.A, QUERY.B, QUERY.C, QUERY.D
    FROM...
  23. Thread: bin Laden is dead

    by zaza
    Replies
    93
    Views
    6,285

    Re: bin Laden is dead

    Parental problems? Or was that deliberate....?
  24. Replies
    41
    Views
    4,416

    Re: plasma

    Rob a hospital and steal all their thermometers.
  25. Thread: Pi is wrong

    by zaza
    Replies
    16
    Views
    3,860

    Re: Pi is wrong

    Nah, Pi is probably one of the earliest introductions in one's life to a fundamental constant. I reckon adding a factor of 2 in there is just bodging and fiddling.

    Besides, there's actually...
  26. Thread: Pi is wrong

    by zaza
    Replies
    16
    Views
    3,860

    Re: Pi is wrong

    Speaking as a physicist, rather than a mathematician, I would point out that the area of a circle isn't a "square law", and you can't really go comparing it to the formulae for KE, springs etc....
  27. Thread: bin Laden is dead

    by zaza
    Replies
    93
    Views
    6,285

    Re: bin Laden is dead

    Presumably you mean except the first Gulf war, in which the US was a direct participating party, or where they had a very definite presence in many others such as the Balkan war, the Somali civil...
  28. Replies
    15
    Views
    6,577

    Re: Happy Birthday zaza

    It was certainly the most recent.
  29. Replies
    15
    Views
    6,577

    Re: Happy Birthday zaza

    Thank you. But no, no relationship with zoozoo I'm afraid.

    http://www.youtube.com/watch?v=_0LhWTIos28
  30. Thread: bin Laden is dead

    by zaza
    Replies
    93
    Views
    6,285

    Re: bin Laden is dead

    Bet it won't stop one from having to take off one's shoes for the scanners at the airport.
  31. Replies
    3
    Views
    611

    Re: If ... AND ... then problems

    Just to be clear, this sort of statement runs as follows:

    IF (evaluation to True or False) OR (evaluation to True or False) THEN ...


    so you are saying:

    IF (ActiveCell.Value = TempO) OR...
  32. Poll: Re: will true ogre be in Street Fighter X Tekken ?

    Like moti without yotamarker...?
  33. Thread: Libya

    by zaza
    Replies
    122
    Views
    10,438

    Re: Libya

    Well, from their perspective, they were not the ones who did the attacking first. That is the point which you seem to have missed. In their opinion, a bunch of chaps showed up after WWII, said...
  34. Thread: Libya

    by zaza
    Replies
    122
    Views
    10,438

    Re: Libya

    I would probably go with the definition as laid down by the Office of the United Nations High Commissioner for Human Rights. No mention of eating in front of other people there, although if you...
  35. Replies
    1,154
    Views
    388,409

    Re: artificial intelligence

    Maybe the yotamarker could send her own requests...?
  36. Replies
    3
    Views
    648

    Re: Zaza .. Here's one for you.

    No. I own a Toyota.

    I think you should henceforth be renamed visualAd;

    Semicolon is the only appropriate form of punctuation for you.
  37. Thread: Libya

    by zaza
    Replies
    122
    Views
    10,438

    Re: Libya

    You aren't going to suggest that murder, rape and paedophilia are "bad" crimes worthy of killing a "bad" person, but torture isn't... are you? I reckon you would find a lot of people across the world...
  38. Thread: Libya

    by zaza
    Replies
    122
    Views
    10,438

    Re: Libya

    Some say that a lot of the troubles in the Middle East are because the Jewish people displaced a load of Palestinians and have since been killing and torturing them on a daily basis for 50 years....
  39. Replies
    52
    Views
    3,203

    Re: What price Freedom in the USA

    I have travelled to the States with a large Pakistani visa in my passport. They actually didn't seem to mind that.
  40. Thread: Libya

    by zaza
    Replies
    122
    Views
    10,438

    Re: Libya

    What about 100? Or 1 million? Is there a limit, or is the general idea that one should prefer to kill an unlimited number of bad men rather than 1 innocent man?







    What if the bad men are...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width