Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. DanielUK

    VAT numbers and string extraction

    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.
  2. DanielUK

    VAT numbers and string extraction

    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.
  3. DanielUK

    VAT numbers and string extraction

    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...
  4. DanielUK

    VAT numbers and string extraction

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

    VAT numbers and string extraction

    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...
  6. DanielUK

    RPC server unavailable if Windows Firewall on, ok if off?

    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...
  7. DanielUK

    Legacy GPOs from SBS2003 to Windows 2008 Std -removal OK?

    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!
  8. DanielUK

    Legacy GPOs from SBS2003 to Windows 2008 Std -removal OK?

    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...
  9. DanielUK

    DHCP on additional 2008 DC on SBS 2003 domain prior to FSMO seize

    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...
  10. DanielUK

    DHCP on additional 2008 DC on SBS 2003 domain prior to FSMO seize

    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...
  11. DanielUK

    DHCP on additional 2008 DC on SBS 2003 domain prior to FSMO seize

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

    DHCP on additional 2008 DC on SBS 2003 domain prior to FSMO seize

    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
  13. DanielUK

    DHCP on additional 2008 DC on SBS 2003 domain prior to FSMO seize

    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...
  14. DanielUK

    HP Procurve 2650 and wireshark

    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...
  15. DanielUK

    HP Procurve 2650 and wireshark

    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...
  16. DanielUK

    HP Procurve 2650 and wireshark

    Hi, connected via telent and got: ProCurve Switch 2650# show monitor Network Monitoring Port Mirror Port: 8 Monitoring sources ------------------ 45 However I don't seem to see any internet bound traffic coming from that port, the ip address that is "busy" is my own. Am I missing...
  17. DanielUK

    HP Procurve 2650 and wireshark

    Thanks for the response, this is using the CLI, right? I've just been using the web interface so far. I'll see about luiniking it up to a PC so I can telnet in, run the command and report back. And yes, wireshark is in promiscuous mode.
  18. DanielUK

    HP Procurve 2650 and wireshark

    Hi, I'm not sure if I've understood port monitoring with my 2650 but if I want to monitor outgoing traffic via our Netgear router connected to the switch and: the Netgear router is on port 45 my PC running wireshark is on port 8 Then I thought I could make port 8 the "monitoring port" and...
  19. DanielUK

    Windows 2000 Servers won't work with Winodws Update - error

    Hi, we have three file servers on our network running Windows 2000 Server. Recently the Windows Update has stopped working on all three of them, it fails with an Error number: 0x800B0109. I've seen various threads on this, about re-registereing dlls etc but nothing has worked so far. I'm...
  20. DanielUK

    Wireless only works after cable plugged in

    Just tested going to 192.168.1.1 when it's just been booted up (cable not plugged in at this point). I get HTPP 400 Bad Request "The webpage cannot be found". Have tried resetting IE default IE settings but nothing changes. Put cable in, everything works! One thing I forgot to mention is that...

Part and Inventory Search

Back
Top