I added a macro on the open event of main switchboard to hide database window based on CurrentUser(). The macro works fine but now nothing happens when you click on the button on the swithboard. The only button that still works is exit access. I assume that my Macro is incomplete, but I am new at this. Running ACCESS 2003. Is there a line that I have to add at the end of the macro to return to the normal switchboard?

I've never found the built-in switchboards useful and I've never used them. The switchboard is just a form linked to a table where you put commands etc. You can create your own and you would find it even easier to manage (and less buggy).

We would have to see a stripped down version of your db to be able to diagnose the problem.

I've never found the built-in switchboards useful and I've never used them. The switchboard is just a form linked to a table where you put commands etc. You can create your own and you would find it even easier to manage (and less buggy).

We would have to see a stripped down version of your db to be able to diagnose the problem.
Been using one since 95/96 still works fine in 2010:D

Been using one since 95/96 still works fine in 2010:DHehe!:D I wouldn't doubt that. Looks like someone has begun loving 2010 :)

There's a switchboard manager in 2007 so I would expect there to be one in 2010. It is rather limited in my opinion, but some would disagree. The rich features (i.e. not you Rich;)) you can get from building your own surpasses that of the switchboard manager.

I know but it beats having to write reams of code

I don't mind. I would rather write more code if I could get more functionality.

I rarely use the switchboards because -

1. I don't like how they look.
2. I usually end up with something that just doesn't fit into the structure it needs.

But the big key is - if you like it and it works for you, why not use it?

I rarely use the switchboards because -

1. I don't like how they look.


They are of course customisable;)