Search results

Craig, welcome aboard AWF!

Welcome to AWF!

This is what I have on opening the Nw 2.4 Dev for comparison/info.

Thank you George. New database shows 2.4! I have bookmarked link for reference.(y)

Tom/Paul/George, ??My title shows 2.0 Here is the start of modStartup Option Compare Database Option Explicit Public Const g_strAppName As String = "Northwind Traders 2.0 Developer Edition" Public Const g_dtNorthwindInception As Date = "11/01/2022" Public g_dbApp As DAO.Database...

?? Is there something obvious in the Northwind Traders template that identifies the version?? I have Microsoft® Access® for Microsoft 365 MSO (Version 2411 Build 16.0.18227.20082) 64-bit with automatic updates. Just used the NW Developer Template and everything is referencing 2.0?? Is there a...

amorosik, Further to what others have said, with VBA I don't think it is possible to get function/sub names during program execution. Best you can probably do is get the names at design time. Tom van Stiphout discusses this in this video on Northwind 2.2. You could write code to modify code--...

Hi Paul, I tested with an old database and it's a bit of a nightmare re naming consistency. Or maybe just old age and little practice. Hopefully the logic may be useful to someone.

I like Edgar's solution in #30. But thought I should give identifying subform controls and their sourceobjects a try based on Forms, controls and forms loaded into subform controls. FWIW. ' ---------------------------------------------------------------- ' Procedure Name: Check4Subforms '...

Richard Rost has a current youtube video on this subject. See this

I agree with Markk. This is the most positive interaction I have had with Chatgpt etc. I took a random click event and asked what it actually does; What does this click event code actually do? Private Sub cmdUpdateRowSource_Click() On Error GoTo Error_Handler If (Me.txtSQL & "") = ""...

Welcome to AWF, Kevin!

Ben, Why did you opt for Excel? I agree with George that analyzers exist, but I don't think they describe what the code does. With Access vba you can identify the buttons on every form, and you could extract the click event code for each, However, I think it will require your looking at each...

Ben, If you post a code example along with the desired result, I'm sure others will understand the requirement and offer some vba solution(s). If it's button clicks, then you're dealing with Forms. Isolate Form controls (command buttons), then the button click event code.

Welcome to AWF, Peter.

Welcome aboard AWF!

Nector, Since this is a forum intent on sharing and community, how about sharing your solution that is working so that others may benefit?

Have you tried CoPilot or Chatgpt? Just suggesting that some "definition type" questions might be answered quickly via Google/Chatgpt. Question: (to CoPilot) In MS Access what is the corresponding RunCommand equivalent for DoCmd.DoMenuItem...

Welcome to AWF!

Milhouse4118, You may want to review this article and code by Crystal(strive4peace). The purpose of the utility is Loop through all your Access databases in or under a path and copy what's in the system object table (MSysObjects) for each to the documentation database; and get file...