Recent content by Arwyn

I want to create a button to show an image on a form Could you please provide me with the coding required. Thank you

I have a text box called Sub Total, (currency). In the next text box I have to copy the sub total figure into the next text box called VAT which then calculates the tax in another text box called total. Sub Total VAT Total My problem is that I am making errors in copying figures from...

Wales v Canada Please note the game is on FRIDAY NIGHT UK time with a 7pm kick off. The television programe starts at 7pm so kick could be a little later. Please let me know you have recieved this message Thanks Arwyn

You were right When you said in your last message that my database might be corrupt, I started again with a new database. I changed the code to Dim str_Overall As String Dim str_H As String Dim str_A As String Dim str_L As String Dim str_E As String Dim str_S As String Dim ll_final_H As Long...

It Works Hi Gemma I have got the code to work. Matt was right when he said that my database might be corrupt. I started again with a new database and entered the code below Dim str_Overall As String Dim str_H As String Dim str_A As String Dim str_L As String Dim str_E As String Dim str_S...

Your last code Everything is correct but NOT the last one Point 6: FieldforEResult= there is nothing after = Hope this helps Arwyn

Result from your last code Hi Matt After adding the code MsgBox str_Overall When I click my button, a box appears showing HALE which is the correct result. Hope this helps Arwyn

My Code Matt Thanks for showing me my error which I have now corrected but original problem still remains. My code is now Dim str_Overall As String Dim str_H As String Dim str_A As String Dim str_L As String Dim str_E As String Dim str_S As String Dim str_Final_H As Integer Dim...

Problems again Hi Matt I now have a code Dim str_Overall As String Dim str_H As String Dim str_A As String Dim str_L As String Dim str_E As String Dim str_S As String Dim str_Final_H As Integer Dim str_Final_A As Integer Dim str_Final_L As Integer Dim str_Final_E As Integer Dim str_Final_S...

Hi Gemma Thanks for your help but it did not work. Please look at my new message for my next problem. Thanks Arwyn

Success Dear Matt The last code works perfectly. Thank you for your time and effort. Thank you Arwyn

More help if possible Hi Matt on my form I have 2H 1L 1A I changed your code to Dim str_Overall As String Dim str_H As String Dim str_A As String Dim str_L As String Dim str_Final_H As Integer Dim str_Final_A As Integer Dim str_Final_L As Integer str_Overall = [jan2] & [jan3] & [jan4] &...

Error Error is Str_Final_H = Len(str_H) & "H" I have tried what you suggested but the error comes up Run Time Error 13 Type Mismatch Thanks Arwyn

Help yet again Thank you for helping me again. The new code that you have given me comes up with an error. The error is in line str_Final_H = Len(str_H) & "H" Any ideas? Thank you Arwyn

Success Matt I have got your code to work perfectly. But now I want to add another subject therefore L = Late A = Absent H = Hoilday Jan2 = L Jan3 = A Jan4 = H I want 3 boxes on my form showing Late = 1 Absent = 1 Holiday = 1 I am grateful for your help Thanks Arwyn