Results 1 to 7 of 7
  1. #1
    Join Date
    Jun 2005
    Location
    Waukesha WI
    Posts
    78

    Unanswered: Access: OLE & Report

    I have an access report that contains a pivot table/chart that is linked to an Oracle view. (Don't let that scare you )

    When I change the data, the chart doesn't refresh.
    I'm used to breaking down a task and programtically doing the steps
    In this case, I am lost.

    I manually do the following:
    open the report in design mode
    Rightclick on the object and pick Worksheet Object- edit
    From the Pivot table control, pick the Refresh Data button
    It then asks for the Service Name, UserName and Password for the Oracle ODBC connection
    I then save the report.

    The report is refreshed.
    In the interest of driving the report generation and database via VBA in access, this step is critical.

    I know if I get to the Worksheet Object, there probably is a .refresh method.
    But I dont know how to get there.


    Does anyone have any insight?

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Hi jer

    haven't the foggiest what an access worksheet object is. How did you create it?
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Jun 2005
    Location
    Waukesha WI
    Posts
    78
    The worksheet object is contained in the report.
    I inherited it.
    I assume they inserted a Pivot table.

    I just cant get at it.
    I'm sure it's really simple - I just dont know where to start.

  4. #4
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Oh - is it an embedded Excel object?

    Could you post a screen dump with your context sensitive menu visible or better yet post the db?
    Testimonial:
    pootle flump
    ur codings are working excelent.

  5. #5
    Join Date
    Jun 2005
    Location
    Waukesha WI
    Posts
    78
    Database is rather large -
    This should show you what I mean however.
    Attached Files Attached Files

  6. #6
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Oh, well you can get ahold of that object by referencing OLEUnbound338....
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  7. #7
    Join Date
    Jun 2005
    Location
    Waukesha WI
    Posts
    78
    I've tried to access it and cant seem to find anything that works. Perhaps I was doing it wrong.

    Can you give me a quick example?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •