riktek's latest activity

  • riktek
    riktek replied to the thread Solved Controlling ScrollBars on a subform.
    Late to this but I had fiddled with a similar problem fairly recently and learned a few possibly relevant things (but probably not all...
  • riktek
    riktek reacted to Isaac's post in the thread "Namespace" reserved in VBA? with Like Like.
    I guess you make a good point. For readability, the closeness to being reserved could be its strength, depending on the context and who...
  • riktek
    riktek replied to the thread "Namespace" reserved in VBA?.
    Close is one thing. Looking for trouble is a whole other kettle of fish. 😁
  • riktek
    riktek reacted to Isaac's post in the thread "Namespace" reserved in VBA? with Like Like.
    Even if it isn't technically reserved, why come so close? Readability/avoid confusion
  • riktek
    riktek replied to the thread "Namespace" reserved in VBA?.
    You answer your own question, actually: Readability. It's a well-understood term and the concept is directly relevant to the project...
  • riktek
    riktek reacted to Josef P.'s post in the thread "Namespace" reserved in VBA? with Like Like.
    A copy of the pointer => This is for me irrelevant in terms of time. However, I use the interface to show that the object reference will...
  • riktek
    riktek replied to the thread "Namespace" reserved in VBA?.
    Just the thing to avoid. Of course, I've never encountered any such thing in my code. ;-) Very interesting examples. That's the...
  • riktek
    riktek replied to the thread "Namespace" reserved in VBA?.
    There's that, of course, but it also matters in object frameworks, garbage collection, filtering routines, and rendering GUI elements...
  • riktek
    riktek reacted to Pat Hartman's post in the thread "Namespace" reserved in VBA? with Like Like.
    I keep things like the menu list in the FE. That means that when I add a new item to a menu or rearrange the order, the changes go...
  • riktek
    riktek replied to the thread "Namespace" reserved in VBA?.
    Well, that's exactly the tradeoff. That insurance carries a premium and the relative values can only be evaluated subjectively. Going...
  • riktek
    riktek reacted to Pat Hartman's post in the thread "Namespace" reserved in VBA? with Like Like.
    Most people would consider ByVal to be safer since it exposes a copy of a variable rather than giving the calling object the address of...
  • riktek
    riktek reacted to LarryE's post in the thread Combo Box Search Issue with Like Like.
    In addition to what others have said, if you have 126 tables, something is very very wrong with your initial design. I suggest you take...
  • riktek
    riktek reacted to Pat Hartman's post in the thread Combo Box Search Issue with Like Like.
    I'm guessing you have made a lot of extra work for yourself by not properly normalizing the tables. This design pattern is similar to...
  • riktek
    riktek replied to the thread "Namespace" reserved in VBA?.
    That's a good point. I'm conflating user-specific settings and application-specific settings. I'd put both in the BE for just the...
  • riktek
    riktek reacted to Pat Hartman's post in the thread "Namespace" reserved in VBA? with Like Like.
    No. That makes it difficult to replace the FE because you have to somehow save the user settings. Best to use a BE table with a UserID...
Show older items
Back
Top Bottom