Search results for query: *

Excel 2003 Hi, i've written some code in the workbook beforesave to make certain fields mandatory as below: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Cellcontents = Sheets(1).Range("B4").Value If Cellcontents = "" Then Cancel = True MsgBox "Cell B4...

Excel 2003 What i'd like to do is, that if say cell A4 had any sort of text, number or date in it, then this then makes cell B4 mandatory. I've created some VBA that makes cell A4 mandatory: Option Explicit Dim Mandatory As Range Private Sub Worksheet_SelectionChange(ByVal Target As...

Excel 2003 What i'd like to do is, that if say cell A4 had any sort of text, number or date in it, then this then makes cell B4 mandatory. I've created some VBA that makes cell A4 mandatory: Option Explicit Dim Mandatory As Range Private Sub Worksheet_SelectionChange(ByVal Target As...

Crystal XI Hi, this is gonna sound like a simple question but i've been racking my brains all morning. I have an insurer report which reports on all insurers. What i'd like a parameter to do is allow the user to select either all insurers or allow them to select mulitple insurers given them...

Hi, i don't know if i'm posting on the correct forum but this i thought was the most relevant forum. i'm doing an sql query in our crm package to find clients with particular postcodes. An example of our postcodes are NW12 3RB, N1 2LW, SW12 3BW, etc. I only need the area part, so for the...

Crystal XI Hi, i have a report which shows the history of insurance risks grouped by client and by the the last 5 digits of the risk ref. Risk references have the same 5 last digits but are given a prefix at the beginning to show the year of the risk ie A0720904 would be for the 2007 risk...

Crystal 11 Ok i have a problem with a cross tab, i have a report which shows business raised by sales advisor, and in the report footer i have cross tab which summarises everything in the report. I am having a problem showing the number of policies created in the sub report. In the report i...

Hi i have two fields which i've pulled from my tables which are time fields, but are held as strings in the database. So i've converted them both to time with the following formulas: //@time_started Time (ToNumber (Left (Maximum ({OPERATORLOG.TimeStarted}, {OPERATORLOG.OperatorCode}), 2))...

Hi, I have created a Policy database in access, and the user has requested that they have an import button to be able to import excel spreadsheets in the database. I was going to provide them with an import template, and then provide them with an import button with the following procedure...

Crystal 11 I have a sub report in my report and would like to pull the premium field from this report to get the percentage difference to the premium field in my main report. But i'm not sure how to do this. I've looked on the help about shared variables, would i have to use one of these?

Ok i have a reference which for every year roles over ie A0745058 will next year become A0845058 I want to report on the year before current reference, so i need to cut the 2nd and 3rd characters from the string, -1 and then add it back to the string, so taking the example above A0745058 will...

Hi, I have a SUMPRODUCT formula as below: =SUMPRODUCT((Jan!$G$2:$G$150="Bedford") * (Jan!$K$2:$K$150 = "BOUND") * (MONTH(Jan!$O$2:$O$150) = 1)) However the guy i'm doing this for has come back to me and said he would like the month formula to cater for all the worksheets on the workbook, ie...

Hi I have a work sheet like below: A B STATUS Date Bound 01/01/2008 Bound 02/01/2008 Unbound 01/01/2008 Bound 01/02/2008 Unbound 01/01/2008 I want to count the number of bounds where the month on the date = 01. But i'm having a few problems. I...

Crystal XI Hi I'm trying to group my data into premium bands, ie 0-1000, 100-2000, etc, etc. In my details i have all the transactions for each client, this grouped by client and the transactions are summed in this group. From this sum i've created a formula to put them into bands with the...

Crystal XI I have been trying to attach an Access table to one of our reports using Access/Excel (DAO) connection with a left outer join. However when i run the report none of the data from the access table appears. I've linked it using two fields, both fields from the original data source...

Crystal 11 I've created a report grouped by FSA type and have coloured the different rows in the report depending upon the time of the month. i would like to do a distinct count of how many blacks, blues and reds i have in each FSA group. However i have supressed in the section expert...