Search results

I understand why you don’t want to spend a lot of time on this or waste our time (thanks!) but, if there is a bug, providing a simple repro db will significantly assist with tracking it down. If I can reproduce this as a bug, I will forward it to the Access team

See if my free Extended File Properties app does what you want. It will list all the extended file properties for any individual file or all files of a certain type in a folder https://isladogs.co.uk/extended-file-properties/index.html

I’ve already responded to Chris via a separate email exchange but for others reading this I can confirm that using the latest simple code in 365 under Win 10, the background instance is always destroyed but the time that happens depends on whether acc.Quit is used or the older acc.DoCmd.Quit As...

Its surprising how rarely it causes issues. Did you read the explanation of what is happening behind the scenes?

This sounds like it may be a variation of the combobox zombies puzzle described on my website That is an artefact of the Inherit Value List property which by default is set to Yes. Its much easier for you to try it out than it is to explain what is going on...

Set the scroll bar property to None OR increase the height of each record

The next Access Europe User Group meeting will be on Wednesday 3 Sept 2025 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). For local times, please check World Time Buddy Version control isn’t just for teams — it’s the secret weapon for sole Access developers to save time...

I agree with the earlier comment that it is highly unlikely you could further optimize your query design I spent a lot of time researching query execution plans several years ago including the conditions in which Rushmore is utilized. There are a few minimum conditions. If my memory is correct...

I know you don't want to spend any longer on this than necessary, but if you are still having problems, consider using one of the alternative methods in this article: https://isladogs.co.uk/control-help/

Correct. It was in post #1 but only if the middle section was uncommented. If so API declarations were needed

See also my article which has a wide variety of age functions depending on your requirements: https://www.isladogs.co.uk/age-calculation/index.html

Just in case its relevant, I'm still on Win 10

Don’t forget your own code also works for me as long as I follow it with CloseOpenDB “”. As I haven’t heard other reports of leftover instances in CC 2507 / 2508, at the moment I suspect it’s an artefact on your machine. Do you still have 2010 installed as well and if so, which is the...

I have my own article about 4 different ways of forcibly closing Access where necessary: taskkill Powershell Stop-Process EndTask API GetProcessID API https://www.isladogs.co.uk/forced-shutdown/index.html Whilst all of these methods work, they should only be used where absolutely necessary...

OK I've done some more testing with both the original code from post #1 and a modified version of my generic code in post #5 I still cannot replicate the additional Access instance remaining in Task Manager after running your code straight through or stepping through it. I re-tested altering...

Double check that youhaven't also defined gbDebug in another module (as Private or Public) Duplicate declarations can cause problems.

Also have a look at my article: https://www.isladogs.co.uk/multivalued-fields/index.html For info, multiselect listboxes are not the same thing as multivalued fields

@GPGeorge Not sure which reference you copied. However, just to be clear, that incorrect comment about the Win64 compiler directive didn't come from my article that you linked in post #6. Thanks for adding the link however!

Better still, if all your users are on A2010 or later, remove the conditional compilation completely and just use: Public Declare PtrSafe Function apiGetWindowsDirectory Lib "kernel32" Alias "GetWindowsDirectoryA" _ (ByVal lpBuffer As String, ByVal nSize As Long) As Long Coming back to...

I can't see the issue you describe using your code (with the specified section commented out) No additional instances remain in Task Manager and Access doesn't hang for me. EDIT I tested in 365 version 2509 build 19220.20000 Beta 64-bit. It may be relevant as to which version build / bitness /...