Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
Password Reminder
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Thread Tools Display Modes
  #1 (permalink)  
Old May 25th, 2006, 09:29 AM
Friend of Wrox
Join Date: Apr 2006
Location: Ternat, , Belgium.
Posts: 159
Thanks: 0
Thanked 0 Times in 0 Posts
Default pivottable form


I have a little problem with the forms I'm using when they have the pivottable view.

I made a custom toolbar to use in my database for navigation (instead of using the same action buttons on every form!) and it works fine on every form except the forms that have a pivottable view... What I first wanted to do then is to create an action button that makes me able to go back to the main menu when I press it, but the button does not appear when I use the pivottable view... There is also no button available like in a print preview that says 'close' or something like this that makes it easy to use...

Is there any way to create some VBA that when the user presses the 'escape' key, this pivottable form closes and the main menu opens again? I would like it to work like this, because the database will be used by people who never used Access before, so I want the application to be as easy to work with as possible.

thanks for any reply or suggestion on this problem...

Reply With Quote
  #2 (permalink)  
Old May 25th, 2006, 11:13 AM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts

If it is just a view, why not make it a report instead of a form? Just a thought.

Reply With Quote
  #3 (permalink)  
Old May 26th, 2006, 07:52 AM
Friend of Wrox
Join Date: Apr 2006
Location: Ternat, , Belgium.
Posts: 159
Thanks: 0
Thanked 0 Times in 0 Posts

Because if I use the form, I can use the + and - on the form to show and hide the data I want...

Reply With Quote

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Access Report from Access PivotTable Form Odeh Naber Access 2 July 24th, 2007 09:33 AM
PivotTable-access rigths for columns harmony82 Access VBA 0 July 19th, 2005 04:28 PM
PivotTable programming Ray Pinnegar Access 0 April 26th, 2004 11:22 AM
excel 97 & pivottable pilmart Excel VBA 1 November 18th, 2003 07:44 AM
PivotTable Column won't go Invisible Stoney Excel VBA 0 November 5th, 2003 06:22 PM

All times are GMT -4. The time now is 04:28 AM.

Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.