Recent content by LilyK

Thanks, working on it

Hi, i need help! Does anyone know how to do the log user activity for ms access ? Is there any simplest way of coding to do that

The entities are with me, I do it already and still work on it. I already try the revised version and it works well :) Thank you so much @jdraw for your time and big help! You're so cool. I will try my best on learning more about Ms Access. Thank you and Have a nice day!

Noted, thank you for the explanation. Much appreciated. I will work on it. My purposes are : 1. To store all the business transaction in-out records in the database. 2. I want it to be easy for tracking records in the fastest way. For example: On 3/1/2021: Mr. A has received an Invoice from his...

Oh sorry, actually it's DateID. Actually, I want my main form representing data for my subform (DateToday) It is like, want the list to be appeared according to DateToday. Referring to the buttons, I just took them from the design tab. I thought it didn't affect much......... and sorry for...

Nothing much, just edit my primary key and corrected the mistakes that you just highlighted before! do u have any idea about my question in #64 regarding the deletion of the record? :)

Hi @jdraw thank you so much for your help! it works :) I have one more question, referring to this jpg: Am I doing the right way of deleting the record? It is because when I click yes, it did not appeared in tempAuditRec and it is gone permanently. However, if I click no, It appeared in...

Here is the copy of my database .. 1. I can't delete records in my subform where the error occurred Run-time error "13": Type mismatch I don't know what is the mistake... 2. Is there any possibilities I can save the data of the deleted information like this tutorial: . I tried to follow this...

Hello, thank you so much for this thread, its soo good. But i have problem, it appeared "run time error: 13 type mismatch. Here is the code Private Sub Form_Delete(Cancel As Integer) 10 gRecID = Me.Reference_Number 20 If show Then Debug.Print Me.Name & "...

Hey @andigirlsc . Thank you so much for the template. Well appreciated. here i have one question.. How to track the deleted record? Edit and new worked well for my database but i need one more which is delete . Thank you!😊