Search results for query: *

Hello I have the following macro running within Excel: Dim rowReference As Integer Dim columnCounter As Integer Dim budgetCodeCounter As Integer rowReference = 2 For budgetCodeCounter = 1 To 4 For columnCounter = 1 To 12 Cells(rowReference, 1) =...

Hello Within Excel, using the following data: C1 C2 C3 C4 C5 ..to C13 R1 Leeds R2 R3 R4 Sales Jul-06 Aug-06 Sep-06 Oct-06 ..to Dec I am trying to get the following results: id Leeds*Jul-06*Sales Leeds*Aug-06*Sales...

Hello Within Excel I have a date displayed as Jul-06 (this is 01/07/06) I have another cell with a reference in it (ASP) I am looking to concatinate these 2 cell with a * delimiter to form 01/07/06*ASP I can't seem able to do this as the system converts this to an internal date Does...

Hello Using SQL 2000 If I have a table called tblValidWorkingDays which comprises of a single field called workingDay (sample as shown) workingDay 2006-11-01 00:00:00 2006-11-02 00:00:00 2006-11-03 00:00:00 2006-11-06 00:00:00 2006-11-07 00:00:00 2006-11-08 00:00:00 2006-11-09 00:00:00...

Hello I am SQL 2000 I am looking to create an SP that takes 5 fields If field1 has something in it, it select something, else field2 etc (case method) I currently have the following (where the selects are there for test purposes): TestProc @field1 int, @field2 int, @field3 int, @field4 int...

Hi I've been using SQL Server 2000 for some years now and just fancied getting some qualifications This is not only for 'CV' purposes but I also would like to establish what I know/don't know and improve my knowledge of SQL Server MCDBA seems the most sensible option In all likelyhood, what...

Hello I am using Visual Studio 2005 and creating a VB project. Does anybody know where the Data Forms Wizard I want something that can guide me through the creation of a form and am told this is where to look It should be under 'Add Item' There's about 30 options and Data Forms Wizard is not...

Hello using VB.NET I have the following simple code: Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim con As New OleDb.OleDbConnection() Dim ds As New DataSet Dim da As OleDb.OleDbDataAdapter Dim...

Hello this is hopefully a straight forward question I am building a routine thats acts upon a specific file selection I would prefer to create a front end with a 'explorer' style seacrh for the file that a user can drill through At the moment I am struggling to write the code to perform this...

Hello Data is coming through on a number of spreadsheets with negative figures shown as (e.g.) 32- rather than -32 Is there a function capable of reversing this? Or would I have to create a custom one that removes the - and multiplys by -1 (for example) This occurs in a number of places so I...

Hello I am using Cognos v7.2 Within transformer I have a standard calendar year root within the date dimension. This runs Year - Month - Day How do I create the equivalent with a six month offset Our financial year runs July to June Thanks Damian.

Hello Using Excel 2003 I want to create a function (there's more I want to do with this so that's all I need in the first instance) I have some data on a worksheet that looks like this: 000000999xxx 1 789000abc000001000 1 765000def000000050 1 765000klmn000002050 9990003100 There's always a...

Hello I am using MS Excel 2003 This is by no means the end of the world but it is annoying. Everytime I start Excel it comes up with an error: 'Training Notes.doc: File format is invalid' I suspect this is not a standard Excel error and that it is looking locally for Training Notes.doc I...

Hello I am using MS Word 2003 SP2 I have a 15 page document All these pages have a footer on them and page x of y I really want to bypass the first page as this is a cover sheet Basically, page 2 onwards would have the footer and it would run from page 1 of 14 to 14 of 14 skipping the first...

Hello I am using MS Excel XP and am attempting to run a vlookup and seem to be having problems When I click on a cell as the lookup value it displays without quotes Yet when I select cells for comparison within Table array it displays all data surrounded by quotes The data looks identical and...

Hello I am using SQL 2000 I have the following code which doesn't quite work: select * from #missing_supplier_pcsubsupplier msp where subledid + ' ' + product_code + ' ' + pcsubsupplierid in (select distinct subledid, product_code, pcsubsupplierid from #missing_supplier_pcsubsupplier group...

Hello If I have say 10 paragraphs of text, some 1 line and some more How do I implement line spacing between each paragraph withough implementing line spacing between each line within the paragraph e.g. > Paragraph 1 > Paragraph 2 with a bit more text going onto 2 lines > Paragraph 3 >...

Hello Using SQL Server 2000 Does anybody know where Information_Schema resides and what it contains? Thanks Damian.

Hello I have a relitively small database within SQL 2000 I would like to take a copy of this database and reattach it in MS Access The person I am passing it onto is external to our business so can't access the database and does not have SQL Server Access doesn't seem to recognose the file...

Hi Am I using the right method to select visable rows only? After filtering, to select only the cells shown I use: Selection.SpecialCells(xlCellTypeVisible).Select On its own, this works I have a script that performs this action multiple times (via a do while loop) The first time it...