Access Based Media Manager (2 Viewers)

[BlueSpruce]

I am seeking an Access based media manager that allows me to index documents, images, and audio files so I can quickly locate, view, and attach selected files to email messages.

 

[DHookom]

What do you mean by “index”? Do you simply want an inventory of file names with specific extensions?

 

[arnelgp]

maybe what you need to start is to look for FileDialog or something.
see Form1 and Module1 on this demo.

 

[isladogs]

Why do this in Access?
The best file search tool is called Everything. It indexes all files on your computer so is lightning fast. Better still it’s free.

 

[BlueSpruce]

What do you mean by “index”? Do you simply want an inventory of file names with specific extensions?

By index, I mean to categorize the file so I can filter my searches.

 

[KitaYama]

I can filter my searches.

The app that @isladogs mentioned can do that.
It comes with a pre-installed filters and you can add your own filters.
It can be as a sidebar or combo box at top.

You can also use a lot of settings for each filter to show them as you wish. Or limit your search to a set of pre-defined folders.

You can also use vba to run a search using any filter you like.

pth = YourPathToExeFile
SearchThis = "A part of your file name/extension/Or anything you know about the file"
fltr = YourFilterName
Shell pth & " -filter " & fltr & " -s" & " " & clsConst.Quote & SearchThis & clsConst.Quote, 1

 

[BlueSpruce]

Why do this in Access?
The best file search tool is called Everything. It indexes all files on your computer so is lightning fast. Better still it’s free.

I agree that Everything is a good tool. Nevertheless, I want to know if there's an Access based generic file manager available that I can add more features to, like scan documents, cascading combo boxes for categorising files, assign custom filenames, create/view folder trees, etc.

I can always build it from scratch.

 

[CJ_London]

I can always build it from scratch.

Way to go

I created an app for cataloging photos- it populated the file properties with keywords and used a tree view type form to create and catalog the keywords and view the files in a web browser control

But don’t think it meets your requirements as it is not generic enough

 

[Levi_79]

I am interested in something similar. I have a huge collection of movies, music videos, series.
I want to be able to tag files and search for tags and compile a list or a playlist (for example want to list all "rock" and "music video").
As i see Everything only searches in file names.

 

[isladogs]

@Levi_79
You could use my free app to do that

Extended File Properties

This shows a simple method of obtaining all the extended file properties for any type of file or group of files in a folder and its subfolders. There are over 320 extended properties including the dimensions of pictures and the duration of video files.

isladogs.co.uk