Search results

Thanks Minty for your response. I understand the db seems to be scary and everyone focus is on the db designs. Well that is the reality. To change it may take sometime which i can work on later, but right now i have the below on hand which will help me to complete the project. i want to move...

HI, any suggestion pls.

Thank you Pat Hartman for looking into this. Honestly, i am at the last stage of completion and doing any changes at this stage will delay my completion task. Well i agree that my data is not in standard way and there are lots of inconsistency. To answer you post#16, i would love to get the...

wanted to mention the columns names: DR1 to DR4 and CR1 to CR4 and RD1 to R4

sorry, i removed the post, updated older version of my db. updated the new one. query2 when you run gives the result in control. It displays perfectly on the form. I wanted get the same on the form

Thanks Arnlegp one more issue how do i put the below code in two lines var = DLookup("RuleID & '|' & NR1 & '|' & VR1", "tbl_Rules", "Rule1='" & Me.cboSRSubType & "' And Rule2='" & Me.cboSRSubSubType & "' And Claim='" & Me.Claim & "'") tried doing this, it gives me error var =...

Thanks very much, take care and God bless

Thanks Arnelgp for the revised code, can i apply the same logic, if the ContolSource is approx. 10 (NR1; VR1; ....etc.) thanks

Thanks plog for the suggestion. My challenge is i am not able to do this due to the limited knowledge on coding. Can you suggest me the start on the code pls.

HI! all I hope everyone is safe and sound, i have the below code on variant, how can i improve the code when i have say 10 variants and and 10 different ControlSource and other logic remains the same. Can anyone help with to provide me a better solution. I had the below code from my earlier...

Thank you Gasman and Isaac for your time. noted the steps will study them and use it in my next task.

Thank you Isaac for the code, it works perfectly and coded only those which appear in sheet ABC. I will go through your code to understand it. I thank you again for helping me here. Really appreciate the time taken.

yes, exactly this is what i am looking for. sorry for the initial incomplete explanation.

i just wanted to explain a bit more on the attached excel. Sheet "ABC" is where i input the numbers and Sheet "Numbering" it should highlight the numbers which appear from ABC. the code is error free.: But it only highlights column A from sheet "Numbering" It also highlighted some numbers which...

i am not getting any errors after the change, however it only highlight the 1st column in sheet "Numbering". Rest of the columns dont get highlighted

i have managed to upload the excel., can you have a look at it pls. thanks

thank you for the code. Now i am getting error on next line as below If InStr(s1.Range("A1:AX100" & i), s2.Range("C" & j)) > 0 Then below is the error Run-time error "13" Type Mismatch i tried using your code but it still gives me error

i dont have winzip on my laptop. i tried to download its paid stuff below is the error Run-time error '1004' Method 'Range' of object'_worksheet failed

Thank you for your reply. I am getting error on line "lr" as i have changed the range from "A" to "A1:AX100" i am unable to upload xlsm files

Hello everyone i am stuck with the below vba code. This code helps me to highlight a single column, however, i am trying to give it a range in s1 as "A1:AX100" and it gives me an error. Below is the code and any suggestions. Sub HighlightCells() Dim s1 As Worksheet, s2 As Worksheet Dim...