Search results for query: *

Hi All, I'm not an expert at SSIS by any means but am trying to learn as I go along. I've been following the instructions from this web page http://microsoft-ssis.blogspot.de/2011/05/download-source-file-from-website-with.html And have got most of the way to do what I need. However, for me...

Hi All, I have a spreadsheet that has two buttons to print to PDF. One prints one set of pages - the other a different set of pages. At present it works by selecting the sheets into an array. However, this means that if the user presses 'Print to PDF' and then 'cancel' all of the requisite...

Hi All, I have two list boxes on a form - I'm currently populating the second list qwhen the first changes. Howewver, that means if you deselect the item from the first listbox it doesn't remove the items from the second; which is the behavour I'm aiming for. My current code looks like this...

Hi All, I'm trying to build up an SSIS package based on some import-export wizards as I'm not yet au fait with SSIS. My server is SQL 2008 Standard. When I try to save this I get an error telling my that I must upgrade from SQL Express. I do have SQL Express on my local machine. Do I need to...

Morning all. I have a query that I really want to pivot in output. I've looked at everything and I really can't see where this is going wrong... My query looks like the following: select CCGHB, Brand from ( -- actually query by yer) ) pvt pivot (sum(TotalNIC) for MQT in ([Feb 13],[May...

SOmehow or other my macro-workbook got corrupt. Excel has repaired it and it all works fine - but the [repaired] remains after the file name. I've copied all of the sheets and saved as another workbook and all seems fine, but when I export the forms and modules to files and then import to the...

Hi All, I'm trying to set a worksheet object to be the value in a specific cell (kinda like using a global variable, but hopefully more reliable!_ So far I have Dim rData As Range Dim ws As Worksheet Set rData = Range("Lookup!E33") Set ws = Range("Lookup!E34").Value I've truied with and...

Dear All, We supply some products that last either one or three months. So, we calcuate a 'MonthlyLasting' figure to compare our sales against competitors. For that to work accurately, I actually look at sales on a moving quarterly basis. So, MQT Jan13 includes the months of Nov12 + Dec12 +...

Hi All, I have a (fairly) large table of approx 4,000,000 records each month for presently 27 months. I diable and rebuild the indices before each month's data load and currently it takes almost 2 hours to rebuild them. As the veriosn of SQL i have won't allow me to partition the tables -...

Hi All, I have a largish table in SQL 2005 containing monthly 'buckets' of data. When a new month of data becomes available I import this (via a staging table) and before the import I disable all indexes. After the inmport, I then rebuild all indexes on the table. So I guess I have two...

Morning all. Whilst I have been writing queries and messing with SQL data for a while, I'm certainly no DBA... But I find myself in a position where I don't have a DBA, so I'm going to need to head up a fairly steep learning curve. I have a table which has data added once each month. The data...

I've been given this for work (I have an iPhone 4 on O2 for personal use) and it doesn't seem to have visual voicemail. Is this an option I'm missing; or do Vodafone not support it? Ta Fee "The cure for anything is salt water – sweat, tears, or the sea." Isak Dinesen

As the OS OpenData is now all available, I'd like to start using some of this. so, amn a complete newb. Is there something I can trial which is free? Can anyone point me in the right direction? Ta ever so. Fee "The cure for anything is salt water – sweat, tears, or the sea." Isak Dinesen

Afternoon Chaps, I've heard rumours that our IT at work might be downgraded following a merger. So, at present I develop in Excel 2010 on a Windows 7 machine for which I am an administrator. Apparently I'll be moved to Excel 2007 on Vista with Standard user privileges. I'm not keen on the...

Hi Chaps, My boss has asked that everytime any of our team supply a chart to the business that we mark it with a text box (or something similar) to indicate its source. So, for example: a text box with the words: Fab Team, Our Company Ltd. At the moment I'm just adding a text box each time...

My boss has just askied me how he can dial direct from an email signature... The problem is that everyone (certainly in the UK) seems to have thier signature in the format +44(0)5555 567890 To dial, we need this without the zero and without the brackets. Does anyone have any bright ideas...

I'm trying to put into practice things I've learnt here y'know. And at least part of this is fab (and making me very happy!). So, I have a project which will have several forms. I on;y want top wrote the code to populate the list boxes once, as they will be the same in each case. So, I have this...

I have a VBA project I wrote (on a machine running 2010) whcih I'm now trying to test on a machine running 2007. The code doesn't appear to be complicated: Private Sub userform_activate() cmbRAD.RowSource = "" cmbRAD.Clear cmbPCO.RowSource = "" cmbPCO.Clear cmbRAD.Value =...

I have a sheet within a workbook that I am 'copying' to a new worksbook and emailing. At the moment I copy like this: With Destwb.Sheets(1).UsedRange .Cells.Copy .Cells.PasteSpecial xlPasteFormulas .Cells(1).Select End With...

I'm stuck on this one. I have a chart which has always been working rather well, thank you very much. It is based on a dynamic named range as the series number can vary from 1 to 3. I have this located in a sheet and this is always a column chart. I now have a need to add an extra series (whos...