switchboard problem

[Guest]

Hi all, when using the switchboard manager abd trying to add a new open
report command, i am getting the following error message "for loop not
initiated". All other commands are working and this command has been used
several times previously. Can anyone advise a solution please?

 

[Guest]

Let's start with the obvious: What happens when you open the report manually?

Next, have you done a compact and repair recently? It might help.

 

[Guest]

Hi Jerry, yes i have done a compact and repair, but did not help.
the problem is only in trying to add a new report to my switchboad.
when i choose the "open report" command the error pops up and a list of
reports is not available to choose from.
The error only occurs when i select the "open report" command.
all other aspects of the switchboard are working correctly.

 

[i_takeuti]

Let's start with the obvious: What happens when you open the report
manually?

Next, have you done a compact and repair recently? It might help.

 

[Guest]

Ouch! The compact and repair should have fixed most problems with the
Switchboard Items table. That leaves two possibilities that I know of.

1. You have a references problem. Go to the following web page for
information on checking references:
http://www.mvps.org/access/bugs/bugs0001.htm

2. Your database has a corruption problem. In particular the Switchboard
form is corrupt at the minimum. First try this: Do a Ctrl + g to open up the
VBA window. Next go up to Debug on the menu. If the first line on the
dropdown isn't grayed out, click on it. See if it compiles or throws some
errors.

If the above doesn't help, corruption is a real possibility. Open up a new,
empty database and import all the objects from the problem database. Don't be
surprised if the Switchboard form won't import as Access sometimes blocks the
import of corrupt objects.

If worse comes to worse, drop both the Switchboard form and Switchboard
Items tables. Then rebuild it from the beginning.

Two other thoughts just dawned on me.
First - has anyone been tweaking the code behind the Switchboard forms or
manually changing the data in the Switchboard Items table? That can cause
grief.
Second - is your database split? If so I once ran into Switchboard problems
until I put the Switchboard Items table back into the Front End mdb file.

 

[Guest]

hi Jerry, yes the database is split. How do i put the table back into the
front end?
Do i just remove the links to the table and import them?

thanks

 

[Guest]

Yep. Drop the link first then import the Switchboard Items table.