I've created some pivot table views compiling some statistics from a
table. I'd like to have the pivot table view displayed directly from a
switchboard option. At present, I only get the table view of what
should be the pivot table view when the choice is made. Any suggestions
on how to get the pivot table view rather than the table view? I can do
it manually after the table view is displayed but I want to have the
pivot table view displayed for some not techie people who use the
database.

I'm using Access 2003.

Joe

Hi Joe,

Are you attempting to open a table directly, and then use the View >
PivotTable View menu command? If so, try creating a form instead. Set the
default view to Pivot Table. Or, use VBA code to open your form from a
switchboard:

DoCmd.openForm FormName:="YourFormName", View:=acFormPivotTable


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/ex...tributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

"Joe" wrote:

> I've created some pivot table views compiling some statistics from a
> table. I'd like to have the pivot table view displayed directly from a
> switchboard option. At present, I only get the table view of what
> should be the pivot table view when the choice is made. Any suggestions
> on how to get the pivot table view rather than the table view? I can do
> it manually after the table view is displayed but I want to have the
> pivot table view displayed for some not techie people who use the
> database.
>
> I'm using Access 2003.
>
> Joe

Thanks Tom. I originally did save the form in PivotTable view but the
switchboard manager doesn't have an option to open a form to 'view',
only to 'edit' and/or 'add'. However, the VB code you provided did the
trick for me. I'm not that familiar with VBA so it took quite some time
to figure out where to put the code. It works perfectly, thanks again.

Joe


Tom Wickerath wrote:
> Hi Joe,
>
> Are you attempting to open a table directly, and then use the View >
> PivotTable View menu command? If so, try creating a form instead. Set the
> default view to Pivot Table. Or, use VBA code to open your form from a
> switchboard:
>
> DoCmd.openForm FormName:="YourFormName", View:=acFormPivotTable
>
>
> Tom Wickerath
> Microsoft Access MVP
>
> http://www.access.qbuilt.com/html/ex...tributors.html
> http://www.access.qbuilt.com/html/search.html
> __________________________________________
>
> "Joe" wrote:
>
> > I've created some pivot table views compiling some statistics from a
> > table. I'd like to have the pivot table view displayed directly from a
> > switchboard option. At present, I only get the table view of what
> > should be the pivot table view when the choice is made. Any suggestions
> > on how to get the pivot table view rather than the table view? I can do
> > it manually after the table view is displayed but I want to have the
> > pivot table view displayed for some not techie people who use the
> > database.
> >
> > I'm using Access 2003.
> >
> > Joe