Recent content by brpallet

You can also enable the * if you use the Like parameter: Like [Enter Job Number. Use * for partial entry] Type *020401 and it will return all records with that sequence at the end. This eliminates the need to enter only the last 6. You could use the entire string or the last 5 or...

Thank you ajetrumpet for taking the time to help. I tried your file and could not get the send keys to work. When I tried the buttons it would flash the screen and advance to a new record but did not hold the combo box value. I think because it is tied to a table. Also the prev employee...

Here is the database with only a few records. The problem is on the payroll form. Also if you could help with the formula on the punch detail page that calculates the hours I would appreciate it. The code should be written to roll through the employees and once a record for the last employee...

I will post something this afternoon.

I need help writing a line of code that creates a new record and populates a combo box with the next item on the list. I have a form for employee time that has a combo box with employee names and a subform for the time punches linked to the employee. The combo box is bound to the employee id...

Thank you for the replys. Droping the Build Criteria worked great! I tried adding the "Me." before the combo19 but recieved the same error. Got any ideas why the build criteria don't work?

I am trying to filter a datasheet form using a combo box and have not had any success. The combo box is located in the form header and the code is tied to the change event. I keep getting the following error. Run-time error '3075': Syntax error (missing operator) in query expression...