Search results

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.

didn't know you added to my DB. I'll look at it now.

I didn't know there was a BasTaxCompute module or QryStateTax_arnelgp. Where are these?

Could you please explain what Local variables means? And what does declare and set to the cdbl() version mean and where would I do that? I reviewed what I had typed up and realized I entered it as sql code instead of following your example. Looks like the only places a problem is appearing now...

I just realized I may have copied some other stuff that shouldn't have been there. I fixed that but have a couple of questions that I will ask Isaac.

I am just starting my first VBA. Actually I think i could have had it done in less than 2 day after I started. I still trying to work through what I did incorrectly because it won't load into the query yet, but it's a work in progress. I posted what I did so see if anyone could help if you want...