Recent content by slickp007

I still get the same runtime error

They are in sheet 1

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

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

I'm having real problems with data validation for this. How can i force a cell not to be null using data validation?

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

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

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

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

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}

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

Cheers Ibass, a legend as always!!

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.