If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Displaying Excel spreadsheets in an access report
I have an If statement that if #1,
Output query in excel format (raw data) Get object (Excel raw data) Get object (Final Excel rpt reading the raw data from the first spreadsheet) Open Access report (linked clip of above final excel report) Same procedure for Else statement with different raw data spreadsheet, different final report. and different Access report. The problem is, if the first part applies, the program works perfectly, but when the Else part applies, Excel error message says it can't link to the data. Any ideas?? Please help. Dianne |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Display Parameter from Form on Report | sara | Setting Up & Running Reports | 10 | July 19th, 2004 04:54 PM |
Label | SRIT | General Discussion | 2 | June 22nd, 2004 09:42 PM |
access ...excel and infopath integration | trey braid | Using Forms | 0 | June 14th, 2004 11:28 PM |
Analyse with MS Excel - Report Error | Michael Beckinsale | Setting Up & Running Reports | 2 | June 5th, 2004 10:53 AM |
Add-In Link from Excel to Access | Ann Mindy | Worksheet Functions | 0 | November 16th, 2003 04:08 PM |