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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by AzimuthX

  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