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!

Recent content by slickp007

  1. slickp007

    Saving using a Password

    I still get the same runtime error
  2. slickp007

    Saving using a Password

    They are in sheet 1
  3. slickp007

    Saving using a Password

    This code doesn't work, i get the error message: Run time error 9: Subscript out of range When i go debug its pointing at Ln 3 Col 1. Help? I'm not to sure how to create these Admin and Prod procedures, sorry a bit of a newby to VBA
  4. 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...
  5. slickp007

    VBA Excel - Mandatory Cell

    I'm having real problems with data validation for this. How can i force a cell not to be null using data validation?
  6. 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...
  7. 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...
  8. 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...
  9. slickp007

    Postcode Query

    sorry i'm being a dumbass, works great, cheers mate!!
  10. slickp007

    Postcode Query

    Cheers gmmastros. however i now have this: SELECT contact1.Accountno, contact1.company, contact1.key4, contact2.uxdate, contact1.contact, contact1.zip FROM contact1, contact2 WHERE (contact1.accountno=contact2.accountno) AND (contact1.key4 NOT IN ('EEF','CLA','FPI')) AND ((Case When...
  11. 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...
  12. slickp007

    Latest figures

    its ok i've worked it out myself, all i did was find the maximum renewal date and then do this formula: if {@Rnl Date} < Maximum ({@Rnl Date}, {@risk prefix}) then 0 else {RISK.NetPrem}
  13. 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...
  14. slickp007

    Cross Tab Problem

    Cheers Ibass, a legend as always!!
  15. slickp007

    Cross Tab Problem

    i have multiple transactions in the details section and it is only the sum of these transactions that are = 0 that i don't want to see. That is why i have done the formula as in my first post. The sum is found on the group for risk ref.
See more

Part and Inventory Search

Back
Top