Search results

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

I see my opening post did not make clear that the default view was single form, with datasheet being allowed. Apologies to all. I find allowing users to switch between form view and datasheet view (caveat: when appropriate!) enables easy record navigation and filtering if needed, using the...

Thanks Colin, as you advised, moving my subform from the parent's detail section to its footer section, solved it, so that is the answer I needed to "how to remove a datasheet's subform view".

Re: How to remove a datasheet's subform view? Screenshot attached:

Sorry Micron. Perhaps I should have said your suggestion made no difference i.e. the "plus" and subforms still appear.

Micron, thanks for the suggestion. Parent form's recordsource is two linked tables joined. I made the change you suggest to both tables in both FE and BE. The subforms still appear unfortunately. Colin I quite understand and agree with your reservations about subdatasheets. This is slightly...