Search results

For data entry convenience on an open text field like taxonomy, you can also use a combo that selects distinct values from the taxonomy field itself. That way any taxonomies previously entered are available for quick selection without linking to a sub- or lookup-table.

There's nothing wrong with doing this, but let's you have a circular reference between ObjectA and ObjectB, so they each hold a reference to the other, and you add them both to CollectionC. In this case setting CollectionC to Nothing does not cause ObjectA and ObjectB to automatically go out of...

No, the Microsoft Scripting Runtime (scrrun.dll) does not depend on VBScript. ✅ Here’s the distinction: FeatureMicrosoft Scripting RuntimeVBScript Library Namescrrun.dllvbscript.dll Main PurposeProvides filesystem, dictionary, and text-stream objectsA scripting language engine Used...

The "Microsoft Scripting Runtime," installed on my machine at C:\Windows\System32\scrrun.dll, and provider of the insanely useful Dictionary, FileSystemObject, File, Folder, and Drive objects, is not the same library this link points to. • Microsoft Scripting Runtime is not being deprecated. •...

It is optional that you receive it as being "banged." It is a public forum. If you post SolutionA billed as education grade content on a public forum, and it "bangs" you that Joey Q. Public posts a claimed-to-be superior SolutionB, then I gently invite you to manage your expectations...

In support of your efforts, for which I have indeed previously expressed my appreciation, I offer readers an idea about how they might to provide this same or better functionality, with less code. Cheers, :cool:

One thing I would avoid... • If the calling form holds a reference to a clsOpenArgs instance, you risk a memory leak if clsOpenArgs also holds a reference to the calling form. In a crash, clsOpenArgs.Class_Terminate() will not run, and neither object will go out of scope because you have a...

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