Search results

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

I would expect a query the drives a combo to be based on a single table. What you want to achieve using a combo in this way is to set the Foreign Key field in the parent table. For example, if you have one employee, and many departments, and an employee can only belong to one department, and...

How do you "hope" to discuss something? Just discuss it. • This thread went where you took it.

It seems that this pattern, and whether or not others understand it clearly, is really important to you. • I just want to say thanks for bringing your passion, knowledge, and focus to this forum. IMO, it's a welcome breath of fresh air! Cheers, Mark