Listing names of files in folder on form

Anonymous
2020-06-11T01:02:31+00:00

I am having troubles trying to list on a form all files in a folder based on criteria.

I have tried both Allen Browne's solution and Daniel Pineault's solution, and they both seem* to work for ALL files in the folder.

What I need is the list to only show file names that start with a SKU # displayed in a text field ( [txtStockCode] ) on the form the listbox is on.

So something like - \folder\Archive BOM Copies\ & Me.[txtStockCode] & " *.htm "

For starters, would there be a better way to do this other than a listbox, like a sub-form?

If not, any ideas how I can filter the listbox based on what is in [txtStockCode] ?

Ultimately I want a clickable link to be able to open these files.

*I say seem to work as the file names that are displayed only show the name until there is a comma or parentheses in the file name. The files are saved to the folder as a concatenation of SKU+Description+Date(), and description commonly has comma's and occasionally parentheses. 

Also, it doesn't show all files in the list, there are ~2500 files in the folder and growing daily and it only scrolls down a few hundred. Maybe a non-issue as I only want it to be able to show the ones that match the text field.

Any help is appreciated, thanks!

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

68 additional answers

Sort by: Most helpful
  1. Anonymous
    2020-06-18T01:49:31+00:00

    did you test using a local folder?

    Yes, used the little button on the form, navigated to the folder.

    By local, it is not on my machine, it is a network location?

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2020-06-18T01:41:43+00:00

    did you test using a local folder?

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2020-06-18T01:15:42+00:00

    This is a link to the version I have and can assist you with modifications of this version which you can then adapt to suit yourself.

    https://1drv.ms/u/s!AvDZzWjSDmROqG2Jq8r-ZPu765xv?e=SRsY1F

    Download it, test it and we'll go from there

    Downloaded and saved to my desktop, opened and enabled content.

    In Search for What I enter 98500178.

    I click cmd_FindFolder button, and navigate to my drive folder and select.

    This is in Search Where - \FOLDERS\Eng_Dept\All_Staff\Engineering\Database Requirements\ExportReports\Archive BOM Copies

    I click "SEARCH button and get this:

    Then this:

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2020-06-18T00:37:08+00:00

    This is a link to the version I have and can assist you with modifications of this version which you can then adapt to suit yourself.

    I screwed up... wrong file. will upload correct one shortly

    Download it, test it and we'll go from there

    Was this answer helpful?

    0 comments No comments