Search results

[Solve] Highlight field based on condition. Please help! It works! I can't express enough how much I appreciate everyone for your help!:) Best regards, Ktran

Thank so much for your help, Galaxiom and The Doc Man!:) I tried the conditional format and also the current event. But it is not exactly what I want. The highlight only happens when the [ReceivedDT] is null. If the [ReceivedDT] is entered, then no change. I like to use the conditional...

Hello, I need to highlight [DueDT] when it is due 10 days from today and part has not received in [ReceiveDT] when form is open. Can someone help me with the code please? Your help is appreciated. Warm regards, Ktran4

Thanks for your help, Ranman!

Hello, I have a table with fields [Request Type], ]ShipDT], and [DueDT]. 1. How do I have a pop up message to remind user input ECO# in the [ECONum] when the value ECO or I&O is selected for [Request Type]? 2. Can I set default value for[DueDT] 30 days from [ShipDT]? I entered...

Thank you so much, Sir! I am not a programmer. I hope I can follow your direction. Best regards!

Hello, I spent a lot of hours searching for How to autofill the User name when a new record is created. I have an New Order form, EmployeeAccess form with UserID(Primary key) and Username. When the New Order Form open, I want the Sale Person name autofill the name of the user opening that...

Hello, I am not a programmer and only know basic Access. I have learned a lot form the Access Forum long ago and just returned. I appreciate the Forum members in advance for everyone support. Best regards, Kim Tran