June7's latest activity
-
June7 replied to the thread Clear out data.The "tool" is a DELETE query with filter criteria. -
June7 replied to the thread Half Hidden Nav Buttons.Review https://www.accessforums.net/showthread.php?t=91036
-
June7 replied to the thread Split Form trouble.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...
-
June7 replied to the thread Solved Option Explicit?.No. As noted in post 23, line "Option Explicit" has to be manually added to existing modules. All the property setting does is...
-
June7 replied to the thread I need help. How can I display the Total Amount and Net Amount on the main form? I am not able to do it. Please help..Expression must reference subform container name. I always name container different from object it holds, such as ctrDetails, then...
-
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.