Search results

Hey @Ken Sheridan, on bigger data sets, would it ever make sense to round the date values numerically, like... SELECT tblFish.*, tblFlow.Fish_Count FROM tblFish LEFT JOIN tblFlow ON ROUND(tblFish.Flow_DateTime, 4) = ROUND(tblFlow.Count_Date_Time, 4); ...so...

Well, the bigger cost if you leak a WithEvents variable is that it may continue to handle events after its container closes. So maybe you assign the item to a variable on a subform, in which case a valid subform reference is added to the subscriber list of the WE variable. When the mainform...

Except the suggestion getting old is solved is what attracted my attention ITFP, so this solved distinction, if intended to inhibit ramblings-on, is creating a bigger problem.

Exacta-mundo.

Maybe it is actually a difficult merge? My first suggestion is to post your SQL, because mucking around with what you already have will make it faster to help. What might work is a LEFT JOIN or RIGHT JOIN on the fields relating the tables. You might be using an INNER JOIN, which only returns...

The fact this thread called Getting Old :-( is marked Solved is misleading. IMO.

This class takes a textbox and a strategy, and on TextBox.RightClick it executes the strategy... Private WithEvents tb_ As Access.TextBox Private stg_ As Object Public Function Init(tb As Access.TextBox, stg As Object) As cTextboxRightClickStrategyHandler Set tb_ = tb Set stg_ = stg Set...

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.