Recent content by mobaligh

That worked fine. Thanks

Is there a way that I allow users to type the date at 051507 and access converts to 05/15/07 in form. Basically user would enter the date without the / in a date field in a form and system adds the / after the month and date.

thank you very much for emailing me the db. A few issues number one when I refresh tblemployees with new data by importing data from excel into this table the changes doesn't work. Second I am sorry that I didn't tell you I don't want to ues query payment for this form I wanted to use quryentery...

I am going to email you my database. I hope you don't mind

I am attaching my database for your review. please look at tblEmloyee_read_data_etnery form

now I am getting a run error 2465 on the this line MsgBox "Current salary should be [" & [Annualsalary] & "]"

Ok I tried that I am getting an error. I am getting an error if I put salary or txtsalary ot Text43. Private Sub Form_Current() If Me.NewRecord Then Me.salary = [tblEmployees].[Annualsalary] End If End Sub

SELECT tblEmployees.*, tblEmployeepayment.PayPeriodDt, tblemployeepayment.PayBegDt, tblEmployeepayment.PayEndDt, tblEmployeepayment.PartialPayment, tblEmployeepayment.NumberofHrs, tblEmployeepayment.SDADailyPay, tblEmployeepayment.salary FROM tblEmployees INNER JOIN tblEmployeepayment ON...

Here is the code . In tblEmployees it is annualsalary and in tblEmployeepayment is salary about the SQL from the query I created right? Private Sub Text33_BeforeUpdate(Cancel As Integer) If Me.NewRecord Then Me.txtSalary = [tblEmployees].[Annualsalary] End If End Sub

I haven't started that yet the solution you gave me for updating the salary field in the tblemployeepayment is not working I didnot change anything since. I am not sure what to do?

That worked just fine. Thank you very much. I have a form that user would check employee payment history. I would like to allow users to enter a employeeid and click on the go button and then I would display information based on the value they put in the employee field. I am new to access and...

Can you give me a little more how to use the current event of the form to update the salary field in the tblemployeepayment.

but if employee salary changes the query results will changes. I get the salary information from our payroll system. I want to keep salary history. I want know what was empoyee salary each pay period. Like EmployeeID Name Salary Payperiod 123 XYZ $100 05/15/2007 123...

Hello, I have two tables, tblEmployees, tblEmployeePayment. tblEmployees has the following fields. EmployeeID Name Salary Status Employeegroup Data for this table comes from our payroll system. The other table, tblEmployeepayment, which has many to one relationship with tblEmployees has the...

Can someone plz help. I am very new to VB I have two tables in my database Employee table and LOA Table. On the employee table I have the following fields. Emplid EmplName EmplSalary On the LOA table I have Emplid EmplName EmplStatus Period_bg_dt Period_end_dt EmplSalary Number_days I...