Recent content by kekewong

ok , i have a primary table that have a field of "job", then i create another table that have a field of "job" too , then how can i do this task? Whatever i type a data into the primary table("Job" field) i want it to duplicate the data into the another table("Job" field) . is it possible to...

I ask my lecturer today and he say this maby is microsoft access bug(because i can create in other new database , but not in my database), and he give me a tips that cab create more table to put more data validation then group the table together . Any idea about this?

lol, cant also =.= Wait, my Job i set it as a COMBO box, that i can choose for "engineer","trainee",and "clerk" in a list. Is this the problem that all the code wont work?

After i copy and pasted the code, it shown same as below Private Sub Salary_BeforeUpdate(Cancel As Integer) Dim blnError As Boolean Dim strJob As String Select Case Me.Job Case "Engineer" If Me.Salary Not Between 30000 And 40000 Then blnError = True...

i have try already, and i already set the breake point . the validation not working (i swear) @.@ but wait. i have try this: -------------------------------------------------------------- Private Sub Salary_BeforeUpdate(Cancel As Integer) If (Me.Job="engineer" ) Then vbInformation, "Data...

ya.. my salary is defined as currency in the Salary's Table . ya the spelling is correct @.@

what is a breakpoint?how to add it? example?

i just key in this code...... Private Sub Salary_BeforeUpdate(Cancel As Integer) If (Me.job="engineer" And (Me.Salary >= 30000 And Me.Salary <= 40000)) Then Exit Sub Else Cancel = True Msgbox "The Salary you entered is incorrect. Please try again." Me.Salary.SetFocus End If End Sub or like...

no error message come out , just no data validation occur , that means i can key in the salary with below 30000 while job is "engineer".:(

ANy body can help me ?

Private Sub Salary_BeforeUpdate(Cancel As Integer) If (Me.job="engineer" And (Me.Salary >= 30000 And Me.Salary <= 40000)) Then Exit Sub Else Cancel = True Msgbox "The Salary you entered is incorrect. Please try again." Me.Salary.SetFocus End If End Sub...

now i got 3 jobs that is engineer,trainee,cleck . For engineer, the salary must >=30000 and <=40000. For trainee, the salary must >=20000 and <=30000. For engineer, the salary must >=0 and <=20000. And i am trying to set the validation rules for it and it seems it cant work, can any one help...

wow thanks brain .. n_n i get what u mean anyway , and i have modifyied n_n THanks alot brother.... you save my mind.. lol

wow... i also can do it like that .. PRO brain .. LOL by the way i got 1 more question to ask Brain. Why u can make the checkbox uncheck after u press the command button? Why not the checkbox is remain check? can explain?

yup .. i try that before..... BUT still the MSG box wont come out yet..... it just grey-out and uncheck the checkbox only .. i think almost 1 day also cant figure it out yet...