Search results for query: *

These changes worked like a charm..........thank everyone so much! Dim SQL3 As String SQL3 = "UPDATE Tbl_TechReturnsInTransit SET PutAwayLocation=[Forms]![011 Tech Returns]![TxtPutAway]" _ & " WHERE [STO#]=[Forms]![011 Tech Returns]![txtSTO] AND Material=[Forms]![011 Tech Returns]![Material]"...

Thank you so much, this worked!

Thanks

I changed the bookmark to variant but the loop still stops before updating the last record. As I said it steps through all 8 records but when you go to the table only 7 are updated.

The space issue is because of the copy/paste into the message, it is OK in the code. The loop works unit the last record (without the loop the SQL statement only updates the first record). There are 8 records, it says it's updating 8 records (I have not turned off the warnings yet) but only 7...

Hi, I am really a novice and am having an issue with a loop. I have a continuous form that has a calculated field. I need to have the field update a table. The loop works but does not update the last record. Don't laugh when you read this, like I said I am a novice. Can someone tell me what I am...

Hi, I am really a novice and am having an issue with a loop. I have a continuous form that has a calculated field. I need to have the field update a table. The loop works but does not update the last record. Don't laugh when you read this, like I said I am a novice. Can someone tell me what I am...

Never mind, I figured it out and got it working (sorry for the bad spelling, it never was one of my strong points!). The issues was with the Dlookup and the number of quotation marks, didn't know I needed so many!.

I have a form that was working as required until management decided to through a wrench into it by taxing my mind.........This form is used for a simple database to put stock away in a warehouse, assigning it to a location and updating a transaction table when completed. Here is the...