Recent content by June7

Assembly/manufacturing type database is probably most difficult to structure and manage (along with family tree) because of recursive nature of data relationships - common topic in forums. I agree with other comments, you need a better understanding of relational database concepts before...

Seems that Collection saves Key as string, regardless of what type original value was. I have never used Screen referencing. It's unreliable. Explicit referencing is best. Hwnd is just as available as the form Caption. I tried your code setting Caption but every form opened after the primary...

Alternatives where Null would not be an issue: 1. open a Recordset object and use Addnew and Update methods - no concatenation involved 2. use parameters

I edited my previous post while you were reading and posting. Review again. Not sure multi-instances is best approach. Have you viewed Allen's Search Form example? This (maybe along with cascading comboboxes) might be more sensible.

I presume "Mr. Brown" is Allen Browne. Were you able to download and open sample db? The Hwnd of form is saved as Key in collection. If you know the Hwnd of form instance, can reference form object in collection like: Debug.Print KLONI.Item("1836326")!SesID The form knows its own Hwnd...

Did you mean "multi-line"?

I tested. Works as long as Debug.Print is not multi-line (not using line continuation). Apparently, it matches until a CrLf is encountered. If your Debug's are all one-liner, then should be good.

Opening form (or query object even when form is open) triggers popup input prompt for each combobox. Selecting in year combobox triggers same popups first time, next time triggers "problem communicating with OLE server or ActiveX control" error. Probably all related to language issue. Sorry...

I tried but language is an issue. Errors just trying to open form. Here's what line of code looks like for me which is definitely not what you posted: Me.Filter = "Year([ÄàòóìÍàÏðèåìîò]) = " & yearVal

Would want version with VBA. I could set DefaultValue for testing. However, language barrier makes review difficult.

Tried to replicate issue. My code works just fine with DefaultValue set in design. Could provide your db for analysis.

Seven characters following circle character look same as name in Navigation Pane. Why are there those additional characters, including circle, in front?

Why do you need to check status of FilterOn property? How are you filtering form? I don't see any code that applies filter to form. Be aware, Access will save the filter criteria in Filter property if a filter is applied to form. Then if FilterOn is still set to Yes when form opens, it will...

This works for me (found at https://stackoverflow.com/questions/72806674/how-copy-text-from-vba-to-windows-clipbaord): Sub testCopy() Dim clipOb As MSForms.DataObject, str As String Set clipOb = New MSForms.DataObject str = "My Text" clipOb.SetText str clipOb.PutInClipboard...

Appear to have fixed this issue in my db. TreeView ImageList property was not set to the ImageList1 control. Even though I set this property and build image list in VBA, seems to need this property set in design. Don't know if this was ever set because I remember this control worked fine when...