How to add Pivot Table to Switch Manager button

[jet_speed]

(MS Project 2010) I need to be able to open a basic pivot table in Access runtime. I am creating a switchmanager but do not know how to add the pivot table option on the switch box.
I found vba intructions online but I am new to vba.


Is there an easier way to do this. Either way I need intructions on how to add the pivot table to the switch box and how to get to the correct vba screen if needed.


Thanks

[June7]

What is 'switch box'?

Create a form based on the table and set the form default view to PivotTable. Open the form just as would any form.

Be aware MS removed pivot table/chart functionality from Access 2013.

[jet_speed]

Sorry I meant switchboard.

I am the only one with full access 2010. I have people with only Access run time needing to view the pivot table in run time. The pivot table will not open in runtime unless it is off of a selection on a switch board. So I need to construct the pivot table off a switch board.

Thanks

[June7]

Sorry, I've never used runtime. I am not sure what you mean by 'off of a selection on a switch board' and 'construct the pivot table off a switch board'.

Pivot table is constructed on a table (or form with table/query as recordsource).

Build the pivot form then set a button on switchboard to open the form.

Will a pivot object even work in runtime?

[jet_speed]

Yes pivots work in runtime but needs to be on a switchboard to open in runtime. I figured it out somewhat. I changed the macro in the button expression builder to open in pivot table but all the forms open in pivot table view not just the one I need.

Still trying to figure it out piece by piece.

[June7]

Did you try just setting the form's DefaultView property and then just opening the form from the macro without any additional parameters in the macro?

[jet_speed]

Yes, the default view only work for the full version of access. The runtime needs to open it off a switchboard.

I think I figured it out with changing the view format in the expression builder.

Thank you for your help.

I might have more questions in the coming months as I am building this status database.