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 SkipVought 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: *

  1. VBAinspire

    SetSourceData Failing for Custom Excel Chart

    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...
  2. VBAinspire

    CopyFromRecordset Action -> Error 430 on some machines

    Thank you so much!!! I installed the MDAC 2.7 Service Pack 1 Refresh, and it fixed the problem. The executable is located at the following address: http://www.microsoft.com/downloads/details.aspx?FamilyID=9ad000f2-cae7-493d-b0f3-ae36c570ade8&DisplayLang=en
  3. VBAinspire

    CopyFromRecordset -> Run-time error on some machines

    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...
  4. VBAinspire

    CopyFromRecordset Action -> Error 430 on some machines

    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...
  5. VBAinspire

    OpenTextFile Method - mixed tristate format???

    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...
  6. VBAinspire

    Printing Reports

    I created a small sample database for you. It has a popup form with a control box (a list of months) that filters the recordsource for your report. I think it would be easier if I just e-mailed this small sample database to you and then let you ask questions. My e-mail address is...
  7. VBAinspire

    Maximum size of report recordsource?

    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...
  8. VBAinspire

    Create report with a variable recordsource (changing table names)

    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...
  9. VBAinspire

    Leting Users Create Custome Queries and reports

    MichaelRed, Your earlier posting with a solution to the customization problem sounded great. Unfortunately, I am very new to using Access reports and fairly new to using VBA so even though you explained WHAT to do, I don't know HOW to do it. Is there any way that you could post a small...
  10. VBAinspire

    Leting Users Create Custome Queries and reports

    pcdaveh, I was also interested in letting users create their own custom reports. I'm up for the challenge. Could you please send me the sample database from the VBA book that you have? Thank you, VBAinspire AST, Inc. abercrombieal.contractor@trac.wsmr.army.mil

Part and Inventory Search

Back
Top