AL: 2 free tools: 1)List Access Objects 2)VBA Code Documenter, step-thru OpenBypass -crystal, Adrian

Overview of two free tools with source code to document Access databases and VBA projects. See how to use them, and dig into some VBA, with Crystal Long (strive4peace), Adrian Bell (NeoPa), and Peter Cole.

1. List objects for all Access databases in and under a path. Did you write something great but don’t remember where it is? This tool can help you find it, and use for documentation.

2. Read the VBA in a project. Get a list of all the modules, procedures, lines of code, and references, for Access, Word, Excel, PowerPoint, and more.

Crystal (strive4peace) shows how to use the tools and Adrian Bell digs into the bytes to explain the VBA to open a database and bypass startup code. Peter Cole converted the Code Documenter to VBA7 so it works in 32 or 64-bit, adds valuable wisdom..

Maria said that when she ran the Code Documenter on an Access project, she discovered there were 3 times the number of lines she'd estimated. She found Adrian's explanation on window handling fascinating. Adrian will be presenting at the next meeting.

Thanks to Colin Riddington for being the guest host and sharing alternate code to open Access and bypass startup.

0:00 AL: 2 free tools: List Access Objects +VBA Code Documenter, step-thru Open & Bypass - crystal and Adrian for Access Lunchtime
Introduction by Colin Riddington
2:48.5 *List Objects, Loop Access Files*
3:49 Relationships Diagram for List Objects
5:03 Demo
6:15.5 Objects Query
7:42 Files report
10:10 Wildcards
12:36 how long does it take to run?
14:35 Password?
15:10 *VBA Code Documenter*
15:39 #modules, procedures, lines, %code
15:52 #statements, comments, blank lines
15:57 Access, Excel, Word, PowerPoint
16:07 Earliest and Latest Object date for Access
16:39 Relationships Diagram
17:45 Demo
17:48 Find previous results
18:17 Objects
18:46 Modules
19:05 Procedures
19:16 Code Lines
19:24 References
19:46 Reports
20:44 About: downloads, videos, and articles
20:50 Peter Cole made it work in VBA7 for 32 or 64-bit
22:20 API Viewer
23:44 API Scanner
26:23 Wayne Phillips' File Property Viewer
26:52 Article by Chip Pearson on Programming the VBA Editor
27:16 Find analysis for Code Documenter
28:20 Filter Modules and Procedures
28:54 filter procedures, shows duplicate names, minimum lines, and maximum lines
29:24 conditional formatting, procedure name
mark code, comments, and new statements
30:35 find procedures that have Debug
31:24 Word project
32:12 question: what is user-defined? tempvars?
33:00 link Convert Macros to VBA
33:24 Object prefix
USys = User System
MSys = Microsoft System
33:43 Usys tables on Relatioships Diagram
34:24 Will Code Documenter work on non-Microsoft projects with VBA embedded within them?
35:36 Peter - CreateObject
37:04 links to tools
39:34 *Adrian Bell step through VBA to OpenBypass*
54:41 *Next* Basics of Classes in VBA
55:57 what is &H80?
1:00:21 Colin (isladogs) alternate code to open database using shift bypass
https://isladogs.co.uk/open-shift-bypass
1:01:23 Next

*Links*

VBA Code Documenter for Microsoft Access, Excel, Word, PowerPoint
by Crystal Long on MsAccessGurus.com with help from the amazing community
https://msaccessgurus.com/tool/CodeDocumenter.htm
Note: Kent Gorrell updated the download to add more information about procedures. Hopefully this will be posted soon.

Access32to64 (VBA7)
by Peter Cole on ThemeMyDatabase.co.uk
free download API Viewer and APIScanner
https://www.thememydatabase.co.uk/access32to64.html

File Property Explorer
by Wayne Phillips on EverythingAccess.com
https://www.everythingaccess.com/tutorials.asp?ID=Accessing-detailed-file-information-provided-by-the-Operating-System

*Videos*
Crystal's Code Documenter (12:26)
link to pre-VBA7 32-bit version in video description
https://youtu.be/usWFeuhXp9Q

Adrian Bell's Open Access and Bypass Startup (13:14)
https://youtu.be/othsyC4iRb0

AL: Updating API calls in VBA to work with 64 Bit, How To
+ API Viewer using Access by Peter Cole (45:41)
https://youtu.be/nPKZrDpKx1I

AEU: 32 to 64-bit Conversion by Peter Cole (1:11:25)
https://youtu.be/NE-ixCSkEgI

AP: Get Extended File Properties from Windows with free Access tools -Crystal Long, Colin Riddington
https://youtu.be/fwQnhKWo1Ks

*other*
free Access Analyzer
https://msaccessgurus.com/tool/Analyzer.htm

Convert Embedded and Stand-Alone Access Macros To VBA
https://msaccessgurus.com/VBA/ConvertMacrosToVBA.htm

*Next* Access Lunchtime hosted by Maria Barnes
The Basics of Classes in VBA with Adrian Bell (NeoPa)
Tuesday, 28 November 2023
https://accessusergroups.org/lunch/event/access-lunchtime-vba-class-basics/
great starting point for any interested in taking class work further.

Access Pacific:
The Power of Sub classes in Access VBA with Kent Gorrell
Thursday, 4 Jan 2024
https://accessusergroups.org/pacific/event/access-pacific-monthly-meeting-2024-01-04/
advanced uses of classes

AccessUserGroups.org
Access Lunchtime host Maria Barnes
Last Tuesday @ noon Central time
https://accessusergroups.org/lunch/

Видео AL: 2 free tools: 1)List Access Objects 2)VBA Code Documenter, step-thru OpenBypass -crystal, Adrian канала AccessUserGroups.org