Hi marcin2K,

Yes, the code as I originally posted it worked. It created several hyperlink filds in the target table. Why not got back and cut and paste the original code, changing only the directory values if you like. Let me know how you make out.

Bob

Hi Bob,

I have just used you code exactlly and only changed the paths and it all works :). Thanks a lot for your help. There is one thing I had to change that was the lines
           With rst
                .AddNew
                !FileHyperlink = strFileHyperLink
                .Update
                 blnRecordAdded = True
            End With

have to go in the if statement where it checks if its a pdf file, so that it doesn't repeat the same file when it saves it to a record. Everything else works perfect and it lets me open the hyperlink in the table afterwards so it must be a security issue for you.

THanks once again,

Marcin

There is a typo in my previous post, I meant I put those lines of code in the if statement where is checks if the date is within a certain range. Before you had it after this if statement and it needs to be inside it.

Hello,

One last question, is there a way of refreshing the data in a table because with this if i want to make it open a different form after adding the data to the table and display all of its records it won't display anything. I have to open the first and then when I open the form it displays it. Its odd must be some access bug.

Ok solved my problem, it seemed that it only happen when I had like 3 files in my folder. When I used like a 100 it worked with no problem. I also added a query to delete the old data maybe that solved it.

Glad you got it all going :).

Bob