Recent content by cikwan82

ok.. i got it.. thank you :) , i will follow your advice...

What i want to do is before my data jump into table januari when i click button ADD, some notice will pop up if my "NoGerankod" or "NoMatrikkod" info have same number listed in my table "HutangKeseluruhan". please guide me.

I'm new on this sql , hope u can guide me.. all my sql i just learn edit from website.. what do u mean Elself? for : If Me.txtidborang.Tag & "" = "" = (DLookup actually like this : Private Sub cmdAdd_Click() 'when we click on button add there are two options '1. for insert '2. for update If...

I also try this coding, stil not working.. please anyone help me.. :( If Me.txtidborang.Tag & "" = "" = (DLookup("NoGerankod", "HutangKeseluruhan", "NoGerankod='" & Me.txtnogeran & "'")) or (DLookup("NoMatrikkod", "HutangKeseluruhan", "NoMatrikkod='" & Me.txtukmper & "'")) Then MsgBox "Grant...

Hi every one, i already make this sql for dlookup table for may insert button, all going good, but when i'm going to make double command with different msg box for different criteria, it going fail 1. This my Working code: If Me.txtidborang.Tag & "" = "" = (DLookup("NoGerankod"...

ok, i got it.. Thank you CJ_London... :)

ok.. i already make just one table (query table) for all month and just try this sql to my INSERT button form where i change Project Cod= NoGerankod myTable=HutangKeseluruhan Me.project cod= Me.txtnogeran If Not IsNull(DLookup("NoGerankod", "HutangKeseluruhan", "NoGerankod='" & Me.txtnogeran &...

Yes.. you are right... :)

ok i got it.. thank you my friends.. i just make UNION ALL. :)

it look like notice to tell me that cod already use by another person in previous month and not valid yet. If valid, that data will go inside to my table MacT. if possible can give me guide how to write that sql coding in my ADD button. Thank you

i know what you all means, i should have january-disember data only one table, so easier to make query. Now i already have many data from each month for each table, i must copy all data and make just one table and than make query :( .. it is any idea make all data combine together using button...

Hi every one, i already have many table for each month , JanuaryT-DisemberT. I'm using simple form to key in data inside that table. Inside to that table (JanuaryT-DisemberT) have project number data i want to notice pop up when i try key in if that project number not valid.. example JanuariT...

:(.. Thank you... my be i should make it separate for every month...

Thank you Pr2 and JHB, you idea is good, but actually i already make the navigation form for all month with different table,and the data already key in. just simple question is that sql cod can i use for different table? example: SELECT JanuaryT.userName, JanuaryT.userStatus...

Hi every one, how to make i queries for many table example : Table 1 name Status john Ok mike No Ann OK Table 2 Name Status michel Ok jony Ok Bruce No Queries for OK Name Satus John OK Ann OK Michel OK Bruce...