Search results

It Works now !!!!! Thank you a lot , Best regards

It still showes same mistake. I copied your "Quote" but nothing has changed. Any other solution?????????

Can enyone tell me where could be mistake in code: Some oprerators are missing and I cant figure it out which they are Private Sub Command1_Click() Dim TblName As String Dim StrSql As String Dim fromTabela As String TblName = InputBox("Table name") fromTabela = InputBox("From table") StrSql...

SOLVED: update table in VBA by InputBox I solve it , syntax is next: Private Sub Command1_Click() Dim strSQL As String Dim strMonth As String strMonth = InputBox("Tabela") strSQL = " UPDATE [" & strMonth & "] SET " & _ " [" & strMonth & "].[oznaka_dani_klijent] = '>=181' , " & _ "[" & strMonth...

SOLVED: update query in VBA by inserting changable part in Input box I solve it , syntax is next: Private Sub Command1_Click() Dim strSQL As String Dim strMonth As String strMonth = InputBox("Tabela") strSQL = " UPDATE [" & strMonth & "] SET " & _ " [" & strMonth &...

Yes, excatly that ! Well this is the only one update query in set but they are all in same principle every time when I need to excute any of them I have to switch table manualy in "Desighn view". SO I am trying to optimaze this query by VBA in the way that I will be able to type changable...

Hi! Can enyone solve this, I have tried but dont know how to syntax it . Source SQL code is : UPDATE 31102012v5 SET [31102012v5].PL_NPL_klijent = "5b_NPL", [31102012v5].oznaka_dani_klijent = ">=181" WHERE ((([31102012v5].rating) Not Like "5*") AND (([31102012v5].CALC_DAY_client_GOSP)>180)); and...

Hi! Can enyone solve this, I have tried but dont know how to syntax it . Source SQL code is : UPDATE 31102012v5 SET [31102012v5].PL_NPL_klijent = "5b_NPL", [31102012v5].oznaka_dani_klijent = ">=181" WHERE ((([31102012v5].rating) Not Like "5*") AND (([31102012v5].CALC_DAY_client_GOSP)>180)); and...

My name is Denker Odak. I am working for the private bank. I started using MS Access in 2012. Before starting with MS Access I worked little bit with Oracle 6i and VBA . Now the time is there for me to get into VBA routines to solve issues I am running into. My hobbies are fitnees and stand up...

Hi! Can enyone solve this, I have tried but dont know how to syntax it . Source SQL code is : UPDATE 31102012v5 SET [31102012v5].PL_NPL_klijent = "5b_NPL", [31102012v5].oznaka_dani_klijent = ">=181" WHERE ((([31102012v5].rating) Not Like "5*") AND (([31102012v5].CALC_DAY_client_GOSP)>180)); and...

Hi! Can enyone solve this, I have tried but dont know how to syntax it . Source SQL code is : UPDATE 31102012v5 SET [31102012v5].PL_NPL_klijent = "5b_NPL", [31102012v5].oznaka_dani_klijent = ">=181" WHERE ((([31102012v5].rating) Not Like "5*") AND (([31102012v5].CALC_DAY_client_GOSP)>180)); and...