Search results

I tried this with the same results Private Sub Form_AfterUpdate() Me.Recordset.Requery End Sub Same results. It starts a new record in the 2nd subform

This is what i currently have Private Sub Form_AfterUpdate() [Forms]![frmPayroll]![frmCDpayrollrecommsub].[Form].Refresh End Sub

How is that done?

https://www.access-programmers.co.uk/forums/threads/after-update.333880/ I just realized I had posted this question a couple of weeks ago, I thought it was fixed, I guess the problem persists. I don't know how to remove this post. I have a form to create payroll checks. It has 2 subform, 1...

Great, say when.

Is there? 🤯 We should have coffee together someday.

I figured out my issue. Wi State Tax is calculated off annual income instead of the amount of the paycheck. All other taxes are calculated off the amount of paycheck. I need to back track my calculations and see how I can adjust it.

I have all taxes except the vba calculated with macro

If I go to the next record and back, all taxes update except the vba code tax

The WI State Tax that is written in VBA is only thing that will not update.

I have a Recalculate Taxes button with a code to requery the form frmCDpayrollrecommsub that was working before I calculated my taxes in a vba function. Now I have to go to the next record and back to get it to requery or recalc. I've built a macro to requery the frmCDpayrollrecommsub and...

On my Payroll form, I have a button so when I update the Basic Salary, the deductions would recalculate or requery, it's not doing that anymore. When I had my deductions build in 4 IIF statements, my deductions would requery or recalc on the fly. Now that I have a vba calculating my taxes, my...

Thank you. After much trial and error, i got my first one to work. Thanks for the tips on how to get started.

I am working on finalizing a query to calculate Payroll taxes. The last 2 queries be going to a form are QryStateTax which calculates with the 9 employees as it should. It then feeds that information to the qryCDpayrolltaxesWI which adds the St Tax Table to calculate the income if Marital...

https://www.access-programmers.co.uk/forums/threads/combining-iif-statements.333918/

I still need the qryTaxState. I needed it to calculate all the taxes to one column. Thus why I wanted help combining the IIf statements. I had to learn how to do a vba and calculate them all in that. Thank you for your help.

I'm trying to test my adjusted code in the query to see what it produces. I need to reference 2 tables of data. Does this look right?Expr: WITaxCalc([tblEmployees].[Marital Status],[Basic Salary]) And ([tblpayrolltaxes].[Lower],[Amount from Column A]) I see a bunch of people have jumped in, I...

Thank you, that hint helped. I wish there was a class by me.

That is doing what I had it doing. I need them to total all in the same column.