Search results

It was the [Percent]. It is working now. The other suggestions were also helpful. Thanks to everyone.

Hello, Please help. I am trying to make a copy of a record into the same table. When this is complete it will be a feature which allows my users to create Template records which can then be used when creating work orders. I am getting a syntax error on the INSERT INTO. I can't see what I...

Working on that now. Thanks.

Oh. Good catch. I am actually getting QTY from the query not the form. It joins the Work Order table with the Routing Table.

Thanks for your response, but I don't understand how to do that. The Quantity is in the main form. Work Center is in the subform Datasheet rows. I need to call that event for each row of the datasheet. That is what I am stuck on.

Hello, Please help. I am trying to figure out how to recalculate all rows in a subform datasheet when a value in the main form is updated. I can't post pictures yet so I will have to describe my forms. The main form is a work order and, among other things, contains a "Quantity" field which...

So your question got me to look closer at the code I had behind the form, and I realized that I did not need code at "Form_AfterUpdate". So I took it out and now my form works properly. I don't understand why it was failing, but am glad it is working now. If anyone can tell me why it was...

Good thought. Here is the code behind that form. Private Sub Form_AfterUpdate() If [Qty/Blend] > 0 Then [Number of Blends] = [Quantity] / [Qty/Blend] Else [Number of Blends] = 0 End If End Sub Private Sub Form_Current() End Sub Private Sub...

Hello, I am getting this message after updating any field on my form then exiting then form with the x on the tab. All other forms seem to be working fine. Even the sub forms on this form. The full text of the message is: I have looked at a number of posts in different forums across the...

My name is Mike Heffner. I am retired after 50 years in the IT industry. Hard to believe I started in 1968 as a card sorter, sorting cards in a grocery warehouse. The cards were then used to produce various documents on some unit record equipment. I have stories to tell, but enough of that...