Albert D. Kallal's latest activity
-
AAlbert D. Kallal replied to the thread How to always set focus on the control on parent form after entering data in the subform.Yes, you are correct!!! (happy to be corrected on this issue == thanks for the follow up). So, ignore my "narrative" on needing some...
-
AHello Everyone, I just signed up, looking for the latest trends and latest hints, tips, tricks with MS Access. I have used MS Access...
-
AAlbert D. Kallal replied to the thread How to always set focus on the control on parent form after entering data in the subform.As a general rule, no, if there are no other controls on that form, then hitting tab will not fire the after update event. However, in...
-
AAlbert D. Kallal reacted to BlueSpruce's post in the thread How to always set focus on the control on parent form after entering data in the subform with
Like.
Excellent advice, Albert. It makes a lot of sense. I did previously mention about the barcode reader appending an enter or tab key, but... -
AAlbert D. Kallal replied to the thread How to always set focus on the control on parent form after entering data in the subform.Excellent! And the UI will be smooth as butter for this operation...... And like everyone else here? Just adding my 2 cents worth...
-
AAlbert D. Kallal replied to the thread How to always set focus on the control on parent form after entering data in the subform.A few things - but just a quick look here at what we have so far? First, don't use on-current - avoid if possible. Next up, a...
-
AAlbert D. Kallal replied to the thread Remote desktop vs. browser based web apps..Agree. but then again, my Access applicaitons when run from RDP launch the local copy of outlook (and with attached PDF's etc.). And we...
-
AAlbert D. Kallal replied to the thread Optimizing a query with multiple LIKE '%abc%'.We just turned it on about 2 months ago. We have a screen in which comments for a project (one of multiple components for the project)...
-
-
AAlbert D. Kallal replied to the thread Optimizing a query with multiple LIKE '%abc%'.As noted, just turn on full text indexing. Full text indexing will pluck out each word, and thus any word any place in the text will...
-
AAlbert D. Kallal reacted to sonic8's post in the thread VBA class modules & factory design with Like.
You might be pleased to hear that in current VB.Net you can create a real property by just adding the "Property" keyword to a Public...
-
AAlbert D. Kallal replied to the thread VBA class modules & factory design.Nice tip to share! - And I often use the above. And as such ? Well, VERY hard to make the "lazy" case that no getter/setter is required...
-
AAlbert D. Kallal replied to the thread VBA class modules & factory design.As noted, not a huge deal anyway. But, as per above, I would have just made m_Error public - and then you don't need the Get/Let. It's a...
-
AAlbert D. Kallal replied to the thread VBA class modules & factory design.But any var declared as public in that class? You get intel-sense anyway - hard to make a case for then writing out a getter/setter...
-
AAlbert D. Kallal replied to the thread How to register library/reference from vba code?.I not tested nor attempted to sink events into such .dll's. But, few require this ability. So, for last 10+ years of building...
-
AAlbert D. Kallal replied to the thread How to register library/reference from vba code?.Well, if you add a reference to the runtime host, then that's another reference that can break. So, with my .net loader, then zero...
