Search results

Is there a way to return an ID from another table if criteria is met. Ex. If an Employee has 12 pay periods, taxes are filed individually, Minimum is >0 and <2500 (All of these fields would be in the Tax table) and return the TaxID to the Employee table that matches? Or to have a query that...

The problem is when I do Me.Recalc on Amount in the subform and I enter data in the subform, I get to the end of the record it jumps back to the first record and not a new record

Towns have very little liquid revenue available to buy expensive software, therefore, it won't happen and they will continue to use an excel spreadsheet to do the calculations.

Well, that makes 2 of us.

It totaled for me, but when i hit tab as the end of the entry, it goes to the first record instead of a new record.

It totals for me, but when i hit tab at the end of the record, it goes to the first record instead of a new record.

Here is the DB. Open form Pay Vendor. If I remove the "After Update", Me.Recalc, it will proceed through the form. I am also including Information to enter so you don't have to try to figure it out.

If i tab through the record that were entered again, then it advances.

I just tried it, still goes back to the first record not a new record.

I have a subform that "On update" of "Amount" I have Me.Recalc to update the Sum on the Main form. When i tab through the end of the line it goes back to the first record instead of a new record. Thoughts on how to fix this?

I think I finally succeeded. I tried this Private Sub Total_of_pay_Check_AfterUpdate() Forms![FrmPayroll]![frmCDpayrollrecommsub].Requery End Sub AND created a update Salary button to update the Employee table. Then it worked.

I tried this Private Sub Total_of_pay_Check_AfterUpdate() Me.Requery End Sub It does a requery of the frmpayrollrecommsub but then exists to the first employee and starts a new record.

I don't know what you mean by Intellisence List. I did a decompile but it didn't help

I tried Private Sub Total_of_pay_Check_AfterUpdate() Me.frmpayrollrecommsub.Form.Requery End Sub I'm getting Compile error, Method or data member not found

I have a Main form with 2 subforms. The main form contains records from the Table “Employees”, showing “Hourly Rate, “Hours per Pay Period” and “Total of paycheck”. I have added a Text Box that calculates Overtime owed if there is any. Subform 1 shows the calculation of the Taxes owed from the...

This worked, thank you.

I have set the DataEntry to yes. How do i sent CheckNr DefaultValue to to repeat?

I want the subform to show each check individually instead a continued form. Would changing the subform to add mode do what i want it to do?

I don't want a continue form. I want to see one check at a time or enter a new check. Does that make since?

On form frmPayroll, I want the CheckNr field on the Main form to group the subform checks and be able to add a new check.