Recent content by vhung

Thanks to theDBguy, you nailed it. Sample: DoCmd.MoveSize 5600, 2000, 11900, 8800 'Right=5600; 'Down=2000; 'Width=11900; 'Height=8800 SplitFormSize is no longer an issue!

Good Day AWF For several years I've left this project for some reasons But on this day October 2, 2025, I see it and need to finish Possibilities >make a split FORM for history locator, >download history list from webpage like "Microsoft Edge", Export an Excel File, >may convert file to known...

Good Afternoon, May Add other expressions on Forms and Reports close command,. -------------------------------------------------------------------------- Dim i As Long For i = Application.Forms.Count - 1 To 0 Step -1 For i = Application.Reports.Count - 1 To 0 Step -1 DoCmd.Close acForm...

GOOD Day, ADDITIONAL: DoCmd.OpenForm "User_Form: 101", acNormal, "", "[Office In User]=[Forms]![Copy Of Form: User Log_In]![OfficeName] And [PIP-IN]=""PIP->=50,000""", , acNormal The expression indicated above is the key to the success of my FORMS and REPORTS operations, and it has been...

It is true, "harder to evaluate an .ACCDE" I did go back to ACCDB. Two process should be applied both the examination and evaluation. I agree "about completeness" "Further, if there is any complexity to the event code for the various forms, testing might become a problem because it might...

hello isladogs, I've felt great, only to noticed it while i review navigation pane command with my current project, but then I've found your piece, i make use of it,. "Amazing that nobody has mentioned that issue in the last 3 years!" cheers... though I'm not familiar with add-in but yes...

Hello AWF, Please let me know if a newly created ACCDE is good or very good, In other words how could i (evaluate) the project, is it by using a DOCUMENTER? Any constructive remarks is appreciated. Please see attached file,.

Please see attached file,.

Good day, A package of navigation pane command, Very nice. The coding inserted to a Form On Load,. SORRY i've noticed on The command "Remove Auto Sort", contradicting to "Ascending" or "Descending", i tried to debug the error, see below On Error GoTo Macro_Err On Error Resume Next...

If this code aim to open the hidden pane or hide, then have to single it out; if using "DoCmd.SelectObject acTable, , True" is to open navigation pane then using "DoCmd.RunCommand acCmdWindowHide" is to hide the navigation pane So why have to use the codes together in one command, probably...

Thanks, GUYS, Sorry, it's been years from that of july_2022 i hold back, no more to computers nor internet, i was ASSIGN to field work due to politics as i say,. just as this July2025 am back to my old office as they needed me badly, and am hoping to see back what i had before,. I never...

Thanks Arnel, Hyperlink on Table be on Form and could be in Report,. i tried all objects from FORM TABLE REPORTS QUERY and others it goes through, the last thing i try is to close the accdb using hyperlink, it made me consumed couples of test it fails, then again by using other way a command...

Microsoft Access Tips for Casual Users Provided by Allen Browne Introduction to Hyperlink fields

Now i see/confirmed how useful the hyperlink is, on a table field. Applied on a form then the use of a macro and vba is also applicable,. only i haven't known Allen Browne, sorry,.

Hello, Arnel see it right by using a form, not to direct with table hyperlink,. ,with Arnel sample on MsgBox("Hello Word") using vba seems very good, i tried it using macro it also works,.