Search results

If the cost of thing is zero, what do you "save" by reducing its consumption?

But the implementation cost, if you flag trash with a boolean vs a date, is the same. The effort required in all cases: 1) add a field to a table, 2) handle a UI event and save a trash value flag, 3) filter future queries based the trash value flag. In a landscape where storage space is...

Why use the Detail_Paint() event handler? This method runs at unpredictable times, and not in response to changes in your data. For instance, just rolling your mouse over a command button fires Detail_Paint() four times. I don't claim this is the cause of your error, but using Detail_Paint()...

This is what I do too, use date fields, and I record the UserID of whoever did the delete. I mean, not always, but if it matters.

Ha ha, I have lists like that.

One thing I do recall arguing in favour of a few times... • Rather than manage a subset of controls by setting the Tag property in design view, and then enumerating the form's entire controls collection to work with them, do something like... Private cts_ As VBA.Collection Property Get...

Or do smaller chunks, because HideUnload() might be generally useful, and if the button click handler knows the control, pass the control directly. Private cmdContact_Click() ShowSubForm "fContactSFM", Me.sfmBig End Sub Public Sub ShowSubForm(src As String, sfm As Access.Subform)...

Exactly.

I would not alter the visibility of the subform control. Rather I would programmatically change the subform currently hosted by the subform control by changing the subform control's .SourceObject property. Private Sub cmdContact_Click() Me.sfm.SourceObject = "fContactSFM" End Sub

I think that in terms of designing a user interface to manage a process, it is a flaw if the user must return to a previously visible UI component to complete a current task. Even if you solve your z-order problem, the current task UI opens on top of and obscures the data to consult, forcing the...

IMO, a sequence number in table data is a waste. It adds friction to the process of saving a row, and provides zero return on investment. • Payoff: It does not describe when the item was created. It does not provide any meaningful sort or filter opportunities. It has no relationship to any...

I find your naming insanely confusing. What is a 'Property?' Is it the same thing as a 'Location,' as in Real Estate? Is a PropertyTypeAttribute a location type, or does a location have x number of properties, and each of those properties has typed attributes? See what I'm saying? And...

Interesting observation.

:cool: Cheers Isaac,

My main customer is a commercial millwork shop. Those guys claim that if you bend the hinge pins a little it adds sufficient friction to solve unwanted swing from an out-of-plumb frame. I have never tried it myself. • Knock a pin out of a hinge and lay it on a slab of concrete. The head will...

A faster way to get at your Outlook data is to use an Outlook.Table object, so you might have a function... Function GetItemTable(Folder As Outlook.Folder, Optional FromDate As Date) As Outlook.Table If FromDate = 0 Then Set GetItemTable = Folder.GetTable Else Set...

In common practice, you would not move this data to a temp table. Rather, you would save this SQL... ... to a query called "Bay_Sheet." For most purposes, consumers of the temp table "Bay_Sheet" will not distinguish a difference, and the GetBaySheets() method can be deleted. In almost all...

• This is why we must always cultivate in ourselves humility and respect for those with whom we disagree. It is always possible that in our own views we are the Germans, blind to countervailing evidence by the obvious--to us--superiority of our own understandings. • The Germans' fundamental...

• Return the leading comma in all cases, and always remove it... Mid(IIF(SpecialSS, ", SS", "") & IIF(SpecialDT, ", DT", "") & IIF(SpecialSGT, ", SGT", ""), 3) • Also, in boolean math the operation '= True' is called the Identity Function and it has no effect on the outcome. • False = True...

I would not embed this kind of business logic in the UI. Consider writing a service class, like cOrderService, and expose this logic as a public method. Then, in your UI, just do... Private svcOrder As New cOrderService This serves to... • Simplify the code in the UI, making it easier to...