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

68 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-06-19T15:59:58+00:00

    Whichever way sits you best.

    I take it this question is resolved?

    Yes!

    Your sample db is what ultimately led me to my solution, so should I mark that that reply as the answer?

    Was this answer helpful?

    0 comments
  2. Anonymous
    2020-06-19T00:14:49+00:00

    Whichever way sits you best.

    I take it this question is resolved?

    Was this answer helpful?

    0 comments
  3. Anonymous
    2020-06-19T00:07:30+00:00

    Next up I guess you are looking to put the results into a report? You should be able to just sent the results to a table.

    No?

    Maybe?

    If I can make the list box expandable to show all files in the list, with links to open them I am covered!

    Was this answer helpful?

    0 comments
  4. Anonymous
    2020-06-18T23:43:47+00:00

    I'm glad it helped get an answer. I can't take credit for the demo though, Daniel wrote the code for that.

    sFile and sSearchTerm indicate by the 's' they are string variables. some would do it as strFile or StrSearchTerm and possibly other ways but whichever way, it's a good habit to get into (although I forget a lot of the time).

    Next up I guess you are looking to put the results into a report? You should be able to just sent the results to a table.

    Was this answer helpful?

    0 comments