Question

Asked on 2007-09-19 at 05:44:05ID: 26997591

    Check Folder if there's a file and display path and filename

    by: fmew125

    Rating6.8Good

    Hi there,

    In a On Open Event I need some code to check if there are files in a certain folder (always the samefolder)
    If False, Do Nothing
    If True, the FilePath and FileNames should be displayed in a MsgBox.

    Erik

    Related Solutions

    1. FilePath
    2. Using a Filename in a Table
    3. Get path and save it into a v…
    4. Display picture from filename

    Solution

    Sign up now to view this solution! It's quick, easy, and secure to subscribe. We will return you to this solution, unlocked, when you’re done.

    About this Solution

    View This Solution - Start Your 30 Day Free Trial
    Zone
    general
    Tags
    Microsoft Access 2000 VBA
    Participating Experts
    2
    Solution Grade
    B

    Replies

     by: Angelp1ay

    Posted on 2007-09-19 at 06:09:47ID: 35552264

    All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

     by: stevbe

    Posted on 2007-09-19 at 06:11:31ID: 35552265

    All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

     by: Angelp1ay

    Posted on 2007-09-19 at 06:23:02ID: 35552266

    All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

     by: Angelp1ay

    Posted on 2007-09-19 at 06:40:33ID: 35552267

    All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

     by: Angelp1ay

    Posted on 2007-09-19 at 06:41:54ID: 35552268

    All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

     by: fmew

    Posted on 2007-09-19 at 07:20:10ID: 35552269

    All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

    Log In

    Forgot your password?Sign up

    Top Experts

    1. jimpen

      3,600

      0 points yesterday

      Profile

    2. boag2000

      2,000

      0 points yesterday

      Profile

    3. als

      1,360

      0 points yesterday

      Profile

    BrowseAre you an Expert?