Search results

Your class would make more sense if it encapsulated the HandleRightClickOnBillAndPageF functionality directly, like... Private WithEvents tb_ As Access.TextBox Public Function Init(tb As Access.TextBox) As cTextBoxMouseUpOnBillAndPageFStrategy Set tb_ = tb Set Init = Me End Function...

The definition of a memory leak is that the objects are no longer accessible in code. The variables they were assigned to on creation no longer exist, but their references with each other are still valid, so garbage collection does not destroy them. You could only find them back from memory if...

You can create a leak if objects in the collection hold a reference to the collection itself. Obviously the collection holds references to its contents, but if the contents also hold a reference the collection, you have a circular reference, which, if initially declared and constructed in a...

A question to ask yourself: do you want your system in that guy's shop? Who are you in the matter? What are your values, your commitments? • If you want your system in that guy's shop, write a system, deploy it, and support it. • You have an interested potential customer. You have the skills...

We are talking about multiple things here. 1) Select a part from a list, 1a) select using combo vs search multiple fields in a table, 2) hook up a button to run code, 3) manage data collection of JobID, PartID and Quantity to add a part to a job, 4) execute an insert into a table, • My 2c is...

Define in your own mind what your values are, and what you are committed to. If others act poorly, allow them that freedom. • if your own values and commitments are ambiguous, you are more likely to engage in reciprocal poor behaviour. . • you suffer more from bad shit you do, less from bad...

Maybe get more specific about where you are stuck with the bit I quoted. There are multiple steps to accomplish this, for instance... • hook up a button click event handler • execute an insert query ...each having distinct requirements. Also, if you are inserting parts into a job, is there...

Wouldn't it make more sense--and be easier to accomplish--if the next incoming task is assigned to the person with the fewest tasks?

The nuance exists in why they have this desire. • Who, for instance, is actually being destroyed? •

I find it interesting you make such a nuanced acknowledgement your nation has no idea "what hell war actually is," backed up with historical examples, and then leading to an exploration of the dynamics of how that history has affected the people's understanding. • But then, without missing a...

A tidy way to expose class instance constructor methods (and whatever else) from a Library is to group them in a Provider class, which is a sort of cross between a factory and service locator pattern. This reduces pollution of the global namespace with a proliferation of unrelated function calls...

If ITest class exists in Lib1, is marked PublicNotCreateable, and exposes... Public Function TestMethod As String End Property Then in Project1, which holds a reference to Lib1, you can freely do... Implements Lib1.ITest Private Function ITest_TestMethod() As String ITest_TestMethod =...

I don't think Soundex does any phonetic matching, and it is dependent on the first character being correct. At least that is how I remember it.

For data entry convenience on an open text field like taxonomy, you can also use a combo that selects distinct values from the taxonomy field itself. That way any taxonomies previously entered are available for quick selection without linking to a sub- or lookup-table.

There's nothing wrong with doing this, but let's you have a circular reference between ObjectA and ObjectB, so they each hold a reference to the other, and you add them both to CollectionC. In this case setting CollectionC to Nothing does not cause ObjectA and ObjectB to automatically go out of...

No, the Microsoft Scripting Runtime (scrrun.dll) does not depend on VBScript. ✅ Here’s the distinction: FeatureMicrosoft Scripting RuntimeVBScript Library Namescrrun.dllvbscript.dll Main PurposeProvides filesystem, dictionary, and text-stream objectsA scripting language engine Used...

The "Microsoft Scripting Runtime," installed on my machine at C:\Windows\System32\scrrun.dll, and provider of the insanely useful Dictionary, FileSystemObject, File, Folder, and Drive objects, is not the same library this link points to. • Microsoft Scripting Runtime is not being deprecated. •...

It is optional that you receive it as being "banged." It is a public forum. If you post SolutionA billed as education grade content on a public forum, and it "bangs" you that Joey Q. Public posts a claimed-to-be superior SolutionB, then I gently invite you to manage your expectations...

In support of your efforts, for which I have indeed previously expressed my appreciation, I offer readers an idea about how they might to provide this same or better functionality, with less code. Cheers, :cool:

One thing I would avoid... • If the calling form holds a reference to a clsOpenArgs instance, you risk a memory leak if clsOpenArgs also holds a reference to the calling form. In a crash, clsOpenArgs.Class_Terminate() will not run, and neither object will go out of scope because you have a...