Results 1 to 2 of 2
  1. #1
    nrgins's Avatar
    nrgins is offline some guy
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2012
    Posts
    62

    Using A Chart Web Part In An Access Web DB

    I have an Access 2010 web database that is published to SharePoint Office 365 (P1 account) in which I need to display a chart. Since P1 accounts don't have web parts available, I am using a third-party chart web part called AE Google Chart Webpart (http://www.amrein.com/apps/page.asp?Q=5749).


    I created a page in my site collection, and added the web part to it. Works great! Only thing is, I need to bring it into my Access web db.


    I found this video which says to insert a web browser control on your web db form, and point it to the URL of the page containing the chart web part: http://www.youtube.com/watch?v=QoJJOj64Y-k


    So I did that. I pointed the web browser URL to http://abc.sharepoint.com/teamsite/S...rtWebPart.aspx, where abc.sharepoint.com is my SharePoint main site (not really abc), and ChartWebPart is the name of the page I created which contains the web part.


    Using that URL brings in the chart to my Access form; but it also brings in all the other items on the page (the list of pages on the left; the headings at the top of the page; the Office 365 banner at the top; etc.).


    Does anyone know how to JUST bring in the chart from the page, and not everything else? Do I need to create the page in a different place? Use a different technique besides a web browser control? Edit the page somehow to hide all the other features? Any assistance is appreciated.


    Thanks!

  2. #2
    nrgins's Avatar
    nrgins is offline some guy
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2012
    Posts
    62
    Quote Originally Posted by nrgins View Post
    I have an Access 2010 web database that is published to SharePoint Office 365 (P1 account) in which I need to display a chart. Since P1 accounts don't have web parts available, I am using a third-party chart web part called AE Google Chart Webpart (http://www.amrein.com/apps/page.asp?Q=5749).


    I created a page in my site collection, and added the web part to it. Works great! Only thing is, I need to bring it into my Access web db.


    I found this video which says to insert a web browser control on your web db form, and point it to the URL of the page containing the chart web part: http://www.youtube.com/watch?v=QoJJOj64Y-k


    So I did that. I pointed the web browser URL to http://abc.sharepoint.com/teamsite/S...rtWebPart.aspx, where abc.sharepoint.com is my SharePoint main site (not really abc), and ChartWebPart is the name of the page I created which contains the web part.


    Using that URL brings in the chart to my Access form; but it also brings in all the other items on the page (the list of pages on the left; the headings at the top of the page; the Office 365 banner at the top; etc.).


    Does anyone know how to JUST bring in the chart from the page, and not everything else? Do I need to create the page in a different place? Use a different technique besides a web browser control? Edit the page somehow to hide all the other features? Any assistance is appreciated.


    Thanks!

    Found a solution, thanks to Amrein Engineering, the folks who made the web part. It's quite simple, actually. All you have to do is append ?IsDlg=1 to the end of the URL, and it strips out all the other stuff except the web part! That's it! You also have to use a web part page instead of a regular page (the ?IsDlg=1 parameter gives an error with a regular page, but not with a web part page).

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

Similar Threads

  1. How to Create Chart in Access 2010
    By braveali in forum Access
    Replies: 8
    Last Post: 04-21-2014, 11:07 AM
  2. Create a Column Chart in Access
    By j2curtis64 in forum Access
    Replies: 1
    Last Post: 06-04-2012, 05:32 PM
  3. MS Access GANTT Chart report
    By GaryElwood in forum Reports
    Replies: 8
    Last Post: 04-03-2012, 11:55 AM
  4. Line chart in access report
    By drp in forum Reports
    Replies: 2
    Last Post: 11-29-2011, 09:37 AM
  5. Replies: 2
    Last Post: 07-12-2010, 05:39 AM

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