Search results

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

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