Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jer99
  • Order by date
  1. jer99

    Update embeded chart in Report

    The properties tell me that it is OLEUnbound Class=Microsoft Office Excel 2003 OleType = Embedded OleType Allowed = Either classtype = Excel.Sheet.8 I don't know how to refresh it via VBA. I can reference it by Reports!Audit_Report_Page_14!OLEUnbound335.<something> But can't figure out what...
  2. jer99

    Update embeded chart in Report

    I have a report called :Audit_Report_Page_14 that has a chart on it. This chart is linked to a Oracle table via ODBC. Manually this is what I have to do: 1) Connect to the report 2) It asks me my passward to connect to the source table of the chart 3) refresh the data 4) save the report...
  3. jer99

    How to send Access data into a pdf form

    Also try creating a report and using this utility to convert it to a pdf. http://www.lebans.com/reporttopdf.htm
  4. jer99

    Accessing Pivot in Excel with VBA

    A report has a pivot table in it. The pivot table has a chart. The data is based on a ODBC linked table. When the data changes, I currently have to open the report in design view, click Worksheet Objects| Edit and then click refresh. How can I do this in VBA from Access?

Part and Inventory Search

Back
Top