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 Wanet Telecoms Ltd 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: *

  • Users: dnamm
  • Content: Threads
  • Order by date
  1. dnamm

    [b]Restore new database from an existing database[\b]

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

    Use passed variables from a subroutine as insert into where criteria

    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...
  3. dnamm

    runtime error 2105 you can't go to specified record

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

    whileprintingrecords returns dups

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

    Compare details in two group

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

    Can you display a dabase field when the report is empty?

    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!

Part and Inventory Search

Back
Top