Search results

Disable the error handler and step through code. You could provide db for analysis. Maybe someone is running 64-bit Access and will look at. Not me.

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.

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.