Search results

I'm trying to use a DMax in a Continuous Subform to autopopulate the Date by the last entered Date in the Table. It works for the first entry but if I change the Date to a different day the next line populates as 12/30/1899. I have this code in my Default Value. Any help is appreciated...

I have a query that is supposed to find Marital Status in a table then between lower and upper limits and return lower limit, else 0. It is returning all the records. The query is QryFedTax1, pulling data from QryFedTax. I know there as some fields that can be removed form QryFedTax but I don't...

In my database, when I enter a revenue in the Revenue form, it creates a new client even though I'm selecting from the client list. Any ideas why it does that? Should I create a save button? DB is attached. I just tried a save button and it still creates a new client.

I have a form that searches all Vendor payments and the subform produces all the payments to that vendor. I have created a report that prints the results by clicking "Print Report" button. I would like to clear the data on the form when I open that report. Attached is the code that opens the...

I have a Database that I use as a Template to load new data into when setting up for other people. When I append the new data it does not start at 1. With the database empty, I have created a new ID with Auto Number in each table and I have compacted the Database. The appended Data does still...

I have a form that filters data by the DemoClientID to the subform. When a Client is selected on the form it brings up all the records for that Client in the subform. I have created a report that contains all the data I want to display and I have created a button to open that report. I want the...

I have a form with Vendors that enters information to the tblDemoTrans and a subform that the Receipt information from the Vendor entered into. I want to do a DMax on the ReceiptNr field in the subform. I have tried: DMax("ReceiptNr","tblDemoTrans") + 1 and...

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...

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...

Isaac wrote me a sample VBA. Where does this language go? Does it go into the query itself or into the sql version. I'm trying to learn where the vba would go? https://www.access-programmers.co.uk/forums/threads/combining-iif-statements.333918/post-1961313

I have 4 IIF Statement that calculate State Taxes for marital status: Married, Single and greater than > income, or less than <income for each marital status. All 4 Statements end in -([Exemption credit]) or -([Exemption credit])). They work individually they way they are supposed to. When I...

I have a query expression with some of the results being a negative numbers that I wish to change to a 0. I have Salaries minus several deductions created several "Employees" to be negative which means they get a standard deduction so I want the results to be 0 instead of negative. Net Wage...

I have 2 IIF statements that work individually, when I combine them I get this error, The expression you entered has a function containing the wrong number of arguments. What am i doing wrong? IIf([tblEmployees].[Marital Status]=1,[tblEmployees].[Basic...

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...

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 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...

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 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...

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"...