Northwind 2.0 fresh template startup errors on Access 365

[Charlie8585]

Bizarre issue. I'm trying to create a new Northwind 2.0 database (File > New > Northwind 2.0 dev edition (or Starter edition - same behaviour).
As soon as it loads & I hit "Enable content", the Public Function Startup() throws a Compile Error with variable OneTimeProcessing not defined. If I get past that by stopping all macros, as soon as I try to open forms etc. I get macro errors - all Compile Error: Sub or Function not defined errors.

I've tried:

• restarting PC
• Northwind 2.0 Starter (instead of Dev Edition)
• creating/saving file from Trusted Locations (Desktop, Documents, OneDrive folders)
• creating it, saving it then closing Access and reopening file
• adding containing folder to Microsoft Office Trusted Locations

None of these solve it. Northwind 1.0 Legacy works fine though.

System details below. Does anyone have any suggestions?


My system:
OS: Windows 11 Home, v10.0, build 22631
Version: Microsoft® Access® for Microsoft 365 MSO (Version 2410 Build 16.0.18129.20158) 64-bit
Tools > References:

 

[arnelgp]

the error already suggest something and i don't think the reference has got to do with it.

 

[Gasman]

Time to walk your code. Basic Debugging 101.
This is in modGlobal.

Public Sub OneTimeProcessing()

10        On Error GoTo Err_Handler

20        If Not GetSystemSetting(ssFirstTimeRun) Then
         
30            SysCmd acSysCmdSetStatus, "One-Time Processing. Please stand by."
40            DoCmd.Hourglass True

50            SetDatesToCurrent     'So new instance is working with current data.

60            SetCtrlCurrencyFormat

70            AddDataMacros

80            SaveSystemSetting ssFirstTimeRun, True

90            SysCmd acSysCmdClearStatus
100       End If

Exit_Handler:
110       DoCmd.Hourglass False
120       Exit Sub

Err_Handler:
130       clsErrorHandler.HandleError "modGlobal", "OneTimeProcessing"
140       Resume Exit_Handler
End Sub

 

[GPGeorge]

Bizarre issue. I'm trying to create a new Northwind 2.0 database (File > New > Northwind 2.0 dev edition (or Starter edition - same behaviour).
As soon as it loads & I hit "Enable content", the Public Function Startup() throws a Compile Error with variable OneTimeProcessing not defined. If I get past that by stopping all macros, as soon as I try to open forms etc. I get macro errors - all Compile Error: Sub or Function not defined errors.

I've tried:

• restarting PC
• Northwind 2.0 Starter (instead of Dev Edition)
• creating/saving file from Trusted Locations (Desktop, Documents, OneDrive folders)
• creating it, saving it then closing Access and reopening file
• adding containing folder to Microsoft Office Trusted Locations

None of these solve it. Northwind 1.0 Legacy works fine though.

System details below. Does anyone have any suggestions?


My system:
OS: Windows 11 Home, v10.0, build 22631
Version: Microsoft® Access® for Microsoft 365 MSO (Version 2410 Build 16.0.18129.20158) 64-bit
Tools > References:

View attachment 117304

Thank you for your report.

We recently delivered version 2.4 the Northwind Dev template to be processed and deployed by Microsoft. It is working its way through their process.

In the meantime, version 2.3 is the version you should get now, not 2.0, so please download a fresh copy and try again. Note: there is a bug in v2.3 that can raise input boxes when you first initialize the template. That's one of the things we fixed.

Thanks again to everyone who continues to provide feedback.