Search results

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.

A little askew, but I have used quite a few programming/ scheduling applications: Various Gantt Charts in Excel - paid & free; they are not very good https://elecosoft.com/products/asta/asta-powerproject/ - this is the UK standard application for scheduling construction projects & every single...

Thanks RonPaii, another nice technique there. Thanks MajP, yes it makes far more sense to wrap in a function in my mind & I find it comforting that I discovered the multiple benefits on my own. Thanks MarkK. This is such an elegant solution to hierarchical data in Access it beggars belief...

Thanks Ron, that addresses my requirements more so - in obtaining different fields from the same queryDef. But I am not keeping the recordset open. I am not leaving the recordset open so that is not an issue. Thanks DocMan - that addresses my requirements more so & similar to what I've been up...

Thanks for the input, it cannot be done at once because the process I'm replicating is recursion. 'Repeating Group', I'm not exactly sure on this, but as a regular user I'm sure you're familiar with MajP's Treeview. That's what I'm up to, but with a Subform, & as I said, instead of using...

Thanks Tom, I've spent my life-savings on the project, quit my job & about to go bankrupt :ROFLMAO:. Long-term plan is to go MSSQL Server/ Azure, but for now I just need to get it working & get back to work, before i am homeless. :eek: That's a great link so thank you.

I cannot see how a domain function is the route when these queries are getting executed tens of thousands of times, against recordsets of around 10k records. Are in around 30 different locations (the callers I mean). Maybe an idea to submit a request to site development to remove the like button...