is this possible, read contents of directory file and populate a t

[richard harris]

Just seeing if this is at all possible

say i have a table called cust_docs with fields doc_id, doc_name, doc_path.

can i put some code to a button to read the contents of a folder (eg
c:\company\cust_files\ plus a variable to identify the customer) and return
the names of the docs and the paths in to my table.

then a user would be able to double click a record in this table and open
the relevant document.

if this is possible, any pointers to some code or ideas. im pretty basic
with VBA in anything above an if, then else statement.

thanks

richard

 

[J_Goddard via AccessMonster.com]

Hi -

Check out the Dir() function; using it in a loop can do just what you are
looking for. There are examples in the Help (at least up to 2003)

John