Recent content by KitaYama

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...

I used to use mp3tag. But at some point I stopped using it. I don't remember why, but there was something that I didn't like about it. Or was it a bug? Test multiple time on test files before working on your actual files.

If it was me, I would write a function in vba and use a loop to write a shell command for ExifTool and execute it. Or if the following fails, I would use vb to write a bat file in a folder in a loop and execute it in each loop. For example : (not tested) pth = "C:\Music\" artist = "Michael...

I absolutely agree with this,

That was my point. Here, if you forget your password, they they send a postal notification (not e-mail) to the address registered to the account. I don't know what you call it, it's a special mail that only the receiver can receive it and you have to show your ID, and sign a card and then the...

You mean they don't need a password or a phone? With several on-line information and one's mother maiden name, you can transfer money from one account to another? I wonder how loose the security of UK Banking system is. Here, not only you have to use a card and a password, or two differnt...

Yes, sorry for that.

But our discussion is not about CAD. It's about database. Your #17 post, if I'm understanding it correctly, is suggesting to convert the dimensions/mass property when saving it in a database. That's where the error occurs. Imagine you have a part that says it need 3.125lb ABS material for...

Since CAD has been mentioned, just as a caution from someone who is constantly in touch with CAD, converting dimensions is very risky, and I've never seen anybody who works in CAD, converts. I suggest sticking with the system your country mainly use (Imperial/metric), and stay away of converting...

Oh God....What a relief. For a moment I thought I've lost my mind and can't understand a simple task.

I feel I'm being dumb and don't understand. This is what my gifs showing: I have a database opened. So I have one process of Access. From current opened database, I run a code and open another database. It becomes two processes of Access. I close the database I opened, it becomes one process...

Earlier post doesn't compile. So I created a db with a public test function. Still the same result : "Test" is a public function in Database2.accdb that returns the name of current database.

@isladogs I'm really lost in this thread. Maybe I didn't understand the problem at all. From what I can understand, I think @CJ_London claimed that he opens a database, and when he closes it, the process of the opened database remains in task manager. What I see, with his own code, as the gifs...

@AHeyne Some correction. @CJ_London 's code in #28 has commented out the following line. acc.Quit acQuitSaveNone If I uncomment this line, the process is shut down. There's no need to set acc to nothing.

No, it wont. I gave up after waiting for 10 minutes. If .quit needs more than 10 minutes to close the process, then it's not of a use.