Search results

  1. N

    Help to create Code for Excel Formula

    Hi Friends, I will appreciate if you guy help me code this in the MS Access if i create a table as shown in the picture below. =IF($D2="Not Required in Current FY","No Visit Required",IF(AND($A2<>TODAY(),$B2=""),"Needs Scheduled",IF(AND(ISNUMBER($B2),$C2=""),"Work Scheduled...
  2. N

    Creating form to display Detailed information

    Hi Guys & Gurus, Firstly pardon my nonsense and novice exposure to Access it's just my first step in Access actually. I am looking to create a form where if I put some information e.g 123 or ABC, it will display the complete detail of that product or thing. I did this in excel but created...
  3. N

    Solved Help required "Want to Display Local drive folder through Command button in Access"

    Hi Experts, I want to access my local drive folder and displayed on the screen with the command button in Access, previously i had the below script for Excel to achieve that, but i am not able to replicate this in Acess , need support on this. Sub sbOpeningAFolder16() Dim FSO Dim sFolder As...
Top Bottom