Recent content by akbrennan

Good point Pat. Currently my database design doesn't allow users to navigate from one record to another within the form in question, they have to close the form and reopen from another form, so I haven't encountered a problem. But as a general principle that's helpful to know. Thank you.

Shall we take it as a win-win? I've got a workable solution for the problem, and you've had a bit of a head scratcher to challenge your knowledge? :D Thanks again for engaging, it was really helpful.

Thank you Arnel. And thanks again Gasman for the ongoing input. That two listbox solution works nicely. I had posted the problem elsewhere also, and someone pointed out that the code I was trying to use to pull the filename from the full path was unnecessarily clunky and suggested a neat...

I've found the part of the Module that actually populates the list... Dim colDirList As New Collection Dim varItem As Variant Call FillDir(colDirList, strPath, strFileSpec, bIncludeSubfolders) 'Add the files to a list box if one was passed in. Otherwise list to the...

Gasman, thanks again. Yes, that would be the sort of solution I'd be looking for. Can you think of a way I could achieve that? The Module I used to generate the list isn't my own work, it's from Allen Browne. I'll edit the earlier post to add the link. Presumably the neatest way to get a 2...

Hi Gasman, thanks for the reply. You're correct, I don't need to do it but from an aesthetic and practical point of view having the listbox only display filenames is neater and easier to read and allows me to have a narrower listbox with a neater form. The full file paths are long and present a...

I have an unbound ListBox with 1 column that is populated OnLoad with a list of files in a folder. The user can click on any of the lines in the list box which opens the related file. This works as the entire filepath is what is stored in the ListBox and passed to Windows Shell. I would like the...