Search results

Morning Brian, I have changed the code from a sub to a function thus: 'Function mysub() 'Dim rng As Range 'Dim pentot As Long 'pentot = 0 'For Each rng In Range("ALLGoals") ' If rng.Value = Range("filename").Value And rng.Interior.ColorIndex = 35 Then ' pentot = pentot + 1 ' End...

I placed the function in a Module Named the cell "G5" as 'Penalties' no result shows in the cell I have put it in my overall workbook (not the sample I placed here) It is in a xls (created originally on Windows 2003) And macros enabled Edit: There maybe a conflict in the code as i have...

Wow RX_ that is a serious bit of code. I think it's a bit advanced for my workbook .Thank you :)

I tried this but it doesn't give me an answer in the cell called Penalties .

Indeed a penalty scored is a penalty scored BUT when they are mixed in with open play goals (in the array ALLgoals) then it is useful to differentiate. Brian I am going to give this a test. Just as an aside I have another function that does not calculate when other cells are coloured. The...

Hi all, Hope someone can help me. I am in need of assistance with the creation of VBA code thaat counts cells that have certain criteria. The background (interior colour) is = 35 and the cell contents need to equal a named cell called filename. In laymans terms if it were a formula would...

Thanks PR2 :) I have printed this off and will have a go at it.

Hi all, I posted to another part of the forum but I havwe managed to locate some of the answers to my original post yet this one seems to allude me. In my DB I have a query that I need to create a static webpage from, now in excel I can do the record button and bingo, but access is a lot...

I can do that in Excel, but In Access 2002 ?

Hi all, I have a question related to a textbox on a form. In my table (tbl_data) I have a field named Rating. This can be anything from 1 - 10. On my form (frm_input) I have a textbox (created using the wizard so at the moment I'll call it txt_Rating). What I would like to know how to do...

Thanks CJ_London. I may have to go back to the drawing board on this one.

Hi, Hope this makes sense and it is in the correct section. I am using Access 2002. I am going to be producing a macro that imports a txt file. Once the text file is imported there will be a empty field for a date value. Nothing in the file that is being imported will have a date in it. I...

AWESOME ... thank you it works perfectly :)

Thanks, So if I put a textbox on the form, I put DCount(*) in the control source ? :confused: Sorry, I haven't done anything in Access in a long while and despite being good with Excel, Access is has always been a mystery to me.

Hi all, Can you guys help me out with this. I want to create a form in Access 2002 (old I know) that displays the following items. txtTotalRecs: This is ALL the records in the tbl_CoreDB txtTotalATH: This is the count of all records in the tbl_CoreDB in the field LGE that meet the criteria...

Hi all, This is probably very basic and I am missing somthing really obvious. I have a custom toolbar with a button on it that I want to open a userform from. I have tried this macro Sub Admin_Show() frmAdmin.Show End Sub and the button on the custom button calls the macro with...

Cheers Brian. vbsInet, Yes. I want to be able to calculate the number of minutes a player played for a club in his career. But your version divided it up into season which was even better. So I copied that query and removed the season part of the query, and it still worked. I may very well...

Thanks. I will continue to work on it. :) I see the problems now.

Thanks, but I cannot open it. It gives a message: I did save as from this site. but it will not open :( Using Google Chrome BTW. EDIT: Also same happenes when d/l using IE7. Anyone ideas ?

Here I am again folks looking for help please. I have a Access 2002 DB. In it I have a table called tbl_StartingXI. The fields are: MatchID, Player, TimeOn, TimeOff, Yellow, Yellow_Time, Red, Subbed, Replaced. I have a qry_CalcTimeOn and another called qry_AddUpTime Using the queries, the...