Search results

  1. V

    Solved Quotient with N/A value

    Thank you very much
  2. 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"...
  3. V

    Solved Display "N/A" on Sum code

    Thank you very much. Solved
  4. 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...
  5. V

    Solved Count and Display N/A

    Thank you all for your valuable suggestions.
  6. V

    Solved Count and Display N/A

    This one doesnt work: =iif(Count([ProductA])=0, "N/A", Count([ProductA])) This works: =IIf(Count([ProductA])=0, "N/A", Count([ProductA])) Also, I'm not an expert to this access field. The DB is created by an expert guy and there is no more support. I'm just adding more function and thanks to...
  7. V

    Solved Count and Display N/A

    Thank you. I tried the code but it pop up with missing symbol, however when I change the "iif" to "IIf" it works. =IIf(Count([ProductA])=0, "N/A", Count([ProductA]))
  8. V

    Solved Count and Display N/A

    Hi plog, You are right, I did the code in report. I tried the suggested code but it display the word "%NAMES" not the target "N/A"
  9. V

    Solved Count and Display N/A

    The system doesnt allow me to attached the screenshot
  10. V

    Solved Count and Display N/A

    Thanks for the response. I put the code in Control Source, Under Data.
  11. 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
  12. 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...
  13. V

    Solved Link to specific ID in other form

    Thank you very much. solved
  14. V

    Solved Link to specific ID in other form

    hi, im sorry to open this topic again. The attached DB is working really fine. As shown, up to letter D (Figure1), it display the specific ID. But when it reached the letter E (Figure 2), all the values that I put from letter E to H does not display.. It always display as blank page. Could...
  15. V

    Solved Link to specific ID in other form

    Thank you arnelgp, got it
  16. V

    Solved Link to specific ID in other form

    Hi it works as per the attachment. May I know where did you get the value "txtBaseID" that you put in the event? "BaseID= " & Me.txtBaseID I asked this because I transfer the coding to our database and it shows error and highlighting the "txtBaseID"
  17. 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...
  18. V

    Code to launch the current date

    or if you have other idea, pls let me know
  19. V

    Code to launch the current date

    hi arnelgp, You are absolutely correct, thank you for your observation. Yeah no need BTN, the User should manually select the date/time of the last email he has checked. The flow will be as below: >> A person has just checked 500 emails, then he will select the date/time of the last email he...
  20. V

    Code to launch the current date

    hi Gasman, If you are receiving hundred of email per day from an auto email distribution and you need to check it one by one and do the action as needed then yes it is possible to change the date/time per day especially if there is shifting in the schedule, and it is actually happening.
Top Bottom