Search:

Type: Posts; User: TheBionicOrange

Page 1 of 13 1 2 3 4

Search: Search took 0.35 seconds.

  1. Replies
    1,370
    Views
    98,910

    Re: Virtual Pub now open

    I've not seen daylight for years. Who locked me in?!
  2. Re: Gonna Stick my neck out here .... what the hell !

    ha ha ha yeah much ... thanks!
  3. Re: Gonna Stick my neck out here .... what the hell !

    Sadly . this is now true. I was in my early 30's when I started this thread! :(
  4. Re: Gonna Stick my neck out here .... what the hell !

    post race?
  5. Re: Gonna Stick my neck out here .... what the hell !

    I am curious as to why you resurrected this? Even more so if you never expected anyone to reply?!!?
  6. Re: Gonna Stick my neck out here .... what the hell !

    I might jsut do that :) Sure I had an account there once, when you first kicked it off. Will take a look later.
  7. Re: Gonna Stick my neck out here .... what the hell !

    It helps a lot. Hows MangoJacks doing these days ID ?
  8. Re: Gonna Stick my neck out here .... what the hell !

    Scary that I've aged 10 years since I started this thread!
  9. Re: Gonna Stick my neck out here .... what the hell !

    You trying to wake me from the dead?
  10. MsOf13 Pivot tables - Upon opening can you expand/maximise all the dimensions by default ?

    Hope that makes sense.

    Thanks a lot

    Steve
  11. MsOf13 Whittling down conversational view - Outlook 2013

    Afternoon all :)

    So I have this idea.

    I get a LOT of email. What I thought would be a good idea is if I could have a button, so if I clicked it it deleted all emails apart from the most recent...
  12. Outlook - Need to create a multiple/nested sort

    Afternoon all.

    Been about 10 years since I last posted here for help, but here goes :)

    I am creating a small snippet of code, that will sort my Inbox by sender. The view is that it will delete...
  13. Replies
    18
    Views
    1,339

    Re: Its been a while !

    You may well be right!
  14. Replies
    18
    Views
    1,339

    Re: Its been a while !

    Well to put into context, I changed jobs, moved 3 times, got divorced, now have another child, and a fresh new shiny mortgage.

    I would hanker for quiet right now!
  15. Replies
    18
    Views
    1,339

    Re: Its been a while !

    ha ha ha ... yeah c'mon BG .. I'm expecting the answer to be "chairs".
  16. Replies
    18
    Views
    1,339

    Re: Its been a while !

    I did see that starting to happen. Some of the old Chit Chat threads used to crack me up. Does Mendhak still post ?
  17. Replies
    18
    Views
    1,339

    Re: Its been a while !

    Hey ID .. yeah it feels like a loooong time, and so much seems to have happened since then too. Hows things with you ?

    In answer to your question .. ha ha .. I'm afraid I have. I never was...
  18. Replies
    10
    Views
    977

    Re: Does my old account still exist ?

    Cheers Si.

    You've answered many of my posts in the past. Maybe being just the other side of the bridge helped ;)
  19. Replies
    18
    Views
    1,339

    Its been a while !

    About 5 years to be exact, since I last used these forums.
    Peet ... the avatar you made for me is still going strong :)

    I recognise a few names of people who helped/put up with my requests back...
  20. Replies
    10
    Views
    977

    Re: Does my old account still exist ?

    Bingo .. I remembered it :)
  21. Replies
    5
    Views
    1,010

    Re: Unattended Execution parameter

    OK I will give this one last go .....

    I know you are aware of the "unattended execution" option.
    If you edit the .VBF file of a project in a text editor you can see it listed, with a value of 0...
  22. Replies
    5
    Views
    1,010

    Re: Unattended Execution parameter

    I am trying to work out how to turn the option on via code.
    At the moment I have a VB session open, and I am trying, by code, to set the Unattended Execution option to be on.

    Once I have cracked...
  23. Replies
    5
    Views
    1,010

    Unattended Execution parameter

    Does anyone know how to update the .VBP file of a VB6 project to have this option turned on ?

    Looking at the .VBP file, all the parameters are listed and I can see the one I want, but it has no...
  24. Clone a recordset but change the key ?!

    I have 17 records in a table, with a key of "10". I want to clone these, but have the key as "12", but keep all other field info the same.

    Using SQL, how would I do this ?

    insert into TableA...
  25. Replies
    1
    Views
    545

    Re: [2005]MDI forms question

    OK just realised i needed


    Form1.Show


    Now I just have to try and get the sizing right !
  26. Replies
    1
    Views
    545

    [2005]MDI forms question

    OK I tried holding off on asking this, but I just can't seem to find a solution, so now have to ask ...

    I have an MDI form called "MDIParent1". I have another form called "Form1".

    I am trying...
  27. Replies
    9
    Views
    750

    Re: Its finally happened !!!!!

    Yeah I am. Just getting my head around all the changes .. or trying to at least.
    I have heard by those that use it that it has come on leaps and bounds, so hopefully I will get to that frame of...
  28. Replies
    9
    Views
    750

    Re: Its finally happened !!!!!

    ha ha ha ... the same thought crossed my mind too !
    I can't believe how different it all is. I need to get up to speed quick !
  29. Replies
    9
    Views
    750

    Re: Its finally happened !!!!!

    Sorry .... has "show all settings" turned off !
    Doh !

    Apologies !

    Thanks JohnPolo.
  30. Replies
    9
    Views
    750

    Re: Its finally happened !!!!!

    I don't. After extending "Environment" I only have "General" and "Fonts and Colours". There are o pull down boxes or anything relating to startup in either.
  31. Replies
    9
    Views
    750

    Re: Its finally happened !!!!!

    Sorry .... couldn't find anything under Tools/Options called "Help", let alone anything else.

    Looked in the "Help" pulldown menu and couldn't find anything called "Startup" either.
  32. Replies
    9
    Views
    750

    Its finally happened !!!!!

    I have finally switched to .NET (2005 to be more precise).

    And here comes the first question of undoubtedly many ..... can I turn off the start page ? It causes an annoying lag as it connects to...
  33. Replies
    20
    Views
    10,091

    Re: Excel FIND function

    Scroll up ... thats already been mentioned.
  34. Replies
    20
    Views
    10,091

    Re: Excel FIND function

    Yeah I did that.

    Net result .... 5 seconds.
    The idea Mitch came up with took about 12, which was WAY better than what I had, but now I have halved that again then this is the one I will use.
    ...
  35. Replies
    20
    Views
    10,091

    Re: Excel FIND function

    All values ONLY exist in the first column.

    Now trying out your code ...
  36. Replies
    20
    Views
    10,091

    Re: Excel FIND function

    Mitch you were right, once I limited my range to just the one column it WAS a lot quicker. There are occurences of the text I need all over the place, but lucky for me they all start in the same...
  37. Replies
    20
    Views
    10,091

    Re: Excel FIND function

    Yeah it would be 2 seconds for me too, on a worksheet that doesn't contain the phrases, or had hardly any occurences of them.
    You have raised a point though. The occurences ARE in the same column,...
  38. Replies
    20
    Views
    10,091

    Re: Excel FIND function

    Bear in mind this code IS super quick if there are next to no occurences, but in my workbook there are plenty.
  39. Replies
    20
    Views
    10,091

    Re: Excel FIND function

    I think I might be in trouble if I did. There is an awful lot of confidential info in it. I notice your code works on one column, whereas mine works on 26, and also I am trying to colour the entire...
  40. Replies
    20
    Views
    10,091

    Re: Excel FIND function

    Thanks for replying Mitch. I tried your code out, but it doesn't seem to haev made it any faster unfortunately. I know the max number of rows is going to 5000, so based on that I have the following...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width