Recent content by coypu

Tom, that seems to have done the trick. Thanks!

For some reason, the compile issue is back. No idea why, as nothing changed and the Trusted Location seems fine. Tried attaching the accdt as a zip. Get's to 100% then says too large. Its 12MB. Downloaded NW2 Starter and it runs fine i.e. no compile error, unlike Dev. Both exist in same Trusted...

The compile problem is no longer happening in the original download, so perhaps the Trusted Location setting took a while even tho' I closed the DB before. Sorry the cause and solution is not 100% clear.

Thanks George. I chose NW2 Dev again in a VM running Access 365 and this time it worked fine, so when I get the chance, I'll try to find why there are compile issues in the earlier download. I'm not seeing any *.accdt files to send you, sorry.

I've only got the accdb it created today from MS's NW2 Dev. Do you want that, 13MB?

Access 365 and 2019. NW2 Dev. Tried each of the suggestions above. Not fixed. Thanks all.

Getting the same issues as OP with 2.4 i.e. Compile error for "OneTimeProcessing". Add Trusted Location didn't solve it.

Thanks for all you're doing on this 👏👏 With you on the light theme 👍

Congrats Colin (y)

The priority is to resume the stability and credibility that we and Access have enjoyed and deserved for many years. The distribution that achieves that will be followed, and I have no issue with distributions that divert.

Perhaps we could persuade MS to make Access open source, letting the community look after and develop it?

Cheers Colin, well said. Perhaps MS need reminding of those fab infographics you shared here.

Seen this from Mike? https://nolongerset.com/access-roadmap-refresh/ I do think we should be pushing back here, else the future for Access looks bleak and empty. https://techcommunity.microsoft.com/t5/access-blog/changes-to-our-public-roadmap-and-how-we-communicate-access/bc-p/3468935#M241

Building on MajP’s very helpful post, https://www.access-programmers.co.uk/forums/threads/creating-pseudo-custom-controls-with-class-modules.321016/ here’s a simple class that strips CrLf’s from a single row textbox. Why would you want to do that? Well, when you copy & paste, say from a webpage...

MajP, thanks so much for this. Excellent example of OOP and “with events” as well as enhancing the functionality of combos and form filtering. I’m discarding loads of now redundant and hard to maintain code that handled comboboxes row source dynamically. I eagerly look out for your class module...