Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
| Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old July 6th, 2007, 03:01 AM
Authorized User
 
Join Date: Mar 2006
Location: , , .
Posts: 83
Thanks: 1
Thanked 0 Times in 0 Posts
Default Access Report from Access PivotTable Form

Hiya folks!

Can anyone explain how to create an Access report from a PivotTable form?

And what about a PivotTable form that can be formatted (text, colours, etc.)

Thank you!
  #2 (permalink)  
Old July 18th, 2007, 08:46 AM
Registered User
 
Join Date: Jul 2007
Location: , , .
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Well, I know that a report must be based off some datasource, whether it is a table or query, so you'll have to place a table between the pivottable form and the report.

As far as formatting the pivottable form, it seemed quite easy to me, just open the form in design view, and format to your heart's content!

Hope this helps,

Shane
  #3 (permalink)  
Old July 24th, 2007, 09:33 AM
Authorized User
 
Join Date: Mar 2006
Location: , , .
Posts: 83
Thanks: 1
Thanked 0 Times in 0 Posts
Default

Thanks for your reply!

I had created the form using a table that includes all the data. The problem with the pivotable form is I cant seem to format it. When I open the pivotable form in design view, it only shows the form in a "columnar" format. Regardless of how I format the objects, it remains in the Access default format for pivottables when I go back to Form view.

Thank you!



Similar Threads
Thread Thread Starter Forum Replies Last Post
pivottable form Vince_421 Access VBA 2 May 26th, 2006 07:52 AM
PivotTable-access rigths for columns harmony82 Access VBA 0 July 19th, 2005 04:28 PM
Access Report akibaMaila VB.NET 2002/2003 Basics 0 January 17th, 2005 06:19 PM
Resize Access main window from Access form hasseh Access VBA 2 October 24th, 2004 05:15 PM
Populate Access 2000 report text from form BradLee31 Access 1 September 16th, 2004 09:05 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.