Recent content by DanielUK

It works now. I had called the module the same as the function...ooops. Thanks for the help and to strogm for providing the module.

Thanks. I did that, it was the first change I made, but made no difference after debug and save. So whether Private or Public I get the same error message.

Thanks, I was rather hopeful but......I have that as a module in my database, saved and compiled but when I try to run it in a query I get the rather unhelpful 'Undefined function 'StripVAT' in expression'. Now other modules work e.g. basic string extraction ones so I am wondering if the code is...

Thanks for the replies. Yes, I would need to keep the end letters...unfortunately! That's why it became beyond my skillset, lol. Dan

Hi, Using Access 2000 I can find queries/modules to remove certain characters/alphanumerics etc from strings but I am looking for a combination and I am not smart enough to work it out! I have a list of alphanumeric VAT numbers from various countries which all start with a multi-lettered...

Hi, not a major problem but if I try to 'manage' any of our windows 2007 workstations from our 2008 Standard servers via Active Directory Users and Computers, although I can connect and see the event logs, if I try to look at Disk Management I get 'RPC server unavailable'. If I turn off the...

Hi, I've kind of answered my own question here. I deleted these GPOs and everything seems to be fine and hey presto, Windows firewall is now automatically off!

Hi, Last year I successfully migrated our SBS2003 domain over to a Windows 2008 Std server environment. Everything has been going swimmingly until I recently tried installing Spiceworks Network Monitor and found that it would not 'discover' any of my Win7 clients running AVG Internet Security...

Thanks again Shackdaddy, Unusually, I came in this morning to stop the SBS 2003 DHCP service and find the only DHCP service now running is the one on the 2008 Standard server, the one on the 2003 box has disappeared. As I haven't touched anything I'm wondering if somehow the 2008 DHCP...

Hi again, another quick question on this. I now have a successfully migrated DHCP database from the 2003 SBS server to one of the 2008 Servers. As I type, both (identical) DHCP services are authorised -is this bad? I was going to unaithorise the SBS DHCP service but want to make sure that once...

I reckon Dave likes Shredded Wheat but not sure if that's only available in the UK?

Thanks Dave, more graceful than I imagined! That last link is really useful too. I was going to seize the roles as a result of reading a post you made back in 2009: http://www.tek-tips.com/viewthread.cfm?qid=1529099 but since even 7 days is ample time then I'll transfer them. Dan

I have a small network of 17 PCs and an SBS 2003 server (no Exchange) with two additonal Windows 2008 Standard (version 1) domain controllers. The SBS server is being upgraded to 2008 Standard like the other servers. I'm planning on removing the SBS Server from the network and seizing the FSMO...

Thanks Vince, I'm not sure I understand so I'll need to clarify. I've checked the physical cabling and the office LAN socket that my PC is wired into ends up at Port 8 on the switch which is the mirror port. Are you saying it has to be DIRECTLY wired straight to that port and not via the...

OK, so I'm trying to spread the net a bit further so I'm including extra monitoring sources to be mirrored to port 8 (the prt with my PC on running wireshark in promiscuous mode). So far I have the ports monitored for: The Netgear router (default gateway) The SBS Server which is also the...