By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,310 Members | 1,885 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,310 IT Pros & Developers. It's quick & easy.

Open pivot table view by default

P: n/a
I want to open to the pivot table view automatically (by default) when
I open a query. I don't want to have to go to the menu first.

I am in Access 2003. I think I did this once but can't remember how it
happened.

Thanks.

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
ar****@yahoo.com wrote:
I want to open to the pivot table view automatically (by default) when
I open a query. I don't want to have to go to the menu first.

I am in Access 2003. I think I did this once but can't remember how it
happened.


In VBA use the OpenQuery method:

DoCmd.OpenQuery "myQueryName", acViewPivotTable, acEdit

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.