Search results

How would he decouple - create a duplicate temporary record? I agree @bodders24, there are not a lot of good tutorials on VBA Class Factory like functions. I'm not sure what you're gaining in decoupling the BE/ FE? Only to add several layers to the process; diminishing performance, maybe you...

Thanks xavier.battle, apoligies Doug Steele. If Doug is a member would greatly appreciate if someone could tag him so he gets credit deserved.

Thanks @isladogs, I had no idea & I'm glad I mentioned PopUp (which I thought would be irrelevant). Some valuable lessons learned here; thanks guys. I should credit & boost page rank for the awesome tutorial I am following - Doug Steele's awesome Drag & Drop tutorial here; which I think is...

Thanks Dave, that's exactly what's happening & pretty much what I'm up to. But the unreliability of Screen.ActiveControl also seems to apply to Me.ActiveControl. PreviousControl also produces an inaccurate result; specifying a button which i have not pressed in years. Interestingly...

Interestingly specifying an objVar as Listbox type does not assign the listbox objectively (without an explicit string reference) either: Set thisList = Me.ActiveControl

I have a PopUp Form containing two listboxes (the control I refer to is the child listbox). Parent listbox has no multi-select property; child listbox (in question) mutli-select (simple) & an optionGroup (irrelevant) with other irrelevant buttons... MouseDown event assigned to a txtBox in the...

Thanks that's interesting; I was enjoying your Security challenges the other day, have not managed to complete one yet. Terrified I've spent a year learning an obsolete tool :cry: so that's a comforting read.

Nr 31: Nr 33: Nr 35: Nr44: ________________________________________________________________________________________________________________________________________________________ I don't think I've said that at all, I've said the external usefulness of the application, but you...

I agree, I cannot see how one can say Access is not loosing it's effectiveness; used to allow functionality of scores of apps, now it can no longer control any other apps, just Access itself - oh it's still as good though :unsure:. Sounds argumentative & I do not mean it to, but reading the...

Thanks, but the beauty of Access is also it's ability to control other apps also; is it not? Let alone the Microsoft suite. I'm not trying to be argumentative at all; merely debating. My knowledge is pale in comparison to you guys. I'm just trying to understand is all. ;) From a learner's...

You know more than me Sonic8, & I'm pleased to hear your optimistic outlook, Access is a brilliant app, I pray it continues to be so. It just seems like they are reducing it's power to use other applications is my amateur perception.

Some say that MS Access is still in development & going strong - then I read articles like this & it is clear to me that the effectiveness of the application is being greatly diminished.

@hamaray you're a surveyor aren't you; running cost to completes/ variation orders... I am an Estimator, gone down the path you are about to go down; 1 year further on. Working on my project full-time after quitting my job; averaging around 11 hours a day on the project every single day near...

I think the tutorial goes bad at the end; it relies on the caller in the external module (TestAbstractFactory) implementing a 'MyMacro' class. I was trying to get around this by just using what I needed in the TestAbstractFactory procedure. The author gives no details of what's inside here. As...

Thanks Ron, sorry I posted at just after your helpful post. Yes that works, thank you. I had predeclared the classes. As you kindly pointed out missed the below in the external sub as I was confused with what was going on: Set obj = cSomething I started to understand what was going on before I...

cSomething was missing the below; as the Implementation Class' blueprint (members of the Implementation Class) must be followed wherever it is implemented. The compiler needs to see code-stubs for them members. Private Property Get cISomethingFactory_Bar() As Long cISomethingFactory_Bar =...

Thanks Ron & for explaining the benefit of the Type in the tutorial. Oh I see (thank you); I missed the 'c' in ISomething_Bar in cSomething should be cISomething_Bar & ditto for Ducky. Regardless after fixing that the compiler is still throwing the same error "Object Module needs to implement...

Trying to learn Implementation Classes & Class Factories - Parameterized Object Initialisation from this great tutorial,but I get the pic'd error & I can't see where I'm going wrong? I've Predeclared the classes as per tutorial. I'm just before he turns it into an Abstract Factory. I also tried...

Thanks Pat, I honestly do not at all care about my bubble or ego, so I am grateful for input received. Far easier to pretend I'm right or ignore a post so thanks for explaining (& to everyone). Correct I switched priorities (bad-form) apologies. My recordsets are quite large so this is...

Ah I see, thank you for persevering.