Search results

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

I get same error with your v18 file as well: "The expression MouseDown you entered as the event property setting produced the following error: There was an error loading an ActiveX control on one of your forms or reports." I OK past that then click on the TreeView +AppRIbbon item and get error...

My exercise did not involve custom class module. I built forms and controls from scratch. All code behind forms. Just downloaded MajP demo. Right off I get same error as in my db when opening form. Library reference is okay so that is not cause. I OK through error and form sorta works but error...

Would be nice to provide link to MajP's sample. Here is one thread with an attached file https://www.access-programmers.co.uk/forums/threads/majp-treeview.319019/ TreeView and ListVIew are ActiveX controls and come with their own set of issues and learning curve. Quite a bit of code...

As already mentioned by plog, probably don't need a table for Seasons. Season would just be a number field in Episodes table. Initial year of airing would be attribute of Series table. Except now I see the site offers data like Season Artwork and Season Trailers. If OP wants those details, a...

Where is SeriesID in that RowSource? How would that RowSource show all seasons for a specific show as shown in OPs image? Master/Child Links have nothing to do with listbox (or combobox) data.