Recent content by lsgls

Thanks Remou! its sorted, i'd actually done it right but i'd accidently typed one of the field names wrong! its all sorted now and works how i wanted it to. many thanks

i am using the after update event that is why i;m confused by the message

ok, ive just attempted that, it all made sense however i think i may have done something wrong, i have input the code as per your comment and when i select an employee from the combo box it says the following warning : Wages Database can't find the macro "Me." any ideas?

if i set up a default within my tables it wants me to put a constant value, how can i set up a default based on the employee id selected? do i do this within my form or from the table

Any help on this query would be much appreciated because i have still been unable to find a solution myself. thanks

i understand that i think, however, my main problem, which i dont think i explanined properly is that, currently my data is normalised and i have wage rate within tblemployees. therefore when you change this wage rate all reports change. this is bad because should you require a report from a...

I have a database set up which calculates weekly wages of approx. 40 employees. As it stands it works well, however, i am having an issue with a wage rate field. Each week my end-user inputs the hours each employee has worked against the week no., period, employee id etc. This data combined...

tblCostCode CCId, Text, pk CostCode, Text tblJobs JobId, AutoNumber, pk JobName, Text JobAddress, Text tblWeeks WeekNo, Number, pk Date, Date/Time tblSuppliers SuppId, AutoNumber, pk SupplierName, Text tblEmployees EmpId, AutoNumber, pk Surname, Text Forename, Text WageRate, Currency...

I have database in Microsoft Access which I would like to extend and use as an analysis tool. The database currently holds wages data and invoice data, to enable us to extract information to correctly pay our employees and to find out the running costs of our jobs. Each week, the hours worked...