Search results

Because Form.Parent will raise an error if there is no parent, I commonly write a custom property on a subform as follows... Property Get ParentName() As String On Error Resume Next ParentName = Me.Parent.Name End Property With the presence of such a property, you can now write code on the...

Remember, a class instance is a discrete and unique object. Your clsDalsTxtBox class is designed as a wrapper around--or container for--a single TextBox. As such, you need a new and different container instance for each different TextBox you wish to contain, and this is why you need a user...

Your Frm code needs to create a new instance of clsDalsTxtBox inside the loop. Each TextBox should be loaded into a new unique instance. Your code creates only one instance, and then inside the loop keeps replacing the TextBox it contains with the next one. Consider... Private m_col As...

Colin, my intent is to get more involved, but I blew it this a.m. (I'm GMT -9 so it was 10am), but I grabbed your .ics link so I've got it now in Outlook as a recurring appointment. Hey George, I just joined the Pacific Access User Group.

Hey @Pat Hartman, best wishes on a complete and speedy recovery! Mark

Hey @isladogs, are these events recorded and available after-the-fact? If so, can you point me to where they can be found? Thanks, Mark

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