Presuming the data above is on sheet1 then

On the stats sheet in column AF:

=IF(Sheet1!C3<(TODAY()-7),IF(Sheet1!F3=1,Sheet1!B3,”Not 1 in col F”),”NotOld”)

Above formula will tell you why it is not returning value of B, you may want to get rid of these bits

I went with the Sonos and NAS solution. Brilliant, easy to setup and use. Controlled from phone/tablet/pc and not that expensive.

You don’t need to buy all at once as its all modular.

This the one?

EDIT Or this one

Just been and registered. Fairly small expo, largest part is funnily enough the Ride London souvenir stand.

Found a certain Laura Trott who was being interviewed on stage more interesting than the expo.

Was pretty empty but I guess to be expected on the Friday morning.

Rider No: 19293 Red & White Trek 1.7. Heading off to the Excel shortly to register.

start time is 6.54

Me too. Race ? :)

I’m doing the 100 on the Sunday, really looking forward to it.

Swim twice a week,
Bike twice a week
Do the couch to 5K run program then build up to 10K+

4 months before your event maybe do a structured training program.

Just to clarify you only need to change the sent from name, you are not worried about the actual return address?

Presuming so then as above simply changing the Display Name and restarting the service is all you need to do.

Having NO joy in amending simple display names, aliases or even amending x.400 entries

Presumably you tried all this on a test system? How about starting again with fresh test environment and amending just the display name as suggested above. If that does not work then you have issues.

Edit: If no joy I might also be tempted to delete the local mail profile, shouldn’t really matter but……..

Until your DB size reaches 10GB SQL Express should be fine, IIRC as part of the Act! install it will ask if you want to install SQL Express.

How many users, and which version of Act! SQL Express(Free) is an option for some installs.

I go to Ponton, down to Steeple Morden, nasty 1/4 mile on A 505, then Rushden, Walken,Watton then Hertford.

After this depends where in London you need to be

RE:Trains IIRC There were fast and slow trains, slow trains took about 30 minutes longer but were half the price. Cannot recall exactly how much it cost but definitely cheaper than equivalent train journey here.

We went with Amtrak from Penn station

We did similar, flew into NY and out of Boston took the train to Boston then picked up car from there.

For scenery a couple of days based in North Conway – Horrible place basically one long row of shops but cheap motels and next to the White Mountains/Mount Washington, Drive the Kancamagus Highway, Flume Gorge/ Franconia Notch all nearby, as above the foliage should be impressive at that time of year.

For Coastline Maine will tick all the boxes, visit some of the lighthouses and eat loads of seafood.

To the south of Boston Cape Cod is very nice as is Provincetown. The Mansions in Newport are nice and you can do a cliff walk around the back of some although only worth a day visit IMO.

Alternatively just drive up though New Hampshire, Vermont and Maine and see what you find, accommodation will be plentiful and cheap (outside main cities)

edit: The area around Dartmouth College is rather nice.

Is an nslookup on google.com returning correct ip?

What error is he getting?

What browser is he using?

Garmin communicator can have a few issues with later versions of IE

Yes, it is pretty bad but you can load GPX files into it.

I have been looking at getting these wheels, from what I can gather they come with an additional spacer to use with a 10 speed cassette. Apologies if this is the spacer you mention above?

Holyzeus – Member

Triton Cycles, Barkingside

Are they still open, last few times I have been past the shutters have been closed.

How about Biketrax in Wansted

i know in server 2003 you had Per Device or Per User Per Server and if you didnt get that correct it would play up in a similar way…

Are you sure about that? I have been using server 2003 for about 9 years, we have Cals but none of them are installed and our 80 users connect to network shares just fine. I believe this is the same in 2008.

I have no knowledge of server 2012.

OP: rather than logging in/off again

can you access the share still from \\server\sharename

How about going to \\dcname\netlogon and re-running the bat file?

The OP can not prove that he didn’t break the seal although he has a history of breaking his equipment. The OP can not prove that the battery wasn’t sealed when new, all batteries are.

Presume you are not thinking of a career in PR should your lights business fail?

Seriously. Regardless of wrong/right you are not coming across very well.

Could you not just buy another wireless AP/Bridge and plug that directly nto TV with cat5

EDIT: Too slow. Can you get a wiFi dongle for your TV?

London has a huge range of abilities riding all sorts of bikes. As you currently train 6 days a week you will need to practice overtaking people while aero:)

Do you know if you are doing the Westminster or Tower Bridge route? If the latter it is about 5km short.

My first board in 83 was a circle one pop out about 6ft IIRC, soon traded it in for 5ft 8 quad fin thing. I’m also not surf Matt that was just the fashion back then.

Talking of fashion, back then Circle One were never in vogue in Exeter, Underground was the in brand followed by Hot Moves (both now defunct)

Think you might be struggling at 2k for 4 people in August

They might be sending traffic to your IP, but they would only ever get to your website if your website was setup to accept it. So someone types in the address, it goes to your server, and your server (IIS) checks to see what it’s meant to do with that address.

Default IIS single site accepts all traffic unless you start playng wiht hostheaders

Alternatively you could setup a dummy 404 page or similar as a new website and use a hostheader to direct traffic there.

If i was to do it the lazy way…..

1 – New server arrives
2 – Shut down existing old Poweredge 800 (the DC)
3 – Set-Up the NEW server as the DC, giving it a brand new DOMAIN name, install AD, DNS etc etc.
4 – Set-up all users again on the new AD
4 – Go to all PC’s join NEW domain.

You should also configure another machine with following roles DC, DNS, DHCP (if you use it) and GC then should your new machine die your network will still function correctly

What is your current domain 2003?

With 23 users and 50 shares I would be v tempted to just go for a brand new 2012 Domain, doesn’t seem like it would be too much work. There is a lot to be said for a nice clean AD.

=IF(LEN(G1)>0,AVERAGE(B1:G1),AVERAGE(A1:F1))

too slow. +1 what stevomcd says

Flickr allows various privacy controls and would fulfill your requirement.

I cannot even get the link to registartion to work

Yes, aiming for Chatel start on the Saturday

I believe some of the skiers returning back from European destinations are finding the new wave of tourists from the Eastern bloc quite hard going too.

Courchevelski and all that

If your Sonos device is near enough to router to plug in then you will not need to bother with a bridge.

“I believed in julie when she said how easy it could be”

With the Sonos amp I would presume you can use any speakers?

Not used their crm but Zoho probably worth a look, some of their other services are very good.

Not sure how expensive off the shelf solutions are but we built our own system about 10 years ago using this hardware [/url]

Means the system does what we went and we have been able to adapt over time.

Running costs are now just the cost of data.