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!

  • Congratulations strongm 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: djrickel
  • Content: Threads
  • Order by date
  1. djrickel

    How to automate moving a chart from Excel to Word to Access?

    We have an Excel spreadsheet with numerous 3-D chart objects, mostly the 21st Century pie chart but also other bar charts. I need to embed those objects into an Access report but the shadows show up as dots and lines are jagged. I found that linking the charts to a Word doc first, then embedding...
  2. djrickel

    How to properly link Excel Chart to Access Report?

    I am exporting data to an Excel spreadsheet, which creates a couple of charts that I need to link to an Access report. There are a couple of worksheets each containing several charts. 1) when I create an unbound object box and link the spreadsheet file to it, it only picks up part of the first...
  3. djrickel

    Export to Excel, Import to Access Automatically without linking???????

    I need to automate a process of exporting data to Excel, allowing a spreadsheet no-so-affectionately called The Monster, to do its magic, then import the data back to Access to be used in an already-formatted report. I'm smart enough to recognize that this requires VBA but not at all in order...
  4. djrickel

    Thread: Macro runs query that exports to Excel, now how to open additional Excel Workbooks?

    A macro behind a button runs a query that exports a few fields to Excel that are then linked to a couple of monster Workbooks. The button works fine but I cannot figure out how to ALSO do the following at the same time... I need : 1) to suppress the message that says the Excel file already...

Part and Inventory Search

Back
Top