Wow, that was a long outage!
Is it too late to join the party?
Wow, that was a long outage!
Is it too late to join the party?
Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.
Consider yourself looted.
Tad sensitive point here in the UK at the moment ... and although it started in London, Manchester has had more than one could consider fair :-(
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Wow, I really do have some power... I just boosted 3 people into the next green light level.... awesome!
Hmmm.... what are you willing to do to get a similar boost?.... <devil's grin>
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Im in the UK, Manchester too!, don't be sorry, the mindless thuggery (lol is that a word) on the most part was simply because they could!, the police had their hands tied because they have to abide by some crazy stuff (not looking for a political debate here it's not the time or the place) and were over stretched 99.9% of the population are good law abiding citerzens and are appauled at what went on as well as horrified at what initiated the initial demonstration.
Last edited by Simon Lloyd; 08-12-2011 at 12:08 PM.
thuggery
Yup.
I understand why people (at times) must resort to protest and yes, even violent protest. In saying that, I don't understand the need for destructive protest against regular Joe Blow's and their homes and businesses! I am really at a loss when rioters riot over sporting events like Hockey or Football (soccer). The Vancouver riots this past spring were not a surprise to me because Vancouver has done this in the past over hockey but it is still confusing as to why.
Hmmm, not quite , i have my own ,posting avenues!
Last edited by Simon Lloyd; 08-12-2011 at 12:22 PM.
Andrew needs an Avatar.
"With great power comes great responsibility."
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Mordred/Dom: ... not that sensitive a point ;-) Simon's right - most people are safe, sane and sensible; the police have their hands tied behind their backs with their own handcuffs, and the sentences passed down on the bad boys and girls are, in the main, laughable.
But, enough with the heavy stuff ... let's just focus on the dire state of the forum :-))
TMS
In general finding humour in the whole thing is a good thing. It's what mostly makes us British (Scottish/English/Welsh/Northern Ireland'ish per previous thread)/human.
I've sadly recently lost a close family member and been really disappointed with what has gone on in England.
For every 'bad person' there's a hundred that want the world to be good
Last edited by Domski; 08-12-2011 at 06:18 PM.
I have noticed on all my computers that this website no longer fits on my screen, I have to scroll to the right to see what version of excel the OP is using.
@Dom, I am genuinely sorry for your loss. Reading Andy's blog really brought home a sense of mortality, which I sometimes forget about in this thing we call life.
i live 2 miles from croydon..we were gobsmacked!
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
ah but its worth 6 times what i paid for it ,only 20 mins from central london!
Pah, I live in beautiful Northumberland, where the air is clean, the water is fresh, you can buy a 3-bedroom wattle & daub hut for 2 goats and a bushel of grain, and where if anybody speaks with a London accent we burn them as a witch.
We didn't have riots here, but we nearly did last year when the council suggested that we adopt the Gregorian calendar.
You came pretty close yesterday at St. James' Park!
We don't have riots up here either, just the usual Saturdays' debates between the blue team and the green one, the flying bottles aren't what they seem, they are actually haggis in disguise.
Forum seems to have been working fine for the last couple of days?
Awwh! Don't say that, you are going to jinx it
Colin please be careful!!!!!
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
It's okay guys, I was touching wood when I wrote it!
That's good then - it was wood, not MDF or something?
I think the site is working exceptionally and I'm sure it will continue to do so. No errors here! Except for.....never mind because I don't want downtime because of me.
Fingers are crossed
Wood has been touched
Black cat has been shooed away
Ladder has been put on its side
4 leaf clovers have been found
and
I caught me a lucky leprechaun!
As everybody knows, being superstitious is a bad idea. It brings bad luck
And I'm back!!! I'd sulked for long enough and was bored at work today.
What more could you want?
Dom
I want a VLOOKUP formula that check 5 different ranges, works between set dates, returns the value into a cell which it formats according to the returned value and automatically pastes into the next available row.
And it can't take ages or run or be too long to type in (20 characters, max, please).
What? Isn't that what everybody here wants?
It's not me honest, I don't think
By the way congratulations on the promotion Mordred
Thanks Dom!
Ah, that old familiar friend the database error. How I've missed you! It's almost reassuring to know that you haven't gone away completely otherwise I'd only have football to moan about.
Dom
Now, who to blame, you, for coming back, or Colin for jinxing us!
Blame Colin!!!
I also get messages in my browser that there are errors in the page...
The loading of simple icons from twitter, facebook and others (who requested those ?) is slowing down the pageloading considerably. (I do not grasp the necessity to load those icons from all kinds of different servers; why not copying to the excelforum webserver ?)
It's so you can broadcast to the world how much you like all my posts snb
My friends think I'm already geeky enough without broadcasting all this on my Facebook/Twitter pages.
Dom
But to whom, Lewis, to whom ?It's so you can broadcast to the world how much you like all my posts snb
Funny, i don't see any twitter or facebook icons (other than the bookmark ones), i have them on my forums and it doesn't slow load...errr well i hope not
They're at the top of every page. Not sure when they arrived.
Dom
I'm not using the Child of 3.7.2 creation and I see the Twitter icon up above.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
I've always used the new style.
If those are the major improvements we've been looking forward to I'm underwhelmed to say the least.
Dom
For those who can't 'see'
You know I don't mean it
I think the owner is more interested in those social links for some reason than improving the overall forum. I don't think those were there before, because every time my mouse happens to cross over the "share" icon, i get at extended view showing all sorts of links!!
I sometimes wonder if the owner is interested in anything apart from collecting his advertising revenue.
Dom
Advertising revenue does pay the bills. However, it seems like it should be good practice to make sure that the product (this forum) is in good working order. I honestly think that it is the community here that keeps this forum going as well as it does. I don't mind these kinds of adverstisements as I can see them for what they are, it's the ones where you don't know they are adverstisements until you click on them that I don't like. Those kinds are full of Tom-Foolery!
Are there advertisements on this site? I never see any.
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
Try logging out.
Dom
Hmmm, logging out, that's a novel concept.
Nahhhh!
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Good to know our old friend the database error is still with us!
It popped up briefly from its' bunker in the desert at 10:35 this morning.
Any more sightings?
Last edited by Marcol; 09-02-2011 at 07:43 AM.
Yes ! at 11:51 GMT +1
I blame Ken Bates!!!
Blame Canada! - South Park
Most of us do Mordred
"They warned me Satan would be attractive" - Ned Flanders after meeting Canadian Ned Flanders.
New Issue: Seems that even if I click on the box to keep me logged in, the forum logs me out and whenever I return regardless of how long I have clicked away to another site, I have to re-login. Curious. Anyone else having this issue or is it just me. Perhaps a setting changed in my profile? Any thoughts?
Alan
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
@Alan: think it might be just you ;-)
@Alan, if you use a cookie cleaner, windows wiper or some such software you will experience that as the forums session is cookie controlled
@Simon: Not using a wiper/cleaner. This just starting happening this week on my WIN 7 machine. Appears not to be an issue on my XP machine. Does not happen with any other forums. Very strange.
Alan
In that case, it may well be a strategy of the owner to lower bandwidth usage and database errors!
AAArrrrgghh!!
Getting DBE when I try to view the "Who's Online" page.
It's the luck of the draw. Sometimes it works, sometimes it doesn't... we'll have to live with it until the "gods" fix it all up, in the very distant future.
Last edited by NBVC; 10-01-2011 at 08:58 AM. Reason: typo
The issue for 'mods' having issues with WOL can be easily fixed
I seem to remember the last time I reported this there was a major crash.
Lol!, you can make improvements yourself, in vBulletin Options>Who's Online Options then change this:
Who's Online Display Guests
Display Guest (non-registered user) activity on Who's Online?
To NO and see if it now loads faster for Mods with the other information still enabled, if it's not much better then you'd need to turn off the option below it too until someone repairs the template that displays the WOL information.
Hope that helps you
Last edited by Simon Lloyd; 10-01-2011 at 03:02 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks