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!

Register Log in
  • Congratulations derfloh 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. koresnordic

    Check if "move or copy" is being used in Excel

    Ah, got it [banghead]. I will try that. thanks [pc] Graham
  2. koresnordic

    Check if "move or copy" is being used in Excel

    HI Skip, I do ' Create the connection ' strSQL contains the SQL script selecting just the fields I need to subtotal by. The table the data comes from has more detail than in the pivot, which the ' end user will need to see when they double click on the totals Workbooks("Cogmotive...
  3. koresnordic

    Check if "move or copy" is being used in Excel

    HI Skip, thanks for the prompt reply, but I do want them to be able to copy and paste to another workbook, just need to remove the data connections prior to this. [pc] Graham
  4. koresnordic

    Check if "move or copy" is being used in Excel

    HI, I have a Excel sheet that has pivot tables that pull data direct from sensitive company data. I have no problem with the end user drilling down to the data inside the spreadsheet, but I do not want them to be able to right click on the sheet and select "move or copy" to another sheet...
  5. koresnordic

    Remove quotes inside a text field

    OK, I left it to start with and hand balled the data in correctly, so I could work on the what I needed to do with it after this stage. Then I came back to it. The way I resolved this is: Load the whole record into one data field with: -- Empty the temp table TRUNCATE temp_holding; -- Load in...
  6. koresnordic

    Remove quotes inside a text field

    Two example lines that are causing me an issue: [user]@[company],04/02/2014 02:11:59,customer-reviews-messages@amazon.co.uk,[user]@[company],"[name], did 'Kindle Fire HD 7", HD Display, Wi-Fi, 8 GB - Includes Special Offers' meet your expectations? Review it on...
  7. koresnordic

    Remove quotes inside a text field

    Hi coldbohemia, Unfortunately, this will have to run exclusively inside MySQL on a box not under my control, else I would create a bit of vb.net to do what I need. Thanks for the option though. [pc] Graham
  8. koresnordic

    Remove quotes inside a text field

    HI Phil, Unfortunately, this can happen daily. The data is e-mail extracts, where the subject line can contain any number of quotes etc. I receive the file into a windows server directory and have to work on it from there. [pc] Graham
  9. koresnordic

    Remove quotes inside a text field

    HI, I have been given a csv file to import that contains almost every type of problem you can think of. I have dealt with tabs, commas and pipes, which are all normally used as separators. But I am stuck with the quote char. An example. the following is part of a text field: "UK games firms...
  10. koresnordic

    GetBytes() giving error HttpWebRequest cannot be converted to string

    Sorted myself don't worry, changed Dim bytedata As Byte() = encoding.GetBytes(postreq) to Dim bytedata As Byte() = encoding.GetBytes(Requesturl) [pc] Graham
  11. koresnordic

    GetBytes() giving error HttpWebRequest cannot be converted to string

    HI, I am required to post via https to playtrade.com However I have never posted to a website before. I picked pieces up from various websites (and from playtrade direct) and produced the code below: Dim username As String = "[email address]" Dim password As String =...
  12. koresnordic

    Lose comms to server on an a random basis

    Hi DrBob The DNS/DHCP server doesn't appear to have any errors in the event viewer that are related to this - security is fine, problem with another server having an incorrect password but that is about it. Hi Technome I haven't a clue if the ports are having problems. But it occurs to...
  13. koresnordic

    Lose comms to server on an a random basis

    Hi DrBob We have 4 switches set in a stack (set up by my prececessor). These are linked via a short fibre link to what is marked as a core switch. All the servers are connected via gigabit connections to this core switch. As far as I can tell there is no segmenting taking place. The web page...
  14. koresnordic

    Lose comms to server on an a random basis

    Hi, I hope someone can help. We have a small network operating under a xxx.xxx.xxx.nnn ip range. It consists of several desktops (roughly 40 inc laptops that come and go) and several servers (some virtualised). Just recently people have been reporting having problems on the network. What...
  15. koresnordic

    ComException when working with outlook 2003

    Thanks for the help all. Bluejay07, the do loop worked fine. The procedure now looks like looop = oItems.Count Do While looop > 0 'Test to make sure item is a mail item 'and not a meeting request. If oItems.Item(looop).MessageClass =...
  16. koresnordic

    ComException when working with outlook 2003

    HI, Before I start, I am still learning VB (started two months ago as a sideline in my main job) and the routine below has been cobbled together through various guesses and parts pulled from here, there and everywhere. The basis of the routine is to go through my inbox, find the unread...
  17. koresnordic

    disk full when it isn't

    OK, found it.. It was a problem with the quote for the user and not the shared space. [pc] Graham
  18. koresnordic

    disk full when it isn't

    HI, It's been a while since I was around (long time between jobs). Sorry about that. In my new position I have a problem with one user. On the server there is an area open to all (called public). In this area, several people have created thier own directories. This particular user has a...
  19. koresnordic

    Slow to bring up printer selection box and doesn't print correctly

    Hi again Rob, The problem isn't the time it takes to print, that is quick once he hsa selected the printer. The problem is the time it takes to be able to select the printer and the misprinting of the page. Thx for the thoughts anyway [pc] Graham
  20. koresnordic

    Slow to bring up printer selection box and doesn't print correctly

    file > print has the same effect. The printer itself is quite old and has no usb ports. the version of office installed is 97 (again I know!!) with IE 7 [pc] Graham

Part and Inventory Search

Back
Top