Search results for query: *

Hi All I work in road safety for a local council and I need to respond to an email received earlier today from a member of the public regarding the speed of vehicles passing through his village. My email contains the sentence: Is 'thereto' the correct word with which to end this sentence? Or...

Hello All The IT department at work has asked that we all try and cut down the size of our inboxes in outlook 2003. I would like to archive some of my folders to a network drive, but if I select any more than one email at a time and then 'Save As' from the file menu, the only 'Save as type'...

Hi All I need to copy some data from one sheet to another using vba. Two of the fields I need to copy are in date format (dd/mm/yyyy). I am using the following syntax to paste them into another workbook: Range("H2").Copy Destination:=Workbooks("GroupStats.xls").Sheets("Sheet1").Range("B" & j)...

Hi All I am using Excel 2003 (SP2). If a particular cell in my worksheet is blank, then the entire row will be blank and I wish to delete it. I found the following line of code posted by anotherhiggins in a separate thread: which would quite rightly delete the entire row where a blank cell...

Hello all I originally posted this in the office forums, but I have been advised that my problem could be solved using vba. I am using excel 2003 (SP2). I am exporting data from some mapping software to excel, where I would like to be able to use the percentile function on a particular column...

Hello all I am using excel 2003 (SP2). I am exporting data from mapping software to excel, where I would like to perform some mathematical functions on the data. Unfortunately there are often more than 65536 rows of data meaning that it cannot all be pasted into excel in one range. For...

Hi All I'm using Excel 2003, SP2. I have a workbook, in which the names of the days of the week run across the top row, and in the leftmost column the day is broken down into hour long segments such as: 0101-0200 0201-0300 0301-0400 0401-0500 What I would like to be able to do is where the...

Hello All I am using VBA in Excel 2003 (SP2). I would like to set the value of a variable depending on whether or not a cell has a comment in it. If the cell has no comment, the variable is set to the cell value. If the cell does have a comment, the variable should be set equal to the comment...

Hi all I am importing data from an access database into an Excel spreadsheet based on a simple query. I can see that there is one record in the recordset, but upon trying to paste it into the spreadsheet no data is displayed. I initially assumed that this was because all the values were null or...

Hi All I am very new to VBA and am trying to pull some data into an Excel Spreadsheet from an Access database (both 2002 edition) using a VBA written macro. My spreadsheet has several rows, of which the first two cells in each row contain a start date and end date respectively. The goal is to...

The shorter Oxford English Dictionary cuts the hyphen out of 16,000 words article here Geraint The lights are on but nobody's home, my elevator doesn't go to the top. I'm not playing with a full deck, I've lost my marbles. Barenaked Ladies - Crazy

Hi All I have a game on my mobile phone which is a version of the dice/word game Boggle. For those that don't know, the game is played on a 4 x 4 grid held inside a clear plastic box. There are 16 dice in the box, each of which has 6 letters on it. The dice are tossed into the grid and the...

Hi All We are using Crystal Enterprise 10 in the ActiveX viewer. A simple report with a datetime parameter on it runs OK in Crystal Reports designer. When attempting to add the range 31/05/2007 21:30:00 to 01/06/2007 05:30:00 in crystal enterprise we get an error box stating 'The start of range...

Hi All I'm using crystal 10 connected to a sql server 2000 database via ODBC. I have a report with a split report footer (a and b), which contains a subreport placed in report footer b. This subreport is an almost identical copy of the main report, except that different criteria are used for...

Hi All, I'm using crystal reports 10 connecting to an oracle database using ODBC. The report I am writing is product based, and is grouped by product code. On the details line are the components of that product and the alloy of each of the components. If the alloy code begins with '3' it is a...

Hi All In our SQL Server 2000 database, we have a table for our internal financial calendar. This table contains the fields: 'Type' (= W or P for 'Week' or 'Period') 'Financial Year End' (Currently 2007) 'Week No' 'Period No' 'Start Date' and 'End Date' (for weeks and periods) and lastly (for...

Hi All I am using a DTS package in SQL Server 2000 to transfer daily data to a text file for upload into a different system. What I would like to do is insert records into this text file rather than overwriting the file every time the package runs. Is there a way to do this or will I have to...

Hi All, We are in the process of creating a data warehouse on SQL Server 2000 to centralise our data as we have several different databases and some quite fragmented data. I'm constructing a DTS package as part of this process, which needs to copy a products table from another SQL Server...

Hi All, I need to modify a script which used to return everything changed since 'sysdate - 1'. This now needs to be updated to be more specific - everything changed between 6:00am yesterday and 6:00am today. I wouldn't have trouble if it was a specific date, but since it needs to look at...

My first stab at a programming puzzle: A variation of the card game patience is played according to the following rules: Four cards are dealt face up on the table. If two (or more) of the cards share the same face value, then the card furthest to the right is picked up and placed face up on...