Search results for query: *

I am trying to automate the creation of several custom Excel charts (Lines on 2 Axes) from Microsoft Access. I am getting the following error: Run-time error '-2147417851(80010105) Method 'SetSourceData' of object '_Chart' failed This is the line that is causing the problem .SetSourceData...

I am trying to use the CopyFromRecordset action to transfer an Access recordset to Excel. It works on some machines but not on others. On some machines, the code crashes with the following error: Run-time Error 430: Class does not support Automation or does not support expected interface. This...

I am using the following VBA code to transfer recorset data from Access to Excel: rstNew = New ADODB.Recordset xlBook.Worksheets(1).Range(B2).CopyFromRecordset rstNew On some machines, it works perfectly. On others, it crashes with the following error: Run-time Error 430 - "Class does...

In Microsoft Access 2000, I am importing text files from multiple users and then programmatically reading the text files to determine what data the files contain. My problem is that some of the files are created in UNIX and some are created in Windows. Access sometimes has problems finding the...

What is the maximum number of characters that a report recordsource may contain? I'm setting the recordsource dynamically in VBA allowing the user to select a lot of conditions, and with a large number of selections, I am getting the following error: "The setting for this property is too...

The problem: I created a standard report that I want to be used by many users for many different scenarios. I'm trying to allow the user to generate standard reports from many different data sets (tables with exactly the same field names but different names). The attempted solution: I created...