Search results

Thank you very much for your help. I appreciate your assistance and the time you dedicated to this thread. Regarding the issue with the form, if it's enabled but does not allow access to Add, Edit, or Delete functions, and users encounter 'error 94' when trying to access these buttons, the best...

I appreciate your understanding regarding the delay in my response. The issues your encourage, I encountered while applying and running the solution, it's possible that there were mistakes due to changes in table field names, form textboxes names. Could you please reviews and provide me with...

I appreciate your gratitude for the time and effort in consolidating the code. I am optimistic that it will function seamlessly. Once deployed in my system, I will provide you with feedback, how its performance with me. Thank you once again.

Your form currently allows users to edit, delete, or add records comprehensively. However, if I desire certain users to have the ability to edit records while specifically restricting access to particular fields, how can I achieve this ? Do you have any advice for it ? I have this app Form Main...

I'm glad to see it that I found the initial look appealing. I work on deploying my form, and when it's ready, I can reply to share my progress and ask for further any assistance If I need. Please response. Thank you very much for your kind words.

Thank you for your detailed explanation and the thorough discussion about implementing your system. My requirements align closely with your suggestions. Currently, I don't have a system in place for sending a verification code via email, but I plan to explore that option in the future. In the...

Hello, I've developed an HRM database where I aim to establish a comprehensive User Control and Permission System, delineating who can edit and who can only view data. Currently, I've implemented separate forms for each department, incorporating additional enable/disable functionality from a...

Maybe you dont read this line : "Administrator will give USERROLES only." Question : How he is log on database where USERROLES is null. And USERROLES with admin.

My apology delay reply. Thank you very much for your advise . herein some users does not like to type they're user name, the reasons I instead combo. I given a features to user himself fillup form data details then Administrator will give USERROLES only. Such as, if user is forget password...

here is it...

Report, how to know what is the userId...

=TempVars!FirstName & " " & TempVars!LastName & " " & TempVars!UserName not work. Only userName display then tried =[TempVars]![UserName] & " " & DLookUp("FirstName","Users") not work

any idea, how to stamp with "FirstName + LastName" ? EDIT : users TABLE data source is like : UserName, FirstName, LastName,

Thank you very much, I would like who is logon app and stamped his name in the footer. this is kidding ! I don't believe it. one hours I had tried it many ways to resolve it. now a simply code is work. Thank you very much. I appreciate you.

Hi, any help will appreciate. I have multiple users. I would like to do, if user logon and open the report then his/her name is stamped in the report footer. I'm tried it many ways to resolve this problem. Here is show you.. I tried it by TempVars function in Open event. Private Sub...

Nice ! Thank you very much, I appreciate you. I test your code, Its worked . if you have to put 'Form_Unload' event. I can't put 'close button' in this form, I had setting this form open and hide. when user Log off then it is closed.

Thank you very much sir. I appreciate you. Your code is given two recored, "Pending " & "Completed" However, exactly I would like to Login recored ID had time stamped and same record to LogOff to saved in the table. I modified your function : Private Sub LogActivity(activity As String)...

I expect to see like that User Access ID OS User Name IP Address Computer Name Activity Login Date & Time Activity LogOff Date & Time Activity Status -1199581822 win 1.1.1 HRD-01 01/08/2023 16:10:21 01/08/2023 16:10:23 Completed 1690895412 win 1.1.1 HRD-01 01/08/2023...

Thank you very much. Its not stamped same UserAccessID. See User Access ID OS User Name IP Address Computer Name Activity Login Date & Time Activity LogOff Date & Time Activity Status -1199581822 win 1.1.1 HRD-01 01/08/2023 16:10:21 Pending 1690895412 win 1.1.1 HRD-01 01/08/2023...

Great, Thank you very much. qdf.Parameters("[ActivityLogOff]") = IIf(activity = "Logoff", logOffTime, Now()) Its now stamped. However it not change "ActivityStatus" = Completed EDIT : Now get a error :3314