Search results

here is what i did to get what i seed and is working perfect LOL i used the code to check if there is duplicate currentdb.execute, dbfailonerror then i created a query to find the duplicate SNs, SELECT ImportSerial_Shipped.[S/N] AS [Shipped S/N], ImportSerial_Shipped.SalesON AS [Shipped SO]...

Thanks Dave, a) currentdb.execute, dbfailonerror I confirm that if you do have an error handler procedure in your code (On Error GoTo ...) it will definitely stop the executing the rest of the code and do whatever you want it to do. but you got to have ,dbfailonerror. the only reason I don’t...

i hope so, but yes the code worked and it doesn't find the duplicate but once there one the error msg pop up. and that exactly what i want. i tried the loop but it is bit confusing please if someone has any idea about "is there a way to include the S/N that was duplicated in the error msg? "...

btw, i don't know if this is possible or not! is there a way to include the S/N that was duplicated in the error msg?

btw, i don't know if this is possible or not! is there a way to include the S/N that was duplicated in the error msg?

i added "dbFailOnError" and that did the trick i could find that part anywhere ... i used true/false nothing work i realy appreciate it ... thanks again

thanks jdraw for the reply, the [S/N] is the Primary Key in the Serial_Shipped table, but the problem is that the code run with no error even if there is a duplicate. but it doesn't copy the new record instead it keep the old one there. all i want it to do is the rais an error msg saying the...

Hey All, I have this code to copy records from the ImportSerial table into ImportSerial_Shipped table where the SO_Finished diff than 11/11/1111 dbs.Execute "INSERT INTO ImportSerial_Shipped SELECT * FROM ImportSerial WHERE ([ImportSerial].[SO_Finished] Not Like " & "'*11/11/1111*'" &...

i had to use Macros to get it to work thanks anyways

anybody has any idea pleeeeeeeeease?

yes and they are the same name anyway SO_ING_Serial_subform

there is something!! i change the code, so i only have this 2 line on button click code Me!SO_ING_Serial_subform.SetFocus Me!SO_ING_Serial_subform.Form!SerialNumberl.SetFocus and i'm still getting the error at SO_ING_Serial_subform it says " Can't find the field 'SO_ING_Serial_subform'

Thanks for the replay, i tried that before and i get a Run time error '2449' There is an invalid method in an expression. and stoped at Form_SO_ING_Serial_subform.SetFocus

any idea please?

i got the part to go to new record by adding this line Form_SO_ING_Serial_subform.Recordset.AddNew but I still want to setFocus on serialNumber

Hey All, I have a main form and 2 subforms inside it. And I when I click a field in first subform I want the cursor to move to the second subform and set 2 field value and then leave the focus on anther field in same subform. So far I got the part to move and set the value, but the problem is...

the only problem though is that the main Tables are on the server side and i have no control over it :( sorry but i think it doesn't look like a bad db design!! :D

that was it :D Thanks a lot

Ms access can't find the field 'Sales_Order_Review' referred to in your expression

hey Bob, I getting a vb error! @ Form!Sales_Order_Review.RecordSource = "SELECT * FROM " & Me.[TableUsed] & " WHERE [SO_ID] = " & Chr(34) & Me.SO_ID & Chr(34) here is the union query (UnionProduction_SUM) i'm runing Select [SO Master].*, "SO Master" As TableUsed From [SO Master] UNION...