Search results

Yes

It is a datasheet form. I want additions as it is for entering data. Is there a way to keep the line from loading empty?

Sorry, my error. I'm still trying to figure out the forum. I marked it as solved.

I am assuming that is where the blank rows are coming from. I'll check again tomorrow as I had a couple other errors to work through.

I have a subform that I am entering records related to the ClientID on the main form. It creates an extra blank entry when i enter the line prior. How do i stop it from doing that. Image attached.

As i said at 11:54, that fixed my error.

The field is only a number field that i enter overtime hours for the employee to show me how much is owed for overtime. I enter the hours in the field and have another field that tells me how much overtime to pay. It does not fill another field with information. Next payroll, the employee may...

It's a field used field calculation only

That worked. Thank you. You guys are amazing when I can't work through stupid errors.

I'm trying to change a Text Box "OT Hours" to null when i go to a new or next record. I have tried this on the form and field Expression and it's not working. Private Sub Form_Dirty(Cancel As Integer) If Me.OT_Hours Then Me.Undo End Sub Private Sub OT_Hours_Dirty(Cancel As Integer) If...

It is numeric. It worked. Thank you.

I've also tried this and the results are "error". Federal tax: IIf([Basic Salary]>"17100.00",[Recommended ded],0)

I'm trying to build an zoom expression in a query where if Basic Salary is >17100 to return an already calculated result, else 0. This is my expression: Federal tax: IIf([Basic Salary]>"17100.00",([tblEmployees]![Total of pay check]*[tblpayrolltaxes]![Percent of Withholding],0)) I'm getting a...

I'm trying to build a calculated field in a table and i'm getting the error "The expression you entered contains invalid syntax". This is my expression: IIf([Marital Status]="Married", [Basic Salary]<17100,0) IIf([Marital Status]="Married", [Basic Salary]>=17101,12) IIf([Marital...

Not what I wanted to do, but I understand. I will make the changes.

As i said, i want it by Check number not client #

Except that i only want the information for a check and not a client.

As i said, this is a database I inherited and I don't want to start back from scratch to redo it. I'm trying to work with what is there. Do you recommend i that the special characters out? It would take a while to follow the paths to make sure it go everything.

open the Transactions Form View. When i started typing in a check number, Information would jump around in the subform. For some strange reason, now i can't recreate it. I want to give you some information about the database. I did not create this database. It was created by a Professor in the...