Switchboard

[Prayder]

OK, so I have a switchboard page that works exactly like it is supposed to..... unless I add a label within the design view that holds the current date. I created a label control that holds the "v7.2.2013" info and that's it. But now when I open the db and the switchboard page comes up, when I click any option on the switchboard page I get

   The expression On Click you entered as the event property setting produced the following error: Automation Error

When I click ok on this box it goes away and I can click on an option on the switchboard page and it works....

If I delete the label box the page works without a hitch..

 

[gemma-the-husky]

i use the inbuilt switchboards regularly, but you have to be careful how oyu change them. you need to understand how they work with the switchboard items table. The switchboard generated in A2010 works differently to that generated in A2003 (not sure which type you get with A2007 offhand)

I suspect it depends exactly how and where you coded the label behaviour.

 

[Pat Hartman]

I use the built-in switchboard all the time. But, since I don't like the A2010 version (macro driven), I just copy a Switchboard form from a different application and modify the [Switchboard Items] table. The Switchboard has several flaws which I have written about several times. I have corrected them and so the forms I copy include the fixes I made years ago. I just change the layout and color scheme to match the new app.

What I like about the Switchboard is the fact that it is data driven and all I need to do is to change the data table to change the switchboard. I even have a couple of apps where I added columns to [Switchboard Items] to create custom switchboards for each user group. So, managers, see some items, users see others, and admins usually see them all. It is simplistic but all it takes is modifying the query the form uses to get the items for the current page. You do have to give some thought to orginization of the item lists so it won't look funny for the user groups since the item numbers don't change. Item 1 is still item 1, etc so you need to make the gaps make sense if you can.

I'm working on creating my own version that uses a subform rather than fixed buttons so I won't have the gap issue when I use this type of security.

 

[Prayder]

Unfortunately I am not fluent enough with access to be able to create my own switchboards... so using the wizards are easier for me. As time goes on and I become more at ease with the program I have no doubt I will change as well. Thank you for all your input...