Search results

Yes you're right I've some spelling mistakes ,,, but it's not in the vba I tried the right syntax and used the "debt.value" but the same unfortunately I'm still waiting for help

I tried If CutomerName.Column(4)="Debt" Then Me.Debt = CutomerName.Column(3) Else If CutomerName.Column(4)="Credit" Then Me.Credit = CutomerName.Column(3) End If End If but nothing occurred

Thank for reply but I need to get the data from Amount and put it in Customer debts or Customer credits according to it's status.

Hi Brothers, I've a Sale Invoice form contains : Invoice No. , Invoice Date , Customer Name , Customer debts (Number) , Customer credits (Number) ,,,,,, etc. The field Customer Name is a combo box, it's row source is query contains : Customer Name , Amount , Status(Debt,Credit) I need to get...

well ,, I will

Yes I've tried that

I tried but failed it doesn't go with me

right,, exactly

Version 2007 but the files are designed on 2002-2003 and 2007

Welcome Back Brother , it's been long time Which form do you mean ?

Dear Brothers, Suddenly I found the Addin toolbar disappeared in some of my Access files I don't know why this occurred If someone knows and could help I'll be appreciated Thanks in advance

Well, Well, Well, ;)

Hello Stopher Are You still with me ???

it gives value match with the user's value according to the calculation I'm expecting all four entries to match with the corresponding calculations because all the four entries must be right to let the user log on

Made as you said but the same result gives me message that "the registration Code is not valid"

Yes, now no errors and the values in the Immediate window of the VBA editor that I expect but the problem still exist,,, I can't logon

I made as you said when the form load gives error message : "Compile error : Invalid use of Me keyword" and Highlight on the line that we've added and refers to : debug.print Forms!KHEPRE!HardiskSerialNo.Value, Me.txtSerialNo1.Value,Me.txtSerialNo2.Value,Me.txtSerialNo3.Value,Me.txtSerialNo4.Value

The problem is the Vba Code doesn't work with me, I think the Vba Code is right but sure there is something wrong. I'm filling the textboxes by the values that should be entered. It supposed after I click enter, let me log on , but it gives me message that "the registration Code is not valid"...

Hello brothers, I need your help if someone can Thanks in advance

Hello Brothers, I have a form that requires serial no to enter the database this serial no is depending on the HD serial no after calculation but no way to enter. The code I'm using On Click event on the form: If (Me.HardiskSerialNo.Value - 479277050#) = Me.txtSerialNo1.Value _ And...