|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 10th, 2006, 12:32 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
query running a sheet in datasheet view despite property setting
Hi,
I have a query that is running a "select * from sheet X" command where I want it to display a graph . Now the query works fine but when I run it off a command button on my main form it fails to display my data as a pivot chart even though It does it by default when I run the query from my database window. I have set the default view of the query to pivot chart but this is ignored when run through my form. Any ideas ? Cheers 
|
|
#2
March 10th, 2006, 05:01 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
query running a sheet in datasheet view despite property setting
If you created the button using the Wizard, the code should look something
like so: Dim stDocName As String stDocName = "qry3Years" DoCmd.OpenQuery stDocName, acNormal, acEdit Change acNormal to acViewPivotChart . -- Jerry Whittle Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Eamonn" wrote: Hi, I have a query that is running a "select * from sheet X" command where I want it to display a graph . Now the query works fine but when I run it off a command button on my main form it fails to display my data as a pivot chart even though It does it by default when I run the query from my database window. I have set the default view of the query to pivot chart but this is ignored when run through my form. Any ideas ? Cheers
|
|
#3
March 10th, 2006, 05:01 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
query running a sheet in datasheet view despite property setting
If you created the button using the Wizard, the code should look something
like so: Dim stDocName As String stDocName = "qry3Years" DoCmd.OpenQuery stDocName, acNormal, acEdit Change acNormal to acViewPivotChart . -- Jerry Whittle Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Eamonn" wrote: Hi, I have a query that is running a "select * from sheet X" command where I want it to display a graph . Now the query works fine but when I run it off a command button on my main form it fails to display my data as a pivot chart even though It does it by default when I run the query from my database window. I have set the default view of the query to pivot chart but this is ignored when run through my form. Any ideas ? Cheers
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Cross tab query construction with Subqueries | Steven Cheng | Running & Setting Up Queries | 7 | February 13th, 2006 06:52 PM |
| Datasheet View property does not work consistently | Shek5150 | Using Forms | 4 | January 26th, 2006 05:59 PM |
| Problem with Dual subselect | robert d via AccessMonster.com | Running & Setting Up Queries | 7 | January 2nd, 2006 05:51 AM |
| AHHHH-Get Data from Multiple Excel workbooks | JAA149 | General Discussion | 5 | October 30th, 2005 05:19 PM |
| Taher | Setting Up & Running Reports | 1 | August 31st, 2004 09:07 PM | |
Linear Mode
