Recent content by Zhang

When I use the code on BeforeUpdate event in the form for addition the timestamp doesn't updated till the form being dirty

I put the the code on before update in the Edit form and I put it in the form load event in the form of adding new records

I used this lines in before update event If Me.NewRecord = False Then Me.Enteredby.Value = CMAID Debug.Print CMAID Me.DateEntered = Now End If but it doesn't work as expected, if i inserted the code on form load event it works but creates a new record any suggestion

I have fields in the table for dateedited and edited by, but I need to catch the time if the data changed if in a main form or subform.

hi, I have a form for edit the records, I need to insert the edit date/time if any of the controls on a form changed. any suggestion

Thank you very much for your dedication, I used an error handler

theDBguy You are Great I used error handler, Please, check my code if there something wrong, or something missing Private Sub Save_Click() Dim icount As Integer, cancel as integer On Error GoTo errorhanlder If Not IsNull(Me.InspID) Then icount = DCount("*", "tbl_InpectionDetail", "inspid = " &...

Is there a way to cancel moving to new record if before update event fires

I have before update validation and it fire when I click the save button but I get error from this line [DoCmd.GoToRecord , , acNewRec] Private Sub Form_BeforeUpdate(Cancel As Integer) If IsNull(Me![ProductID]) Then MsgBox "You must select a product Name before these report can be saved"...

I removed it, in the new code how can I add error handler

Hi, I have a main form and related subform, I have before_update code on the main form to check the required fields are entered. Access saves the main form record if I set focus on the subform, and saves the subform records when set focus on the main form when I enter the main form records and...

Hi, I created a counter table and using a query we will get the required labels thank you:)

as we are working on mass production process, so the user enter the quantity per package as it would vary because the customer issues a purchase order with quantities and we fill this order but not all the quantities required at a time we send the quantities on stages so the quantity of package...

you are completely correct the user enter both quantities, package & product quantity the package entered and stored just for printing the labels and to follow up how many ctn has been transferred to the customer

hi, thank you for your reply the user enters the package quantity and the value is stored in the invoice item line tables