Perhaps you guys can point me in the right direction

[DrMike]

So I need to find a way to verify paths that exist in a column of one of my db table for example Table: S_T Column:S_MPEG_Name

In this column exists information that points to certain files for Ex:

C:\Video\08_22_2008.mpg

I am hoping for some advice on the best way to verify that the file exists in this location some sort of verification tool.

What would be the best programming language to create an application that would allow me to do this?

Or do you know of a utility that exists that is capable of this?

Thanks in advance

 

[pbaldy]

Look at the Dir function in VBA help.

 

[DrMike]

I looked at the dir function but it appears its for excel not access... Am I doing something wrong here? care to share more?

 

[Darth Vodka]

how about

Public Function FileExists(strFile As String) As Boolean

    If Dir(strFile) <> "" Then
        FileExists = True
    Else
        FileExists = False
    End If


end Function

 

[DrMike]

Yes but I am new to this whole vb programming so i would assign this function to a column label ? or to the table as well as the column label ?

 

[georgedwilkinson]

Put DV's code in a module and put:

=FileExists(Me.FieldName)

in an unbound control.

 

[boblarson]

Put DV's code in a module and put:

=FileExists(Me.FieldName)

in an unbound control.

And make sure to name the module something OTHER than FileExists.

 

[Darth Vodka]

And make sure to name the module something OTHER than FileExists.

that one's bitten me on the arse a few times

 

[DrMike]

Thanks for all the input guys