Solved Switchboard Error 2001

[mib1019]

This is probably an easy fix, but I haven't been able to find it. Thanks in advance for your help in getting this pesky problem resolved.

I have used the Switchboard Manager to create my Switchboard for new database.

On opening the database from the Access File menu, I get the 2001 error, coming from the embedded macro behind the form.
Action Name: SetTempVar;
Arguments: SwitchboardID, DLookUp("SwitchboardID","Switchboard Items","[ItemNumber] = 0 AND [Argument] = 'Default'")

Interestingly, if I right click on the Access icon on my taskbar and open the db from the Recent list, the error doesn't happen; nor does it occur when opening the db via a shortcut on my desktop. Also, opening the file from Windows Explorer does not produce the error.

Only when I open the file from the Access File menu.

Your thoughts?
MIB1019

 

[June7]

There is reason MS deprecated the Switchboard Manager.

I don't like and never used it. I prefer VBA - it is easier to debug.

If you want to provide db for analysis, follow instructions at bottom of my post.

 

[theDBguy]

Hi. Welcome to AWF!

What is the error message for error number 2001?

 

[Gasman]

Perhaps start with the first link from here.? Is the location Trusted?

Google Search

 

[mib1019]

Hi. Welcome to AWF!

What is the error message for error number 2001?

Hi. Welcome to AWF!

What is the error message for error number 2001?

I get this Macro Error Box

 

[theDBguy]

I get this Macro Error Box

View attachment 82924

Thanks! What does the DLookup() expression return? What happens if you replace TempVars with LocalVars? Have you considered using VBA instead of Macros?

 

[arnelgp]

check if table Switchboard Items exists on your db.
if you renamed it, use the new table name in the macro.

 

[mib1019]

I had Access translate the embedded macros to VBA and it got worse, but may be more helpful in debugging. Here is the Switchboard Items Table

Switchboard Items Switchboard Items

SwitchboardID	ItemNumber	ItemText	Command	Argument
1​	0​	Main Menu	​	Default
1​	1​	Companies List	3​	Company List
1​	2​	Company Detail Form	3​	Company Details
1​	3​	Quick Journal Add(s)	2​	Journal Quick Add Form
1​	4​	View Journal	3​	Journal
1​	5​	Timeshare Termination Team	1​	2
1​	6​	Do Maintenance	1​	3
1​	7​	Exit Access	6​
2​	0​	Timeshare Termination Team Menu	0​
2​	1​	Back to Main Menu	1​	1
2​	2​	TTT Media Companies	3​	TTT Media Companies
2​	3​	Add New Insertion Order	2​	Insertion Orders
2​	4​	All Insertion Orders	3​	Insertion Orders
2​	5​	View Account Executives	4​	Station Account Executives
2​	6​	Insertion Orders Summary Report	4​	Insertion Orders Summary Report
3​	0​	Maintenance Menu	0​
3​	1​	Back to Main Menu	1​	1
3​	2​	Categories & Subcategories	3​	Categories
3​	3​	Journal Task Lookup	3​	Task Lookup

 

[arnelgp]

it look normal to me.
have you tried editing the Switchboard in Design view and saving it again.

 

[mib1019]

Thanks everyone. Pat, your switchboard worked for me, but I have opted for creating my own Dashboard form and it's working great.

MIB1019