Search:
Type: Posts; User: TheBionicOrange
Search:
Search took 0.35 seconds.
-
I've not seen daylight for years. Who locked me in?!
-
ha ha ha yeah much ... thanks!
-
Sadly . this is now true. I was in my early 30's when I started this thread! :(
-
-
I am curious as to why you resurrected this? Even more so if you never expected anyone to reply?!!?
-
I might jsut do that :) Sure I had an account there once, when you first kicked it off. Will take a look later.
-
It helps a lot. Hows MangoJacks doing these days ID ?
-
Scary that I've aged 10 years since I started this thread!
-
You trying to wake me from the dead?
-
Hope that makes sense.
Thanks a lot
Steve
-
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...
-
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...
-
-
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!
-
ha ha ha ... yeah c'mon BG .. I'm expecting the answer to be "chairs".
-
I did see that starting to happen. Some of the old Chit Chat threads used to crack me up. Does Mendhak still post ?
-
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...
-
Cheers Si.
You've answered many of my posts in the past. Maybe being just the other side of the bridge helped ;)
-
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...
-
Bingo .. I remembered it :)
-
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...
-
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...
-
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...
-
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...
-
OK just realised i needed
Form1.Show
Now I just have to try and get the sizing right !
-
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...
-
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...
-
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 !
-
Sorry .... has "show all settings" turned off !
Doh !
Apologies !
Thanks JohnPolo.
-
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.
-
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.
-
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...
-
Scroll up ... thats already been mentioned.
-
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.
...
-
All values ONLY exist in the first column.
Now trying out your code ...
-
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...
-
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,...
-
Bear in mind this code IS super quick if there are next to no occurences, but in my workbook there are plenty.
-
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...
-
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...
|
Click Here to Expand Forum to Full Width
|