Search results

Hi arnelgp, The single date/time is now displayed to all active rows once the BTN is clicked. However, If you will click the button again to display the latest date/time, it still shows the previous result date/time. The required is every time you click the BTN it will gives you the latest...

hi arnelgp, In the attachment you sent, the textbox display different value when moving to different row. At row 02 Sep 2, it whos 11:02:24 At row 03 Sep it shows 11:00:56 The intention is that, at every row , it should shows the last date/time after clicking the BTN. For the background...

Hi, I would like to open again this query that you had resolved. The button works fine, once click it display the current date and time (in "Ldate" textbook). This is after adding the "Ldate" as field in the table. However, when I moved to the next row, the displayed date in "Ldate" text box...

Thank you very much. Works

Hi, I add it as a field in a table and it works even I close it. Thanks I just want to add to my query on how to display both date and time in the textbox? I saw the General option under Format but it only show date thanks

Yes it works, when I click the BTN it display the current date on the txtBox However, when I close and open again the access file, the date is not available anymore. It should be retained in the txtbox even I close it. And once I open it again and click the BTN it should display the new...

Hi Eveyone, Can someone please help me to create code as per below screenshot. The purpose is once I click the button "BTN" it will display the current date in the unbound "LDate" The date should be displayed until I close and open again the access file. The date will be replaced only with...

thanks arnelgp, yeah its good way to start

Hi, Good day to all, I would like to know if access allows a link to specific email message in Outlook. In my database design, for every record there is related email that I need to link.

Thank you arnelgp.

hi arnelgp, it works well. im just finalizing something on my database then get back to you, thanks

Hi, By sequence: 1. After adding value to Date1 this error pop up 2. When I click OK, the pop up dis appear and I can add value to Date2. 3. When I move to typeBrand or to any field the error pop up again then when click OK it disappear. 4. Add value to typeBrand = A, the Date4 has...

Hi arnelgp, my apology for opening this post again because I need to add more code based on the sample database you provided but cant make it work. May I request your help again to add the below on the codes. Attaching back the sample database with additional field "Date4". The idea for...

Wow, .Thank you very much for your help..solved

currently this link is blocked by the connection I'm in right now, but will check the link. By putting TypeBrand under "after update" event (which I already tried before), the TotalValue will have a generated value if I will add the value by the sequest..Date1, Date2,Date3 and last is the...

Btw I'm still new in the coding environment.. thanks I moved it to textbox TypeBrand under event change but it does not help

Hi, I have created the below code (similar code to my previous post but in different purpose/event). The intention of the code is to have an automated value on the field "TotalValue" once the value is added to the field "Date3" The sequence of adding value to the field is as below: Add value...

Yes, it works this way..Thanks Resolved!

Thanks Guys.. Good day to all

Hi, Thanks for several tips. It works as below. For now the code is OK as there are only two brand which is A and B. In the future if there is additional brand let say C, then I need to adjust it again which I don't know how to code it.