Search results

Nothing you have provided, including latest post, counters viewpoint that this db is likely not optimized. And unless you share it for review, we can hardly be swayed. However, since it seems you are set on continuing with this design, I wish you luck. Did you at least consider recommendation...

450 tables for a database distributed to family members? I also suspect this db is not optimally structured. Suggest you post db here for review. Keep of a copy of db without data. Be aware, any changes to design should be made in a master copy and db should be split so updates to GUI do not...

Did you mean "unexplained"?

Again, when I enter 14:00, field/textbox do not show date part. I do not have ANY formatting in table nor textbox. As far as I can tell, nothing in Windows settings would cause this. I tested in 2010 and 2021, different computers. I had expected date part to show, no idea why it is not.

And where in Windows would be this setting to cause Access to show only time? My System Tray is set to show date and time.

Interesting, when I type 14:00 into table field or bound textbox it is not showing date component. Shows 2:00:00 PM. Format property is not even set to anything. When I click into field or textbox, date still does not show.

AFAIK, Access RTF accepts a very limited set of HTML tags. Can only try and see what happens.

I edited my previous post while you were reading. Review again. Did you run UPDATE? I thought it would be an empty string because length is 0. However, changing to No did not convert to Null. Maybe it allowed empty string to stay. Whatever it is, run UPDATE to eliminate. How did this data get...

I did a manual progressive filter (right click filter menu) on the table and I can get the 52 records. The problem is with DD_ReceiptNo field. The blanks are not all NULL, some have something in there. To see this, run this query: SELECT [Master Data].ID, [Master Data].DD_ReceiptNo...

It's simple. No records can meet all 4 criteria with AND operators. The first 3 criteria return records where WO Date is null for all, so adding that WO Date criteria means no records return. Do you want OR operator?

Why would listbox use ValueList? Isn't the RowSource still a table/query? That's what I do.

Apology for my error. Why do you UPDATE LockID field? Perhaps sample data would be helpful. Access does not allow UPDATE when join involves non-editable dataset.

Should "VPN" be "VBA"? RTF is formatted with HTML tags. There is no TAB tag. Why is textbox RTF? What formatting do you want? Exactly what do you mean by "dialog box"? As far as I can determine, vbTab works for building string to display in MsgBox or InputBox. I have used listbox for display...

What is qryOutstanding SQL? Why do you UPDATE Outstanding field? I suspect this value should just be calculated when needed and not saved to table.

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