hally
01-01-2008, 08:47 PM
I got 1 file ( Trade.mdb ).. Inside this file I got 3 table which is Data151, MKCW442 and KOR_tbl..
So when user choose file Data151 and click button process.. I want it to be like this:
1. Read the field Ctry. If the field Ctry = Asean Country which is ( MY, TH, SG, BN, ID, PH, KH, MM, VN, LA ) then have to compare with field HS in table Data151 and compare also with field AHTN 2004 or field AHTN_ABJAD 2004 in table Master1
2. If same, then transfer the all information from field AHTN10_2007 in table Master1 to the new table ( Output )
3.Transfer all the information that have been modified or not to the new table ( Output )
3. After finish process, must come out one message box which is PROCESS SUCCESS
Ok thank you.. I really don't know about this..
So when user choose file Data151 and click button process.. I want it to be like this:
1. Read the field Ctry. If the field Ctry = Asean Country which is ( MY, TH, SG, BN, ID, PH, KH, MM, VN, LA ) then have to compare with field HS in table Data151 and compare also with field AHTN 2004 or field AHTN_ABJAD 2004 in table Master1
2. If same, then transfer the all information from field AHTN10_2007 in table Master1 to the new table ( Output )
3.Transfer all the information that have been modified or not to the new table ( Output )
3. After finish process, must come out one message box which is PROCESS SUCCESS
Ok thank you.. I really don't know about this..