list files in a directory

[alfrval]

i am new to access.
can someone tell/show me how to create a list of files in a directory outside of the access program


C:\Users\al\Desktop\MSACCESS PROGRAM is the location

[John_G]

You will need a bit of VBA code, and you will need to use the Dir function.

Check the VBA Help facility for how to use Dir.

What do you need to do with the resulting file list?

[orange]

alfrval,

I have the same question as John --What are you planning to do with the file list?

Here is a link that may give you some ideas.