Search results

Tight-coupling defeats scalability. They are inversely proportional.

Maybe not exactly to your point, but I wouldn't link to a table just to get one field. A link is a necessary evil, a data point you create in order to support a relationship between entities, but if the related entity is itself only one data point, omg, just put that data directly in the object...

True, but the calling form knows about the popup, and explicitly references its named members, so this is still a tightly coupled approach. To improve this, the popup might implement an interface, and then the calling form can reference the interface. Then they would be more truly agnostic...

Here's a simple way you can communicate between objects in an application without them knowing anything about each other. This example passes a command button and a string to a form opened with the acDialog switch, after it opens, from the form that opened it. To run the sample, open the fTest...

I would not do such a conversion. Trading time for value, I would get going in TwinBasic--which supports DAO anyway--long before I would convert an exiting DAO application to ADO.

This is a statement by a person about herself. This is not a statement about OOP. Everything you do as a programmer is underpinned by OOP. You may not write classes, but the context in which you write code and every resource your code consumes is a class, and is exposed by a class. Any action...

I write a service class for almost any information domain in an application. The service class takes responsibility for all business logic in respect to a particular domain. Any and all business logic--exactly like the kind of thing you are talking about, where if one date is advanced, a second...

Dim m_filter(2) As String Private Sub txt_search_box_KeyUp(KeyCode As Integer, Shift As Integer) SetFilter 0, "[fiscalyear]", text_search_box End Sub Private Sub txt_search_box2_KeyUp(KeyCode As Integer, Shift As Integer) SetFilter 1, "[Field2]", txt_search_box2 End Sub Private Sub...

You can put text on the clipboard with this... With CreateObject("new:{1C3B4210-F441-11CE-B9EA-00AA006B1A69}") .SetText < your text goes here > .PutInClipboard End With This creates a late-bound MSForms.DataObject

You are trying to do too much all at once. Create a stand-alone selection interface based around a listbox. Then run the update process using that selection. Then present the results. Rolling it all into one like you are trying to do, because you think it will be less work, is having the...

With CurrentDb.CreateQueryDef("", "SELECT * FROM InvoicePayments WHERE PaymentDate = pDate") .Parameters("pDate") = Me.UnallocatedReceipts.column(3) Set rst = .OpenRecordset End With

When you use the =Sum() function, you are summing the expression for all rows. This is more commonly used in a header or footer to show totals. Try =Nz([Stop_Current])-Nz([Current_Price]) in your Textbox.ControlSource

I don't know if this would work, but it did occur to me. Might offer another idea... 1) Make MajP's calculated field as posted in #5, but do it like... Selected: IIF(YourField = "HorizonLLC", "Yes", "No") 2) Set up combo35 to have three rows and two columns, with the first column bound and...

FWIW, I explicitly close recordsets, but I do not routinely set recordset object variables to nothing. The way I understand it is that VBA garbage collection operates on reference counts. This means there is a VBA internal structure mapping declared object variables to existing object instances...

Same as your previous deflection, same low bar, that as long as someone else is weaker. This is called a bias, commonly held to be invisible to the holder of said bias.

This, because of a failure of what used to be American leadership of what used to be known as the 'Free World.'

If I was president of the United States of America, and cameras were rolling, I would first of all demonstrate that there is a cool and steady hand at the rudder. Job #1. No other messaging comes close in value to that one, regardless of the situation, regardless of the deal currently on the...

Strength and confidence do not raise voices and wag fingers. What raises voices and wags fingers is weakness and vulnerability. Think of the people you know who, when there's a huge pile of chips in the centre of the table, lose their shit like Trump and Vance lost their shit. If a foreign head...

I think the fact it is possible, in font of cameras, to 'set off' the President and the Vice President of the United States is THE issue. It doesn't matter what was said, who said it, none of that. With everything that is at stake here, the fact those two men can't keep their collective shit...

Tariffs raise prices because the landed cost of a product is artificially inflated. This makes it more attractive to produce locally and stimulates domestic manufacturing, true. But since the landed cost of an offshore product remains high, the domestic producer charges more, and prices stay...