A family of Microsoft relational database management systems designed for ease of use.
Sorry, try this version. I uploaded the wrong one earlier.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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!
A family of Microsoft relational database management systems designed for ease of use.
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.
Sorry, try this version. I uploaded the wrong one earlier.
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
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:
did you test using a local folder?
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?