Results 1 to 2 of 2

Thread: Testing for existence of a file in Access 2000 **RESOLVED**

  1. Sep 15th, 2003, 06:29 AM #1
    M Owen
    M Owen is offline

    Thread Starter
    Lively Member
    Join Date
    Jun 2003
    Posts
    114

    Testing for existence of a file in Access 2000 **RESOLVED**

    Hi all.

    This one should be rather simple but I'll be hanged if I can think of it right now ... I need to test if a filename a user imputs exists in a specific directory or not ... That's it. Any ideas on ways to accomplish this? Thanks!

    - Mike
    Last edited by M Owen; Sep 15th, 2003 at 06:45 AM.
    Reply With Quote Reply With Quote
  2. Sep 15th, 2003, 06:45 AM #2
    M Owen
    M Owen is offline

    Thread Starter
    Lively Member
    Join Date
    Jun 2003
    Posts
    114
    Solved this puppy ... A little patience, caffiene, and a quick search found me an answer ...

    PHP Code:
        Dim Result As String
        
        Result     = Dir(PicturePath & "\" & FileTxt.Value, vbNormal)
        If Result = "" Then
            MsgBox "    File: " & FileTxt.Value & " does not exist!", vbCritical, "System Monitor"
            Cancel = 1
        End If 
    I do hate answering my own questions ...

    - Mike
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width