Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-17-2017, 05:53 AM   #1
MilaK
Newly Registered User
 
Join Date: Feb 2015
Location: United States
Posts: 282
Thanks: 33
Thanked 2 Times in 2 Posts
MilaK is on a distinguished road
Creating a chart from cross-tab in Access 2016

Hello,

Is it possible to create a scattered plot from a cross-tab query in Access 2016?
I get an error message every time I try. It works well if I export data to Excel and create a chart there but I would like to do this in Access.

Thanks

MilaK is offline   Reply With Quote
Old 07-17-2017, 06:40 PM   #2
The_Doc_Man
Happy Retired Curmudgeon
 
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 14,248
Thanks: 86
Thanked 1,624 Times in 1,507 Posts
The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold
Re: Creating a chart from cross-tab in Access 2016

What error message? How are you attempting to do this? Manually or VBA? Give us a few details, please.
__________________
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.
The_Doc_Man is offline   Reply With Quote
Old 07-18-2017, 04:46 AM   #3
MilaK
Newly Registered User
 
Join Date: Feb 2015
Location: United States
Posts: 282
Thanks: 33
Thanked 2 Times in 2 Posts
MilaK is on a distinguished road
Re: Creating a chart from cross-tab in Access 2016

Hi,

I've created a cross-tab query and was manually adding a chart to a form. Each time Access crashed "error has occurred please restart the program." I haven't tried with vba yet.

Thanks

MilaK is offline   Reply With Quote
Old 07-18-2017, 05:48 AM   #4
The_Doc_Man
Happy Retired Curmudgeon
 
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 14,248
Thanks: 86
Thanked 1,624 Times in 1,507 Posts
The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold
Re: Creating a chart from cross-tab in Access 2016

But it doesn't say WHICH error has occurred?

Is there a chance that at the time you were working, you had disabled warnings? You need to see the actual error. Without it, we're going to be stymied here.

One ugly but possible way to get the error is to repeat the attempt with a "clock gadget" showing on-screen so you can get the time to the second showing when the error occurred. This means you can't maximize the Access window. You need to leave room to see either the clock gadget or, if necessary, double-click the time/date usually shown in the lower-right of the screen so that the time-setting box is up. Just leave it up; don't attempt to set the time. You really want the second-hand to be showing. Once you have that set up, try adding your chart. Get your message as you report it. Note the time to the second as quickly as you can.

Then you need to use the start button in the lower left corner to get to the control panel and activate "Administrative Tools" - and from there, "Event Viewer."

You need to then open each of the System, Event, and Application logs one at a time to find any events within 5 seconds of the time you noted on your experiment. One of them SHOULD tell you more details of an event for MSACCESS.EXE including either "image exit" or "process termination" or something along those lines. Look at the details of that message.

To make the process easier, in the Menu bar of Event Viewer, there is a View which when clicked gives you a drop-down. Select "Preview" and that should give you a single-line list of events with date and time to the second in the 2nd column, event type in the first column. That would let you scroll easily to find the right time. I'm saying 5 seconds either way but it could be a little bit longer. It won't be more than a full minute unless you had pandemonium running on your system at the time.

There is a list of viewable logs on the left of the Event Viewer window. When you click on an event log to view, look immediately in the title bar to see how many events there are. If it is a very big number (and it CAN be in the six-digit range) it might take the viewer more than just a couple of second to display the list. If it is a very big list, you might even get a "snap-in not responding" at first. Formatting a large log in order to show the list is a heavy computing event.

The presence of Office on a system sometimes adds a viewer category called "Microsoft" with a sub-category of "Microsoft Office Alerts" - which would be a good candidate to at least start your search. However, other valid sources of such alerts exist under "Windows Logs". You'll just have to browse.

The key to getting this info is that if your clock gadget or the Windows Clock is showing on screen (perhaps the clock dialog box used to set system time) so that you can get seconds, that clock is showing the actual system time-base, so any events that occur AND ARE LOGGED will include that time. Which is why when you attempt your graph, you must note the time to the second as quickly as possible.
__________________
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.
The_Doc_Man is offline   Reply With Quote
Old 07-19-2017, 12:03 AM   #5
JHB
Have been here a while
 
Join Date: Jun 2012
Location: In the south of Denmark (Jutland), near the German border.
Posts: 7,706
Thanks: 2
Thanked 2,073 Times in 2,028 Posts
JHB has a spectacular aura about JHB has a spectacular aura about
Re: Creating a chart from cross-tab in Access 2016

Quote:
Originally Posted by MilaK View Post
Hi,

I've created a cross-tab query and was manually adding a chart to a form. Each time Access crashed "error has occurred please restart the program." I haven't tried with vba yet.

Thanks
Post your database with the query, form and some sample data.

__________________
If the above post has helped you, why not take the time to say thank you, by pressing the "Thumbs up."
JHB is offline   Reply With Quote
Reply

Tags
charts

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Deploying Access 2016 Front End, Access 2016 RossWaddell General 2 07-24-2016 05:43 AM
Creating Primary Key 2016-001, 2017-001 etc grubnz Tables 8 02-01-2016 06:30 AM
Cross tab / pie chart Indigo Queries 0 07-22-2009 11:27 AM
Creating chart in excel from Access TUSSFC Modules & VBA 6 01-29-2009 05:47 AM
Problem Creating a Chart with Access 2003 Artavius Reports 0 01-19-2006 03:24 PM




All times are GMT -8. The time now is 12:28 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World