riktek's latest activity

  • riktek
    riktek reacted to Josef P.'s post in the thread "Namespace" reserved in VBA? with Like Like.
    Why should I use ByRef if I don't want to change the reference? ;)
  • riktek
    riktek replied to the thread "Namespace" reserved in VBA?.
    Not that you should, of course, but the reason I generally would is efficiency, unless I had a specific reason to use ByVal. For...
  • riktek
    riktek replied to the thread Combo Box Search Issue.
    You just pointed out something else that might be at work. Ambiguity is one thing, and to be avoided, and consistency is another, to be...
  • riktek
    riktek reacted to bonzitre's post in the thread Combo Box Search Issue with Like Like.
    Yeah, I considered this. What is weird is I did change my table to TSex so it is Tsex.id tsex.sex and the field on the main table is...
  • riktek
    riktek replied to the thread "Namespace" reserved in VBA?.
    You're right. I just tried a WithEvents declaration and the VBE did not approve. Thanks for pointing that out. Even were it...
  • riktek
    riktek reacted to Josef P.'s post in the thread "Namespace" reserved in VBA? with Like Like.
    Standard modules cannot handle events. Here I would rather use a procedure to call it, so that you can pass initialization values and...
  • riktek
    riktek replied to the thread Combo Box Search Issue.
    This may or may not be what's at work but you do have a case of ambiguous naming that could lie at the root of your problem. The "Sex"...
  • riktek
    riktek replied to the thread DLookup Function Alternative.
    DLookup() is nifty as far as it goes but can be optimized in many ways. I developed a DLookup() clone (see below) to do just this, and...
  • riktek
    riktek reacted to Josef P.'s post in the thread "Namespace" reserved in VBA? with Like Like.
    [OT] Note: There is a simple way (video) to set VB_PredeclaredId = True without using an additional function or editing the exported...
  • riktek
    riktek replied to the thread "Namespace" reserved in VBA?.
    Re events, I haven't tried it yet but I expect one can sink events in a standard module via a module-level object variable declared...
  • riktek
    riktek reacted to MajP's post in the thread "Namespace" reserved in VBA? with Like Like.
    Interesting. I did not know, nor did it even occur to me that you could use properties in a standard module. In all my time in VBA, I...
  • riktek
    riktek replied to the thread "Namespace" reserved in VBA?.
    @MajP , you're quite helpful, and thoughtful, to raise these points. It turns out I'm deeply familiar with predeclaration, not to...
  • riktek
    riktek reacted to MajP's post in the thread "Namespace" reserved in VBA? with Like Like.
    @riktek, You may want to look at the link discussed in this thread...
  • riktek
    riktek replied to the thread "Namespace" reserved in VBA?.
    It's good to know that the compilation process provides a firewall of sorts in this regard. That probably rules out most of the risk...
  • riktek
    riktek reacted to The_Doc_Man's post in the thread "Namespace" reserved in VBA? with Like Like.
    By the time MSACCESS.EXE is running, any internal symbol-table variables are isolated by the very nature of creating an executable...
Back
Top Bottom