Search results

I have had a motherboard failure in a desktop PC. It was running XP and was an OEM machine (DELL). I have installed the HD in another machine and as predicted got the BSD but it will boot in safe mode. I have recovered all the user data. Is there any way that I could recover the installed...

I knew the SQL statement was right but when I copied it and removed the date referances I left a comma in the string that shouldn't be there. But couldn't see it. :)

A DOH moment, reading my own post I saw a comma where there shouldn't be one. I'll have to go to specsavers. :)

The following code works if Me.txtFrom is a date but not if it isn't. I copied and pasted the 'True' SQL string from the true case and removed the references to Member_From and Me.txtFrom putting it in the false case. If I run the procedure with no date in Me.txtFrom I get a message box 'Syntax...

I haven't been on the forum for some time. I note that your gender is now displayed, were you getting too many offers! :-)

The data was safe, I ran a make table query and ran the function off that :-)

Thanks, I ran a query to remove all the records with no data in the field and it worked a treat. I'm trying to 'Normalize' tables in a DB i've taken over that was in a right mess.

Something has gone wrong, I didn't expect anthing to be written to the table as I had an error but The table now has 9,000 entry's with each ID entered 4 times with the four same boats. I take your point about the Nz function.

I have a table(tblMaster) with a field(SUBS1) that contains a string of names seperated by a space. I want to split the field into names and put each name together with the ID field into a separate table(tblBoatMember). I get an 'Invalid use of Null' error on the line vArr =...

Thanks Bob I've Solved it. Private Sub UserForm_Activate() Dim NewRow As Integer NewRow = Worksheets("Data").Range("$P$1").Value If NewRow = 20 Then Call MsgBox("The maximum number has been reached", vbExclamation, Application.Name) frmNewName.Hide End If End Sub

Thanks for the reply Bob, I've tried your suggestion but get the same error. What I am trying to do is allow the user to add to a list of names but the list cannot contain more than 20 names. When the User Form is opened I want to check that list contains less than 20 names, if so allow the user...

I wish to check the value of a cell when a form is opened. I have spent a long time trying to find a solution. The procedure that I have is, Private Sub UserForm_Activate() Dim x As Integer x = Worksheets("Data").Range("P1:P1").Value Debug.Print x End Sub I get the error ' Line...

Solved it. {=SUM(IF(YEAR(Lfrom)=LeaveYear,IF(LNames=I3,LTaken,0),0))}

I am using the following Array Formula. It works perfectly as is but if I insert the Range Names LNames and Lfrom instead of a cell range reference I get an error. Any suggestions please. {=SUM(IF(YEAR($B$1:$B$53)=LeaveYear,IF($I3=$A$1:$A$53,LTaken,0),0))} LeaveYear =Data!$AC$1 Lfrom...

I've just come across this old post of mine and realised that although I had worked out a solution to the error trapping problem I hadn't posted it. {=IF(ISERROR(INDEX(Cover,MATCH(1,(LeaveDate=E2)*(Name=F2),0)))=FALSE,INDEX(Cover,MATCH(1,(LeaveDate=E2)*(Name=F2),0)),"")}

Thanks I solved the problem by upgrading to a Nokia N95 and TT6

I saw on another forum the use of CountIf to prevent a #N/A error. I have played arround for some time trying to adapt my formula to no avail, However using IfError works fine so i'll leave it at that. Thanks Brian Keith

I am using the following array formula which entails excel doing the calculation twice. I have tried using countif in the match part but can only get it to work for only one of the conditions. Can anyone help please...

Thanks Brian a brilliant solution. I am using command buttons, I was tired when naming them. This is my function; Public Function leaveyear(qtr) Select Case qtr Case 1 Worksheets("Calcs").Range("C1").Value = DateSerial(Range(Names("leave_year")).Value, 4, 1)...

I have 4 command buttons on a worksheet named 'Calendar' that I want select the quarter. The calendar is populated from a worksheet named 'Calcs'. I am having difficulty in setting the start date on the Calcs worksheet. Leave_Year is a named range in worksheet 'Input' and is general format...