Results 1 to 3 of 3
  1. #1
    tbelly82@gmail.com is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2014
    Posts
    3

    Creating Word 2010 Charts using Access Database


    I am using an Access 2003 database to create a Word report that contains Graphs. We have since moved to Office 2010, and now the vba code will not select the graph and populate the data, i presume this is because the data is no longer in a datasheet but Excel itself. I am only just self learning VBA and Access so am very rusty and any help would be appreciated.
    Sorry for some reason i am unable to past the code, the site crashes.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    Since you have new versions, can you just delete the old graph, then re-embed the graph based on the access query?
    This way Word will use the new versions.

  3. #3
    tbelly82@gmail.com is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2014
    Posts
    3
    Hi Ranman. I have deleted the old graphs, within the word template and inserted new graphs in place, but the existing code does not work, it selects the graph, but then will not select the datasheet and edit it with the new data.

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

Similar Threads

  1. Replies: 1
    Last Post: 03-22-2014, 09:04 AM
  2. Replies: 1
    Last Post: 10-09-2013, 10:09 AM
  3. Creating charts with drill down functionality
    By pmatush in forum Reports
    Replies: 1
    Last Post: 03-04-2013, 06:55 PM
  4. Creating charts
    By iamnamja in forum Reports
    Replies: 1
    Last Post: 07-11-2011, 02:39 PM
  5. Working with OLE excel charts in Access 2010
    By snoopy2003 in forum Programming
    Replies: 1
    Last Post: 02-23-2011, 12:46 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