Select File name, but not the file

[DrDan1]

Hi. I was hoping that there is a way of selecting a nuber of files and having the file names added to a field in a table. e.g. selecting a folder of 30 video files and they're updated to the access table as 30 new records, without having to type out out the filename of each file.

I've played around loads but can't figure it out. Thanks.
-Dan.

----------------------------------------
Knowing is not enough, we must apply. Willing is not enough, we must do.
--So said the ever wise Bruce Lee
Memorize and live by it!

 

[Savil]

Is this wot u want?

dim filename as string
dim rs as recordset

set rs = currentdb.openrecordset("table_name&quot

filename = dir(path_to_Folder)
do while filename <> &quot;&quot;
rs.addnew
rs!fieldname = filename
rs.update
filename = dir
loop

 

[DrDan1]

Thanks, I think so. Haven't been able to try it yet. Will be able to tonight, but will this allow the user to select a number of files, click an ok button and everything will be updated?

----------------------------------------
Knowing is not enough, we must apply. Willing is not enough, we must do.
--So said the ever wise Bruce Lee
Memorize and live by it!