Search results

OK Sparks80 - I was totally wrong! This works!! Thank you SOOO MUCH!!!

Sparks80 - YOU ROCK! The problem is I want the EmpID Field in both the Employees Extended form and the Hours subform to match the employee that is selected in the Employee Name field you changed my code on. Does this make any sense? For instance, if Mickey Mouse is selected, the EmpID would be...

Yes- I have been getting that error too. Just accept it and open the Employee Extended form. Click the dropdown for Employee Name to select a different employee. Notice when the information changes - the information in the fields around it do not. Most specifically the EmpID field.

I want the rest of the record to update when I select different employees. The change should happen in both the main AND the sub form. I have saved this as an mdb.

The code I have above works to select the employee name. It doesn't change the record that has been selected for either the main or sub forms. It the space in my field name stopping this from working properly? Thanks.

Good morning. I have a dropdown that I want employees to use to select their name to add time. The following is what I have: Private Sub Combo18_AfterUpdate() Dim rs As DAO.Recordset Set rs = Me.RecordsetClone rs.FindFirst "[Employe Name] = '" & Me.cboName & "'"...

This is great! Thank you! So can we set the match on the name instead of the EmpID? I think it will be harder with my idea. Yours is better. Thanks again!!!!

I have been working with it in 2007. I downloaded the template from the Microsoft website. Can't you open it? I don't have 2010 either! :(

Alright - here you go. Thanks again!!!

I don't think I have been clear. I want to apply a filter based on the employee I select (hopefully a drop down). I will also need to filter based on the PeriodEnding so that only the current period end date shows for the hours that are being entered. Will the code sparks80 do this? Thank you!!!

The main form is called Employees Extended and the subform is called Hours. The main form has the following fields: EmpID Employee Name (This is a combination between the First and Last Name fields in the employee table) this is what I would like to have a dropdown on to select the employee...

Good afternoon. I would like to create a dropdown to select an employee. When I do this (I have a main form and a subform), it won't change the data in either the main form or the subform. Granted, I am most definitely doing this wrong. (Obviously! Or I wouldn't be here right?) The subform and...

That's perfect! Thank you!!!:)

Ok This is what I have for the Pay Period ending. They are different as we are paid bi-monthly. I have gotten several errors though. I don't do well (AT ALL) writing code so your help is immensely appreciated! PeriodEnding: DateDiff("m",[DateWorked],*2 + IIf(Day([DateWorked]) > 15, -1, 0) +...

This is extremely cool!

So Access will understand that, for instance, this week will end on 4/22? Can you provide an example of the code I will use (if any)? Thanks!!:)

Hello. I am using Access 2007. I am creating a time tracking database and I want to create a calculation based on when the week ends. It should give the total number of hours worked within a week and refresh as records are entered. Our week starts on Monday and ends on Sunday. Well this is how I...