Recent content by rugrats

Hi all. Thanks for the help. Patrick, yes we have some applications running VB for the front end... and we are using crystal report for reporting... that's using crystal report viewer control and some coding behind it. We also have a lot of other applications running Access 2000 for the...

Brian, the sample application from the BO support site need crystl32.ocx which is not available on my PC. We are using Crystal Report 8.5 and Access 2000 on Windows XP. Tried to reinstall Crystal Report, no luck. I'll look for the control somewhere else...

Thanks for the tip. I'll take a look at it in a moment and report to you the result...

Thanks for the reply. We discover that. However, this time, we need to do something else with some other applications. part of Our system is running Microsoft Access as the front end for desktop application. However, Microsoft Access cannot provide a generic crosstab report like Crystal...

Hi everyone. I need to open a Crystal Report report from Microsoft Access Application.Could anyone help me on this? Thank you.

Can it be done just by using ADO?

Hi all; Does anybody knows if Access images stored in SQL be displayed to screen by VB6 application? Thank you.

Well, it does work with those images captured by VB. But when it comes to images captured by Access, I got stuck: Invalid Picture. The images that we stored only range between 28Kb to 80Kb. I'll try closing the system object as suggested, if it could help.... FYI, I've even tried using DIBs...

Hi vb5prgrmr, thanks for the tips. Amazingly I've tried the getchunk method.. below is the code I used (there are few others, this is one of them). To display the picture, I call Call BlobToFile(rs!BLOBField, "c:\BLOB.dat", _ rs!BLOBField.ActualSize...

Hi all. Below is the code I use to display image from SQL 7.0 using VB6 (ADO 2.5). When it comes to image captured by MS ACCESS before, I got error message Invalid Picture. Anybody know how to overcome this? Thank you. Sub GetAndShowPicture(rs As ADODB.Recordset, strTempFilename as String)...

try this out! IF something1 = somethingB OR _ something2 = somethingA OR _ somehting3 = somethingC THEN .......... use the underscore character "_" to saperate the lines.. good luck!

Hi; here's the scenario. We are using SQL Server 7.0. Before, we were using Access 2000 as the front-end. Images were captured and stored in SQL, displayed back in Access, no problem. Now, we are trying to upgrade our user interface to VB6 application for some reasons. Problem araise when we...