Search results

  1. V

    Solved Quotient with N/A value

    Hi AW Team, Good day. I would like to ask your assistance again regarding the code. In the FORM under DATA , CONTROL SOURCE, I use the below code to get the quotient value of T1 and T2 =[T1]/[T2] It works fine as per the code if both T1 and T2 has number value. However, If the value is "N/A"...
  2. V

    Solved Display "N/A" on Sum code

    Hi AW Team, Good day. I would like to ask your assistance again regarding the code. In the FORM under DATA , CONTROL SOURCE, I use the below code to sum the number of "Closed" value in "Status" =Sum(IIf([Status]="Closed",1,0)) It works fine as per the code. However, I want to improve the code...
  3. V

    Solved Count and Display N/A

    Hi Team, Can you please help me. I'm using the code : =Count([ProductA]) To count all ProductA. However, when there is no ProductA in the list it display zero (0). Can someone help me to improve my code to display N/A instead of zero when no ProductA available
  4. V

    Search codes

    Hi AW Team, I would like to ask your help on how i can create a button that can search for the word like how google search works. I created a form call "form1" and I link to the "table1". Then make it a split form. On the Split form I added "unbound" and button and "Clear". What I want to...
  5. V

    Solved Link to specific ID in other form

    Good day to all, I need assistance, being new to this environment hope someone will help. attached is sample DB for reference you can edit it direct here. Here it goes: I created "Base" & "Info" table and create their relationship. Then created Form link to Base" & Info table. The "Base...
  6. V

    Code to launch the current date

    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...
  7. V

    Access link to Specific message in Outlook

    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.
  8. V

    VBA code 2

    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...
  9. V

    VBA code

    Hi Please help me to correct the vba code below: I have 4 field: Date1,Date2,Date3,Type and a 1 text box called "Total" and below is the vba code which is not working as per the target output: The target to the vba code is that: - when the value of field "type" is A, the text box "Total"...
  10. V

    Coding query

    Hello, Can someone please help me to correct the codes below as always ended up error: Private Sub Date_AfterUpdate() If Me.Date = "IS NULL" Then Me.Completed = "No" Else If Me.Date = "IS NOT NULL" Then Me.Completed = "Yes" End Sub The intention of the code is to have an automation value...
  11. V

    My first post

    Thank you for accepting my registration. Happy to be part of the forum.
Top Bottom