Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: slickp007
  • Content: Threads
  • Order by date
  1. slickp007

    Saving using a Password

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

    VBA Excel - Mandatory Cell

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

    VBA Excel - Mandatory Cell

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

    Parameters Question

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

    Postcode Query

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

    Latest figures

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

    Cross Tab Problem

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

    Time

    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))...
  9. slickp007

    Import Excel Docs to Access

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

    Pulling data from a subreport

    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?
  11. slickp007

    Cutting a string and adding a number to it

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

    Excel Question

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

    Excel Help

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

    Grouping a Sum

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

    Attaching a Access Table into Crystal

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

    Distinct Count Problem

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

Part and Inventory Search

Back
Top