Search results for query: *

Looking good now thanks Using relative referencing method Damian.

It does Glenn I can't see what this is relative to I will have a look into this Should I be using the method Could I perform this without relative referencing?

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

Fixed it: Seems to be where the quotes are "=budget!R1C2 & ""*"" & budget!R4C[" & i & "] & ""*"" & budget!R4C1"

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

Thank you

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

If I wanted to take this a step further and insert records that are currently missing from this list and allocate them the nearest previous date e.g. 2006-11-04 would be day 3 Is this possible?

Thanks

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

Fantastic, thanks for that

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

I would use ` rather than ' e.g. this is my o`malley I've always used this by way of 'best practice' within the SQL environment Damian.

Thanks, i've had a look at the microsoft site. Open ended and depends on the individual I know but, how long did it take to get to a position where you sat the exam. Been looking around from there and the book for just the one exam is 1024 pages - i've also see suggestions that this book doesn't...

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

Thanks, i'll have a look at this site Thanks for the help everybody I got this working Skip, i used your method although it didn't like rng so I used Selection Also, for some reason the if statement didn't work so I replaced it with something that removed the - and *-1 (if - present at end) Damian.

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 On a set of Excel spreasheets I don't know why but the people providing us with this spreadsheet seem to think that that's the correct way to interpret negative numbers They are aware now but I have to deal with this Thanks