Search results for query: *

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

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

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

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

...IGNORE INTO TABLE temp_holding -- select charcters that are very unlikely to exist in the record FIELDS TERMINATED BY '!!**@' LINES TERMINATED BY '\r\n'; CALL import_routine; With the import_routine stored procedure as: -- Set up variables DECLARE temp_text VARCHAR(4096); DECLARE temp_int...

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

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

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

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

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

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

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

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

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

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

...' Ensure the message is one we want to work with check_wanted = InStr(1, LCase$(oMsg.Body), "chip ", vbTextCompare) * InStr(1, LCase$(oMsg.Body), " pin", vbTextCompare) Check_Store = InStr(1, oMsg.Subject, "## from ", vbTextCompare) check_Till...

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

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

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

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