Switchboard basic

[יריב החביב]

Hello,

Can someone explaine, please, in a few basic words

what is the use oF the Switchboard.

and maybe where can i read more about it.

THANK'S

 

[Klatuu]

It is just a menu system to allow you to open forms, run reports, queries, or
macros.

 

[Larry Linson]

It is just a menu system to allow you to open
forms, run reports, queries, or macros.

Access has a Switchboard Manager feature, which creates a switchboard in a
particular format, uses a Table, etc.. IMNSHO, that is a complex solution to
a simple problem, is difficult to maintain if anyone "touches" one of the
forms, the table, or code involved, and, to top all that off, is inflexible.

Many experienced Access developers, simply create unbound Forms, add Command
Buttons to Open Forms and Reports, some of which may open similar unbound
Forms (if needed for the structure of their application). This is a simple
solution to a simple problem, and is flexible, in that you can add other
functionality (for example, allow the user to enter information that
identifies for which customer you want to open a form showing that
customer's information).

Larry Linson
Microsoft Office Access MVP

 

[Klatuu]

I agree wholeheartedly.

 

[Larry Linson]

Hehehe. I'll bet you are so unlikely to use the Switchboard Manager, that
you just forgot to mention it. I'd hate for a new user to be "led off down
that garden path", because it wouldn't be long before we heard from him
again, wondering why "my switchboard doesn't work any more".

Larry

 

[Klatuu]

True, perhaps I was a bit dismissive.
The only time I have worked with a Switchboard or Macros is in applications
that already have them.
With one exception. I have some maintenance routines that run from the
Windows Task Scheduler, so I use an autoexec macro to kick them off. Just a
RunCode action that launches the app.

 

[יריב החביב]

thank you both