Adding records to a database table from user input in a form

[Taha60]

Hello....

I am creating a form in access where the user will , by means of a "open" dialogue box, pick a folder and vb code will be used to read in file properties of the different files in the folder/subfolders.... I had 2 questions...

Firstly I wanted to be able to create a Hyperlink to those files since I do have a "hyperlink" field in my table. (these files may not necessarily be MS office files) How would I read in the path for the file and then using that how would I create a hyperlink.?

Secondly I wanted to add this hyperlink and more information that I will be collecting to an Access table... I am not sure how to do this... My first Hunch was to use a insert SQL statement such as....

dim dbs as database
set dbs = CurrentDb()
dbs.execute(INSERT INTO tbl_MyTable('hyperlink', filesize...etc..)

Any suggestions will greately be appreicated

Thanks

Taha