Share via

Switchboard not opening when database is opened

Anonymous
2019-01-30T18:41:04+00:00

To start out I am not that good at coding and working with macros and such so I will need a somewhat in depth explanation to resolve this issue

I made a copy of my database so I could create a form to open as a separate switchboard containing reports to print (form Letters) without the risk of damaging my original database. Once completed I was going to make the copy my primary and remove the original.

In the copy of the database I first created several reports which are form letters that populate based on queries. I know this was not the problem as I was able to open and close the database with no problems.

Next I created a form which I named: switchboard2. This form is populated with command buttons that open reports (all the form letters I created).

My database was set up so that when it opened the main switchboard named: Switchboard open automatically. 

On the main Switchboard I have 5 secondary or additional switchboards with the 4th one opening the form named: switchboard2. I did this as I have used all the available space on the main switchboard and the secondary switchboards.

Here is my problem now: When I open the data base I get the following warning box: Box title: Microsoft Access, Message: Return without GoSub Click Ok.

When I click Ok I get a message box named: Macro Single Step With the following information boxes:

Macro Name: Switchboard:Form:OnOpen:Embedded Macro

Condition: This box is blank

Acton Name: SetTempVar

Arguments: SwitchboardID,Dlookup("SwitchboardID","SwitchboardITems",SwitchboardItems","[ItemNumber]=0 AND [Argument]='Defalult'")

Error Number: 3720

My only option to select is: Stop All Macros

I need to know if someone can walk me through how to correct this problem so my main switchboard named: Switchboard opens when my database opens. Again I am not that good at coding so I will need some detail what to do.

Thanks

Bill

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

ScottGem 68,820 Reputation points Volunteer Moderator
2019-01-31T16:35:35+00:00

I would try renaming the form and adding a switchboard entry to just open that form.

Was this answer helpful?

1 person found this answer helpful.
0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-01-31T17:38:47+00:00

    I tried that already and it did not work, however I think I did solve the problem it took some work.

    First I took a screen shot of the switchboard and pasted it to a word document.

    Second I deleted the switchboard table and the switchboard form. I then renamed the other form from "switchboard2" to "Letters and Envelopes".

    I then created a new switchboard using the Switchboard Manager.

    Last I created the secondary switchboards and I have one Named "Letters and Envelopes" which opens the form that I have buttons to open all the letters and envelopes reports and a command to "Return to Main Switchboard".

    I selected the main switchboard to open when the database opens.

    I have the new switchboard about 50% completed and it is working just fine.

    Hope this will also help you if anyone else has the same problem. I think it is the only way to correct the error that I was getting.

    Thanks for all of your help with this problem. Your suggestions helped to guide me to the correct solution.

    Bill

    Was this answer helpful?

    0 comments
  2. Anonymous
    2019-01-31T14:55:18+00:00

    That is what I did. I first created the switchboard which worked fine until I ran out of space. I can only have 5 sub switchboards and each each one only allows 8 options or actions to open a form or report. In the main switchboard I removed all the reports for my form letters and set that up to open the form switchboard2. 

    I came back to the database the next day and when I opened it I got that error message.

    Was this answer helpful?

    0 comments
  3. ScottGem 68,820 Reputation points Volunteer Moderator
    2019-01-30T21:47:09+00:00

    It sounds like you used the Switchboard manager to create your initial switchboard then used a static form for the report buttons. That doesn't work well, what you would need to do with that setup is create a switchboard entry to open the Switchboard2 form.

    Was this answer helpful?

    0 comments