Search results

Why bother with query as form RecordSource since it doesn't have multiple tables and there are no calcs and no filtering? Just bind to table. Your code puts the first record into edit mode with Me.cboProfileDimensionID = Null. This is changing existing data. Since this combobox is BOUND, should...

No. As noted in post 23, line "Option Explicit" has to be manually added to existing modules. All the property setting does is automatically include this line in new modules.

Expression must reference subform container name. I always name container different from object it holds, such as ctrDetails, then: =[ctrDetails].Form.[txtAmtTotal] or =[ctrDetails]![txtAmtTotal]

First, please post code between CODE tags to retain indentation and readability. Second, what line triggers overflow error? I don't immediately see anything that would prevent code running in 64-bit.

Could but don't expect OP to be open to idea. Doesn't like to use VBA. Lost cause here. MVFs are essentially a normalized structure, just hidden. Beyond that, OP has rejected advice to normalize schema. See post 9.

Still get same issues. MsgBox and Table1 hyperlinks work. I tried building macro but it tells me MacroTableManager already exists but I can't see it. Copied table into my db and built macro. Now it works - except for records 1 and 2 - no form and no VBA. At least it confirms Allen Browne...

I get error 2046 "The command or action 'LinkedTableManager' isn't available now." Command works fine in another db. I think this download got corrupted because getting other weird behavior - PropertySheet insists on displaying when form in Datasheet View. Why does Allen Browne indicate...

Not clear to me what you are asking. Do you want to know how the Hyperlink works to open Linked Table Manager? The hyperlink actually triggers a macro that opens the LTM. I tried setting up a Hyperlink field that would open Access objects and it is not working. This tutorial says it should...

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.