Search results

I remember now why I appended the payroll after every payroll. I want to filter my subform by each CheckNr. I don't want to see all the checks. I'm not sure I can do that. I have the subform set up now to write directly to the tblDemoTrans table instead of appending. Any ideas how to filter the...

It wouldn't return the ID value. I believe I found another way. As always, I appreciate all your help.

I have cleaned up the Employee table. Now I want IIf ([tblEmployees].[MaritalStatus]=[tblpayrolltaxes].[MaritalStatus] AND [tblpayrolltaxes].[MyUCA]=21512, [tblpayrolltaxes].[TaxID]) I can't get it to work

Thank you. You are right. I'm cleaning it up

I have the taxes all in the same table Federal taxes for Single and Married, State taxes for Single and Married, Social Security for Married and Single, Medicaid for Married and Single. So I need to add a TaxID for each Employee for each tax to the Employee Table?

I am building a query to show all payroll taxes for Federal, State, Social Security and Medicare to match the Employee and ClientID. All 4 taxes are in to seperate queries that calculates the tax based on the pay period salary. I'm now combining the Employee table and all 4 queries for taxes...

I'll remember why shortly

Good question. At the time I did this, I had a good reason. Don't remember why now but I will look into that.

In the US, they take taxes out only based on single or married. They don't care to who or how many. Lol

I have a Payroll form that when I fill it out the MyUCA is correct. I run an Append Query to move the data to the tblDemoTrans. When it transfers it changes to the ID of tblDemoUCAs. Attached is screen shots of how it is entered, how it transfers and where the number is coming from. Thoughts on...

It's a Parameter

I understand. This is an old Database originally design in a Dos Program. This is enter Parameters for check printing. It asks for the Start of the CheckNr and the Last CheckNr. It is when it asks for the first CheckNr and it is canceled instead of enter the CheckNr that it would through the...

This worked fine until I had to add "Marital Status" to my tblpayrolltaxes. Now I am getting the "Enter Parameter Value", "tblEmployee.Marital Status", on run. I have Marital Status as the join which calculates correctly when I click Ok. SELECT tblpayrolltaxes.MyUCA, tblpayrolltaxes.[Percent of...

I have reports that are triggered off parameters. When the first parameter request comes up, if i cancel, I get "The OpenReport operation was canceled". How do i get it to cancel without the error? This is my code Private Sub btnPrintChecks_Click() DoCmd.OpenReport "rptChkWrite"...

I think i finally got it. Thank you.

I have a Payroll table that when payroll is due, i run the append query to add it to my transactions table, then I run a delete query to clear out those records and start a new pay period. I created the delete query which works and want to set up a button to run the query. That query is not an...

I found i had redundant joins. Once i fixed those and rebuilt the form and sumform it fix my problem. Thank you.

I corrected by redundant relations and rebuilt the form and subform. I fixed my error.

Yes, several times. I just found an redundant relation. I'm going to try rebuilding my subform and see it that fixes it.

My subform was working fine. After I appended the data to another table and deleted the records in that table I started getting the error: A problem occurred while (database) was communicating with OLE Server or Active X Control. Close the OLE Server and restart it outside of (database), then...