Question Scroll Bars Don't Appear

[wazawak]

I have used a form to basically dump all of the data from all of my tables onto a PivotTable, but there is a problem. Even though the PivotTable has grown far beyond the size of the window, no scroll bars appear to let me look at offscreen data. I checked the format entry in the form's details (that window you get from double-clicking the little square in the upper-left hand corner), and scroll bars is set at "both." What is going on here?

A separate but somewhat related issue is that when I try to use a command button to open the form [using the "Open Form" command], Access insists on opening the the pivot table using Form view instead of PivotTable view like the default settings should command it to do. Is this some sort of special command written into the command button? I'm sick of going view->pivottable view every time.

 

[boblarson]

For your second issue -

DoCmd.OpenForm "YourFormName", acFormPivotTable

As for the first, I don't know unless I was able to actually play with the db.

 

[wazawak]

First issue: How can I upload my db for people to see?

Second issue Works like a charm. Do you have the commands for other views?

 

[boblarson]

1. How to upload a db:
http://www.access-programmers.co.uk/forums/showthread.php?t=140587

2. All you have to do is to type that in and when you get to the comma after the form name Intellisense will pop up all of the options you have.

 

[wazawak]

Here is my database uploaded. The problems are in frmSecondPivot, but they apply equally to all of my pivot tables.

 

[boblarson]

Interesting - I do see what you are having a problem with. Not sure why it is doing that. It will take some additional investigation.