Search results

thxs Jack. I will chk comments and details will keep u posted

thxs for ur help and for chking is it better to use embedded macros or the procedures for the buttons?

extract and shift click to have access to db. it's a single form customer with search option and 3 button add new, save and delete button previous code was wrking for add and save in audit table but delete was deleting the next record and recording wrong Id. I've changed it to shared post...

ive tried the code mentioned in the previous attached post.. and the audit trail (edit new or delete not working dont knw what i have missed out :( Can anyone help pls ?

@the DBguy, the pattern is tht it's deleting the next record in the DB instead of the actual record. so the null recordid and emplcode for action delete was there is empty record at last.

yes.. ive been using FontStuff example to do the audit trail..

Any suggestions pls? or is there another alternative to log the delete action, id and code in the table or by a macro??

well i dont find a specific pattern. :( If i comment AfterDelConfirm code, then no record for the delete action are log in the audit tbl If i comment ONDelete code, then action = delete is added in audit tbl , but other fields ID, code are blank in the audit tbl If i uncomment both code...

hi, the delete audit trail log is quite weird. at times its populating the ID and code action = delete and at times it's only action = delete other remain blank or even not adding any record in the log table :banghead: any idea

hi, This one is working.. im using input mask "A "0000a;0;_ the last character is treated as optional and allow input of the 4character if less character is input getting error msg. I need a help for.. ive added an before_update on the field Emplcode to check if the code entered already...

DBGuy, yes ur right it's ok with ondelete THANKS a lot for your help

hi theDBguy, Latest DB attached. Pls advise.

I had added: Private Sub Form_AfterDelConfirm(Status As Integer) If Status = acDeleteOK Then Call AuditChanges("ID", "DELETE") should code be changed for delete?

One more help pls :( after add the code, the delete audit not working as expected. the record ID and Empl Code is BLANK Action is set to DELETE, ChangeID, DateTime, UserID, FormName are updated with values. but not recordID and EmplCode Any idea?

Thanks a lot theDBguy & CJ_London for ur help :) Its working wz: Screen.ActiveForm.Controls("EmplCode").Value

hi, ive tried to use "A "000;0 input mask but last number / character not becoming optional.

yeah that's right. didnt notice it.. :( It's working now :) thanks a lot!! Other than recordID, how can i amend the code to include the emplCode field being amended in the audit trail table? or can i shall i concatenate the employeeCode with the record ID?

thanks a lot it's working btw is it possible to make the last character optional ?

ive removed the format @ and used the "A "0000, in the table design. but its accepting when inputing same in the form. should another steps be done?

HI Can u pls help, ive tried to add the input mask in attached db But when entering the value from the form its not triggering the validation can you pls check & let knw whts wrong? thxs