Search results

@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...

Thanks Pat, no the benefit is I have a single parametized query, which returns several different fields. This parametized query gets executed in many different procedures, many times. Sometimes it returns the same fields, sometimes not. In my little mind this reduces many different queries...

Thanks Doc_Man, Pat. Correct, that's what I'm up to; a query parameter executed from a function & from your great book recommendation using a saved query for the benefit you mentioned. But in my little mind I have the benefit of only a single line of code calling the function to return the...

So is Azure quick when using Access as the front-end? I think I've read quite a few posts stating it is nut. My limited understanding is that MS Access does not run well with online solutions as it was designed to work on local machines/ networks & something to do with packet-sizes on a network...

I'm considering doing this but it does not seemed a recommended solution & I'm confused why this is not a more common question; I'm obviously missing something. I have a common precompiled select query (as it's used so often to maximise speed) to obtain different values assigning the result to...

I wondered why people only seem to talk about MS SQL Server/ Azure. Azure seems to be ridiculously expensive & always wondered why don't people use PHP/ MySQL...

Thanks Doc_Man