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 gkittelson 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. AzimuthX

    Refresh CR in VBA (AS400)

    Dim crxReport Dim crxApplication Set crxReport = Nothing Set crxApplication = New craxdrt.Application Set crxReport = New craxdrt.Report Set crxReport = crxApplication.OpenReport("path.rpt") crxReport.Database.LogOnServer "pdsodbc.dll", "AS400 SYSTEM 2", "AS400HOST", "user", "pass"...
  2. AzimuthX

    Opening and refreshing a Crystal Report through Access

    How do I use the "RefreshButtonClicked" event? It won't refresh properly, it will when I click on the refresh button directly from the Crystal Report Viewer. I have noticed there is the event "RefreshButtonClicked", would this be what I am looking for? Good news is that when I click on the...
  3. AzimuthX

    Opening and refreshing a Crystal Report through Access

    I finally got it to not give an error when logging into the AS400 system. This is a seperate form... I can view the report locally, but I have difficulties refreshing with the parameters. I get a type mismatch error, I am not even sure if this is the right code to refresh the report.
  4. AzimuthX

    Opening and refreshing a Crystal Report through Access

    It is pdsodbc.dll ... hmm? My main problem is logging onto the database, I have the Server Name, Database Name, Login & Password, just having difficulties with the .dll
  5. AzimuthX

    Opening and refreshing a Crystal Report through Access

    Even if I copy the DLL to the folder that the MS-Access file is in... it still says it can not be found.
  6. AzimuthX

    Opening and refreshing a Crystal Report through Access

    I am having difficulties with this line... Configuration Error. File could not be opened because the library "C:\Program Files\IBM\Client Access\Shared\cwbodbc.dll" cannot be found. crxReport.Database.LogOnServer "C:\Program Files\IBM\Client Access\Shared\cwbodbc.dll", "AS400 SYSTEM2"...
  7. AzimuthX

    Opening and refreshing a Crystal Report through Access

    I have already downloaded that... I have no problems opening the specified report (but not through ODBC). How can I be able to refresh the report to the database (ie AS400), because when I click on Refresh from the Form, nothing happens, I must click on the Refresh icon from CR. Then there are...
  8. AzimuthX

    Opening and refreshing a Crystal Report through Access

    I would like to... - open the report (how to connect through ODBC?) - refresh the report (logon to a database) - set parameters I am using Crystal Report 8.0 and Microsoft Access 2000

Part and Inventory Search

Back
Top