Results 1 to 5 of 5
  1. #1
    tuniwes is offline Advanced Beginner
    Windows 8 Access 2013
    Join Date
    Nov 2015
    Posts
    43

    Modern Pareto Chart "You cant asign a value to this oblect error"

    I have started to update some existing reports, replacing the older hideous looking charts with the modern versions post 2016 and I've just been through three hours of non productive frustration.



    I have a simple query feeding a chart that works fine on the old versions. I can create the chart OK but I'm unable to get the bars to run in Pareto sequence. As soon as I attempt to sort the query in descending order I get

    " You can't assign a value to this object"

    Any ideas on how to resolve this would be much appreciated.

    Thanks

    Ian

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    what object?
    queries dont have objects. Is the q uery trying to grab a field on a form?

  3. #3
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Query worked and able to get Pareto output with MSGraph chart?

    Post the query SQL statement.

    In what way are Modern Charts less hideous?

    I found a possible solution in https://techcommunity.microsoft.com/...es/ba-p/193479

    One commenter asked: How can I define the sort order? I tried to change the order on the query but it didn't work.
    And then self-answered: [Edit] Found it like 30 seconds after posting my question. I changed the value axis to none instead of sum and worked nicely.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  4. #4
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    As an experienced user of Access for over 20 years, I would agree that many people find charting in Access difficult.
    However although modern charts are superficially more user friendly to create, the end result looks almost identical to the older charts.
    Furthermore the modern charts have fewer options and overall are less powerful.
    Any users running Access 2013 or earlier will have an empty space where a modern chart should be.
    Overall, they are very much a mixed blessing!
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  5. #5
    tuniwes is offline Advanced Beginner
    Windows 8 Access 2013
    Join Date
    Nov 2015
    Posts
    43
    Thank you for you comments, I'm still pulling what little hair I have left out.

    I have attached a small database with the graph on a form, this is where I am at. If anybody can see how I can get the sort order to pareto correctly from here I will be much obliged


    Thanks

    Ian
    Attached Files Attached Files

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 06-06-2018, 08:26 PM
  2. Replies: 13
    Last Post: 12-12-2016, 12:26 AM
  3. Replies: 1
    Last Post: 09-07-2015, 08:00 AM
  4. Suppress "Error" message following "Cancel = True"
    By GraeagleBill in forum Programming
    Replies: 7
    Last Post: 03-23-2014, 05:40 PM
  5. "Group By" causes "ODBC--Call Failed" error
    By kaledev in forum Queries
    Replies: 1
    Last Post: 03-09-2011, 02:43 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums