Search results for query: *

Hi, We are using SQL Server 2000 as our DBMS and EZCAP as our front end. I restored a new database named db2 from an existing database named db1. The reason I restored from an exising db1 instead of from a blank database is becuase I have added all the users access to EZCAP into db1. By doing...

Hi All, I'm new at VBA. I'm trying to do an insert statement from a view into an access table. The problem is that I need to use some passed variables from a subroutine as a criteria in the WHERE clause. Could you please show me how to implement it? ex: strsql = "insert into...

Hi All, I'm trying to import the existing Access table called imagestofile into a SQLServer 2000 db. Then, I relinked the table from mssql server db back to my Access application, so I just overide it. Now, when I run the application, I got this error: runtime error 2105 you can't go to...

Hi, Thank you very much! For the DisplayDate, it should be right instead of left. Using left function, it still display the ";" and chop off the last number in the last date. (ex: ;06/30/200 ) DisplayDate: whileprintingrecords; stringvar right(FromDate,len(FromDate)-1); dnamm

Hi, I'm using CR 8.0, database sql server 2000. I'm trying to concatinate all the FromDateSVC of a claim and display it at the group footer (group on ClaimNo). These are my calculated fields ResetDate: whileprintingrecords; StringVar FromDate := ""; GetDate: whileprintingrecords...

Thanks Synapsevampire, My Crystal Report version is 8.5, connecting to SQL Server 7.0. I'm trying to display those claimNo that have at least one proccode (details level) that is the same as the next claimNo. There are only two claimNo will be compared, because these claimNo group is within...

Hi All, I'm currently using Crystal Report version 8.5. I need help in comparing the detail fields on one record (group level) with the details of the next record. ex: I have this ClaimNo as the group field. I want to display only claims that have one or more detail fields that is the same as...

Hi All, I'm trying to display Company_desc (database field) on the report when the report is empty. I've read several ways of displaying text messages. But, my boss wanted me to display the company_desc on the report even if the report returns nothing. Thank you very much!