Switchboards

[jkelly]

New user.....
I have a few pivot tables with charts and would like to have a switchboard
take end users directly to the pivot charts so they can modify the charts
before printing. Can I do this without writing code?

 

[Ed Robichaud]

You can use the Switchboard Manager to create a menu form with buttons that
open other forms. Unfortunately, without some minor code editing of the
wizard generated code, they will not open in pivot table view.

You can also make your own unbound menu-type form and use the command button
wizard to add buttons that open forms. Again, you have to edit the wizard
generated code to view your pivot charts/tables.

Below is an example:

Private Sub btMyButton_Click()
On Error GoTo Err_btMyButton_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frmMyPivotChart"
DoCmd.OpenForm stDocName, acFormPivotChart, , stLinkCriteria

Exit_btMyButton_Click:
Exit Sub

Err_btmyButton_Click:
MsgBox Err.Description
Resume Exit_btMyButton_Click

You'll need to add "acFormPivotChart" to the DoCmd.OpenForm line, or
"acFormPivotTable".

-Ed