Re: Check If File Exists..

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Try...

If Dir(Path.txt) = "" then


"Brett Davis" <bdavis123@xxxxxxx> wrote in message
news:u6ttbuEbFHA.2900@xxxxxxxxxxxxxxxxxxxxxxx
> Hello...
>
> I am working on a process to import a text file into one of my tables. I
> want to be able to click a command button and to import the text file into
> one of my tables. I have everything I need to do... except I want to
check
> to see if the file exists in a directory\folder... if it does exist then I
> want to import it... otherwise for it to throw a message reading "file not
> found".
> I am looking for and needing the VBA code to do this.
>
> I am using MS Access 2000.
>
> Please advise...
>
> Thank you,
>
> Brett
>
>


.

Relevant Pages

  • Check If File Exists..
    ... want to be able to click a command button and to import the text file into ... I am looking for and needing the VBA code to do this. ... Brett ... Prev by Date: ...
    (microsoft.public.access.formscoding)
  • Re: Referencing a type w/o included source?
    ... code (caller and recipient)? ... Brett ... Prev by Date: ...
    (microsoft.public.dotnet.languages.csharp)
  • Combo Box - After update...
    ... record source table of the form) ... DLookup? ... Brett ... Prev by Date: ...
    (microsoft.public.access.formscoding)
  • Re: walking on bwperim()
    ... Can you try this explanation again? ... > felix. ... Brett ... Prev by Date: ...
    (comp.soft-sys.matlab)
  • Re: vba excel macro question...ranges
    ... really needing some help with this ... > zoola's Profile: ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)