Search results

Hi All, I have got a db with a code to allow bypass for the super admin user but the message box views the actual password as the below screenshot. How can I make the Super admin user input in the message box to be replaced with stars ******* instead of the actual text password in the below...

Thank you for your help and support I will apply it in my project 🙂

Thanks for your earliest response, actually I will change those items in the future. Any other suggestions to achieve this as expression query criteria as I requested?

Hi All, I am struggling with the below query criteria to return specific Combobox items depends on another text box field called [test]. 1. if [test] is = "Case" should returns [StatusID] (4, 11, 12). 2. If [test] is = "Form" should returns [StatusID] (1,2,3,8,9,11,12). The issue is that the...

Thanks, I amended the code provided to filter today's records as below and it works fine. =DCount("[ID]","[Open Cases]","[Form] >= 2 And [Form] <= 5 And [Opened Date] >= #" & Date() & "# And [Opened Date] <= #" & Date()+1 & "#") How can I apply it to filter the followings: 1. Todays & Current...

Hi All, here is my db attached, if anyone could help the four text boxes ([txtCardsToday] , [txtCardsCurrent] , [txtCards60Days] and [txtCards90Days]) at the on startup form. Thank you in advance

It's Date/Time data type.

Thanks for your earliest response, unfortunately I got 0 value where there are two records on today's date. How about the other text boxes conditions how can I get their count if more than 60 days and so on. I know I can't figure out those conditions. Thanks for help.🤗

Hi All, I have got 4 text boxes to count the following: 1. Today's items. 2. Today's & Current Items less than 60 days. 3. Items Greater than 60 days. 4. Items Greater than 90 days. I need help to validate the above with below expression control source. Thanks in advance!

I see, thank you for that, for me it not delys, but as I stated above it delays with some users which they have the same new machines like me, I am wondering why it's happening with some users I thought maybe because of the DLookup so that I can use another method. May it could be due to...

Maybe there is something else that's why I uploaded my db as per pbaldy recommend to convert the code to SQL. Thank you!

Please find attached my db, when you open it for the first time you must type your machine's User Name in the UserLogin field at Active Users form. You will find the code at the NavigationForm in the on Open event. Thanks in advance!

Thanks to all of you for the prompt responses. Is it fine like this? Or need to be redisgned to make it faster by the record set approach (I read the DAO is faster than DLookup)? But could you please help me to retrieve data from two tables with one record set statement? Because I tried to do...

Hi All, I am using the below code to identify the current user in the main form [NavigationForm] but I realized that the users are facing a little delay while launching the system. I am using in my code the DLookup function on Open event to achieve that, I heard about the Recordset and...

Thank you so much, I will do my best to try that later, unfortunately, my wife got sick and I will not get enough time to implement this. But once my wife recovered from her sickness, I will follow the steps you provided and let you know the result. Thanks again for your efforts.

Thanks Uncle Gizmo for your attention. I think the second code will fit my desired, that I searched a lot of threads and tried many of them almost generate the QR code but unfortunately, it's not stand alone codes, the user machine should be connected to the internet, and it will not work in our...

I will explore that. Thank you so much, appreciate your usual help.

Thanks again Uncle Gizmo, I followed your procedure in the post 32 Actually the benefit of this code is that you can generate Barcode (Code_39) don't need to install the barcode font to the users (Embedded Barcode). I am wondering is it possible to get the same Embedded VBA 2D QR code?

Thanks to all of you :) it's working fine now.

Thank you so much, I will try it and let you know. I am sure it will work.