Search results

Dear Everyone, Pls see and how to fix error sub c1tim() on command 4 of form as follows: Sub c1tim(tablea As String, loai As String, x1 As Integer, tableb As String) Dim db As DAO.Database Dim rs As DAO.Recordset Dim strSQL As String Dim i As Integer ' Bu?c 1: Tìm giá tr...

Dear Everyone, I really appreciate "Thank you" all of you supported me. Sometimes I confused by comments because I am not good English. So that I usually send with the attachment. I often wrote wrong code and output wrong result as follows: I want to update number with current column latest...

Hi everyone, Pls fix missing values from the 28th records to 45th into table tbltke(vitriD) from sub as belows: Sub dkepos45(tablea As String) Dim i As Integer Dim db As DAO.Database Dim rs As DAO.Recordset Dim dpos(1 To 45) As String Dim strSQL As String Set db =...

da fix thanh cong

Dear everyone, I add a function dayso() in module1 and 1 button "dayso" .after click data insert into tableb. However data duplicate I want to insert records no duplicate both tablea and tableb. That records inserted tableb based on C1 to C6 from tablea. example: insert into...

Hi Everyone, I have a form with button spin and 3 textboxes. I want to spin after each click on button then txtdayso contains random numbers no repetion Pls find the attachment for your ref. Pls guide and show your code to fix the issue.

Sorry I found a solution.

Dear Everyone, I have two issues as follows: 1. How to control records of NPL1 with condition each 10 records, etc... (Thanks for your support "arnelgp") Total NPL1 NPL2 NPL3 10.66667 AA DC tC 10.66667 AA eA tB 10.66667 AA eB TA 10.66667 AA eC SC 10.66667 AA FA sB 10.66667 AA...

Dear Everyone, I'd like query which value sum by each column with condition from table "Tnpl" based on form "Fbe" Input/select value on form "Fbe" for example: NPl1+NPl2+Npl3=AE+BE+DS => Output query sum as follows: Pls find the attachment for your ref.

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.

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 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 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 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...

Hi Everyone, I want to create 3 query based on 3 tables 3 query like images in the attachment Looking forward to receiving from your reply. Thank you

Hi u, Pls help to write vba code for append query with dynamic field to table ie: such as append query "F5A1,.." to table "s_test" "F5A1" query: INSERT INTO STYLE5A ( ID, NPL, DVT, A, B, C, D, E, F, G, H, I, J, CNN ) SELECT CR5ADM.ID AS ID, CR5ADM.NPL AS NPL, CR5ADM.DVT AS DVT, CR5ADM.[1]...

Hi, I'd like to use vba to make a dynamic append query with button "update" on form1. however It's error. I looking forward to receive your help, thanks! Thanks&Regards, Tam Binh