Search results

Dear arnelgp Thank you very much.

Dear Everyone, I want to find a number exactly in string ex. string field ="2,3,17,25,46" C1 field=5 => result "no find" instead of 9 C2 field=1 => result "no find" instead of 5 etc. Pls find the attachment for your ref., Thanks.

Thank you arnelgp very much. You're excellent.

Dear arnelgp, I click on new code Sub XYZ(ByVal Tong#), however, It doesn't work

1. Yes, only 3 columns but I can control results in it for example: in vba const=50 rows 2. I found the code in it that's good, however, I can't change the code into access vba? You can change bold part into vba access with thanks and I can learn code from you and have a knowledge about excel...

Dear arnelgp, Pls find the original excel file in the attachment for your ref. Pls advise and change vba above into access vba, thanks.

Hi everyone, How to change part in bold into access vba ? Sub Balaco() Dim sArr(), res(), sRow&, i& Const e# = 10 ^ (-12) 'Sai so cho phep Const n& = 50 ' results rows found i = Range("B999999").End(xlUp).Row res = Range("B3:C" & i).Value 'data table "Tnpl" sArr =...

Dear arnelgp, I don't know what happened, after click "generate". My pc's stable and standing and I try to wait 10minutes Finally I close the microsoft access.

Dear arnelgp, Currently, I want to open 6 columns in output instead of 3 columns Pls update and advise, many thanks.

Hi All, Pls write a sub/function with results about 500 record if found because query making pc stable and stading. Looking forwarding to receiving from you, thanks.

My opinion, no repetition

Dear MajP, How to calculate with query 3 ?

Dear MajP, with total: 16.6666666666678 => results found 8 records, however query from you only 1 record. Total T1 T2 T3 Dem 16.66666667 CA CD BE 1 16.66666667 CA BA RD 2 16.66666667 AE GD BK 3 16.66666667 BK CD RD 4 16.66666667 BK RC ZA 5 16.66666667 BE AH ZA 6...

Dear Everyone, I want to create a sub or function as follows: - List all materials fields "Manpl" from table "Tnpl" and insert/add into table1.T1,table1.T2,,table1.T3, with condition the same [table1].[tong] for example...

Dear All, File has updated with program "Windows compressed" already Pls open again, is it ok? Pls view and advise, thanks.

Dear Friends, I want to create a query with numbers from T1 to Tmax in file quiluat.accdb like file book excel Please find the attachment for your refference. Looking forwarding to supporting and receiving from your responses.

I used excel to express my idea after that I use the function to apply in my file accdb

Thank you very much. You are excellent.

I want to create a user vba function according to the following rules: Rule: 45-25-10-15 (cell B1: E1) Where: T1 = 45, T2 = B1 + C1, T3 = C1 + D1, T4 = D1 + E1 T1 gradually increases until T4 <= 100 If T4 <= 100, stop and return about the big value get from T1 Cell G1=max T1 Refer to the...

Dear SHANEMAC51, I find error, and I changed GT number into "short text" and C1,C2,C3,C4 number into "short text" => results are Ok