June7's latest activity
-
June7 replied to the thread Solved Error 6 Overflow.First, please post code between CODE tags to retain indentation and readability. Second, what line triggers overflow error? I don't... -
June7 replied to the thread Clear out data.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...
-
June7 replied to the thread Solved "Hyperlink, coverage on a table design".Still get same issues. MsgBox and Table1 hyperlinks work. I tried building macro but it tells me MacroTableManager already exists but...
-
June7 replied to the thread Solved "Hyperlink, coverage on a table design".I get error 2046 "The command or action 'LinkedTableManager' isn't available now." Command works fine in another db. I think this...
-
June7 replied to the thread Solved "Hyperlink, coverage on a table design".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...
-
June7 replied to the thread Clear out data.Nothing you have provided, including latest post, counters viewpoint that this db is likely not optimized. And unless you share it for...
-
June7 replied to the thread Clear out data.450 tables for a database distributed to family members? I also suspect this db is not optimally structured. Suggest you post db here...
-
June7 replied to the thread Field to enter ONLY time..Did you mean "unexplained"?
-
June7 replied to the thread Field to enter ONLY time..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...
-
June7 replied to the thread Field to enter ONLY time..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.
-
June7 replied to the thread Field to enter ONLY 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...
-
Perhaps look at TimeValue? ? now() 26/07/2025 19:51:02 ? timevalue(now) 19:51:09 There is also a DateValue() function when you want...
-
June7 replied to the thread Solved Tab in RTF control.AFAIK, Access RTF accepts a very limited set of HTML tags. Can only try and see what happens.
-
June7 replied to the thread Solved IsNull not working in query.I edited my previous post while you were reading. Review again. Did you run UPDATE? I thought it would be an empty string because...
-
June7 replied to the thread Solved IsNull not working in query.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...
