Search results

UNBOUND textbox. A subtlety I never focused on before. Gets more interesting. UPDATE action set text field to Null although I had to change field in table to allow zero length. UPDATE using "", vbEmptyString, or unpopulated Variant all sent NULL to text field. UPDATE of number field fails. Now...

And where did I disagree? Basically along same lines as I was saying - Variant defaults (initializes) to empty string but accepts all values and will implicitly convert (coercion) scalar. My point is CurrentDb.Execute "UPDATE table SET numberfield = " & x & " WHERE something" fails if x is...

It's my experience if control does not get positioned within tab page, it is actually just a control on form sitting on top of tab control and that's why it shows "on each tab", although if there is a subform on page it could be covered by that. If you see a control like that, move the tab...

Access will do implicit conversion if you give it something to work with. Variant accepts any value therefore it can equate to any scalar (except Null because nothing can be compared to Null). Don't compare it to anything. Debug.Print X Debug.Print IsNull(X) If I try to use that unpopulated X...

A Variant type variable will default to empty string if it is not explicitly populated with something, including Null.

I agree that rectangle is not a "container" and this selection of controls is no different for any "group". I am not sure users of any level will be misled, however, perhaps better wording instead of "in it" would be "bounded by it".

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