Recent content by caljohn527

Hi all Read This If You have The Time . Dim text As String If IsNull(Me.empappearance.Value) = False Then text = Me.empappearance.Value Select Case text Case "Good" Me.emppoint.Value = 1 Case "Poor" Me.emppoint.Value = 2 Case "Excellent" Me.emppoint.Value = 3 Case "Fair" Me.emppoint.Value = 4...

Hi SQL Hell Thank you for your help and time. The data is in the combo box already, ( multiple choice ) Poor Fair Good Excellent Johnn C :)

Hi SQL Hell I have a table with 15 fields two are (datein,dateup), none of the dates are a primary key on this table. I do need to display both (dates ) in my form datein / right click / properties / locked = yes ( This Works ) Tables datein / default Value = (getdate() / Formula...

Hi SQL Hell This is what I try to do and is not working ??? Private Sub emppoint1_BeforeUpdate(Cancel As Integer) If me.txt_empappearance = poor Then me.txt_emppoint1 = 5 If me.txt_empappearance = Good Then me.txt_emppoint1 = 10 If me.txt_empappearance = Fair Then me.txt_emppoint1 = 15 If...

Hello, all you out there, I am building a new database for my business, and I have a question and hope someone can help me. I am working with Access 2002 and SQL Server 2003. My Question is just this , I have a field called empappearance , and it is a combo box, in the box we have Poor = 5 ...

Datein – Dateup Hi, all I have a table with 2 fields One is call datein ( This is a date field and will never change )( LOCK ) One is call dateup ( This is a date field and will change when every someone opens ( go's to update this file .) And that is my question how do I Lock One, and let...

Thank You pdaldy for that information It Work....... Thank you many times over. Johnny C

Hello all I have one question, I have a table with 5 fields and one of the fields I need a default “JC527” ( Column name empnm ) ( Data type char ) ( Length 6 ) (Allow Nulls has a check in it ) I try to put in the Field call empnm Default Value =”JC527” Not Working ???? Can Someone...

Hello Wayne, and thank you for your time. I have found the problem it was in the properties What I had was in properties Name emppoint1 And the control source emppoint1 and that was the problem The control source should have been empappearance, now I get a return, But I do not get the...

Hi, Wayne and thank you for your Time.... I know that in access we can use an AutoNumber But in SQL no AutoNumber. And I do not know what an RatingID is. How can I add a new RatingID What else can I do if i change BeforeUpdate This code not working . There must be somthing that I am...

Hi Wayneryan, Thank You for helping me. I have a field called empappearance and it is a combo box with a multiple choice Poor , Fair, Good, Excellent. Now I have a field called emppoint1 and this is a number field only I go to emppoint1 , I right click on to properties, then I right click...

Hi Keep in mind that I am a novice. Private Sub number_BeforeUpdate(Cancel As Integer) If empappearance = "poor" Then GoTo 5 If empappearance = "Good" Then GoTo 10 If empappearance = "Fair" Then GoTo 15 If empappearance = "Excellent" Then GoTo 20 End Sub This is not working either. I am...

Yes it was the Primary Keys and I was beating up myself for 4 days off and on. Again Thank You For The Help.. Johnny C :)

Is this what you mean. Private Sub number_BeforeUpdate(Cancel As Integer) If empappearance = poor Then emppoint1 = 5 If empappearance = Good Then emppoint1 = 10 If empappearance = Fair Then emppoint1 = 15 If empappearance = Excellent Then emppoint1 = 20 End Sub Johnny C :)

Hello, all you out there, :) I am building a new database for my business, and I have a question and hope someone can help me. I am working with Access 2002 and SQL Server 2003. My Question is just this , I have a field called empappearance , and it is a combo box, in the box we have Poor = 5 ...