Recent content by coypu

  1. C

    Northwind 2.0

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

    Welcome new Access MVP Colin Riddington (isladogs)

    Congrats Colin (y)
  3. C

    Access - Devastation

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

    Access - Devastation

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

    Access Roadmap shortening!

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

    Access Roadmap shortening!

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

    Use of Pseudo Custom Controls with Class Modules

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

    Solved FAYT for Multi Column combo code from MajP question

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

    How to remove a datasheet's subform view

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

    How to remove a datasheet's subform view

    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".
  11. C

    How to remove a datasheet's subform view

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

    How to remove a datasheet's subform view

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

    How to remove a datasheet's subform view

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

    How to remove a datasheet's subform view

    Hi I have some forms where I allow datasheet view. Those forms also have a tab control containing subforms. When in datasheet view, there is a "plus" just to the right of the record selectors. If that is clicked, the first subform displays between the current datasheet record and the next...
  15. C

    Intercept toolbar/ribbon button's click

    Thanks Steve Not sure that will get me there, but an interestimg technique any how.
Top Bottom