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

Pivot table

P: 24
I have created a pivot table making reference to a query. It works perfectly well. However, when I go out of the database and then back in the pivot table appears as a "form". I can click on the "design" icon to change back to pivot table. It is however frustrating to have to do this each time. I have checked the properties and everyhting appears to reference to pivot table.

Can you please advise what I need to do to see the pivot table each time I click on the database button I bring up the pivot table.
Sep 5 '06 #1
Share this Question
Share on Google+
8 Replies


P: 29
I have created a pivot table making reference to a query. It works perfectly well. However, when I go out of the database and then back in the pivot table appears as a "form". I can click on the "design" icon to change back to pivot table. It is however frustrating to have to do this each time. I have checked the properties and everyhting appears to reference to pivot table.

Can you please advise what I need to do to see the pivot table each time I click on the database button I bring up the pivot table.

I'm fairly new to Access, so a senior member may be able to give you more help, however, I'm not sure if you're opening form through a command button, but if so, in the macro>'View' select 'pivot table'. Then form should always view as pivot table.
Sep 6 '06 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
A Pivot Table in Access is normally a bound Excel OLE object. Therefore, I don't understand what you mean. The only way it would appear is as an object on a form.



I have created a pivot table making reference to a query. It works perfectly well. However, when I go out of the database and then back in the pivot table appears as a "form". I can click on the "design" icon to change back to pivot table. It is however frustrating to have to do this each time. I have checked the properties and everyhting appears to reference to pivot table.

Can you please advise what I need to do to see the pivot table each time I click on the database button I bring up the pivot table.
Sep 6 '06 #3

PEB
Expert 100+
P: 1,418
PEB
Hi,

Instaed to open your table in Pivot View it's better to create a query using all fields in your table:

You enter in Queries, New Query, then you choose addtable bouton and you choose your table!

Then you click twice on * in the table that will appear!

Then you enter in the query properties window in the property Defalt View as PivotTable and it will work as you want!
Sep 6 '06 #4

P: 83
i understand one thing from my sensei ...to create pivot table you need to define relationship table....but i'm not good enough to understand how to define my table relationship
Sep 11 '06 #5

P: 24
I have tried various approaches. To date I have only been able to open the pivot table in "form view" which I then have to click on design view to "convert" to pivot table. This is really frustrating.

The pivot table is accessed via a button on the "switchboard". I have used a query to set up the pivot table. No probs. When I click out of the database and then access again the pivot table reverts to "form view".

Regards
Sep 24 '06 #6

PEB
Expert 100+
P: 1,418
PEB
Hi,

Obviously your pivot table is based on a form!

Good!

So go in your Form Properties in design view!

Set the properties as shown:

Allow Form View : No
Allow datasheet View: No
Allow Pivot Table View: Yes
Allow PivotChart View: No

If you set the properties like this i'm nearly sure that you wouldn't have pb!

:)
Best regards!
Sep 24 '06 #7

P: 24
Hi,

Obviously your pivot table is based on a form!

Good!

So go in your Form Properties in design view!

Set the properties as shown:

Allow Form View : No
Allow datasheet View: No
Allow Pivot Table View: Yes
Allow PivotChart View: No

If you set the properties like this i'm nearly sure that you wouldn't have pb!

:)
Best regards!

I appreciate the above suggestion. I've tried this and the same thing continues to happen where the form appears when I go back into the database.

I am sure that there must be a simple reason for this. However............

Help
Sep 27 '06 #8

PEB
Expert 100+
P: 1,418
PEB
No more ideas!!!

A foulish question after adjusting your form do you save it?

Are u doing this as Exclusive user?

:)
Sep 30 '06 #9

Post your reply

Sign in to post your reply or Sign up for a free account.