Recent content by Pearl1

hi d, No problems... Whenever you're ready. Kind Regards

Hi d, Take care and I'm looking forward. Thank you, did as you suggested but got a new error message saying "Compile error" Sub or Function not defined. See you tomorrow. Kind Regards

Hi D, I've tried with your original code, but this is the error message I'm getting "Run-time error '91': Object variable or With block variable not set. When I debug, the following is highlighted. strDayField = rs.Fields(DAYS_START_COL + iDay - 1).Name Hope you can share some light...

Hi d, Thank you but no luck, few items I had to re-enter not sure if you missed if or was it not meant to be there. I got an error message also, I' v attached the file. Private Function MyDay() Dim rs As DAO.Recordset, iDay As Integer, strSQL As String, strDayField As String ' entered Dim...

Thank you

Hi ebs17, Appreciate the offer but I like the challenges in Access. If all fails I'm sure you will have my back. Kind Regards Pearl

Hi D, Thank you. Appreciate all the assistance I'm getting. I was not able to run the VBA code you provide but below is what I was able to run. I had to take off the following..." (iDay As Integer) As Boolean" and it worked. Now...how do we get results for the following. 1, I need to get...

Hi, Not near at the moment but definitely looking to retire there in near future. Kind Regards

Hi d, Sorry, missed to answer the following question you asked earlier >> Is there a way of it picking up the columns from 3 to 10 , do the calculation and return result in different columns. << Please clarify for me, do you want to open a query showing the calculation for each date? If so...

Hi d, Thank you...I'm not sure what happened (my lack of knowledge) but when I copied code, It asked for Macro name, which I created. Was I meant to copy the code again in the Sub Sample ()...see attached file Copy Code again. If I was meant to copy the code again than I got the following...

Hi June, Thank you...figured out how to post code within Code tags to retain indentation and readability . Had one question. I was able to modify your suggestion slightly on " Const DAYS_START_COL As Integer = 4, _" and took off the date from "iDay = 1". Is there a way of it picking up...

Hi d, Hope all is well. Appreciate your time and assistance. 1st I'm not good at VBA (very,very basic knowledge...something like "Hello world") but I like to learn. Had couple of questions. Q1. When mentioned "create a stored query"...do I need to create a query or will the VBA code do it...

Thank you

Thank you

Thank you