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 bkrike 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: thomasyu
  • Content: Threads
  • Order by date
  1. thomasyu

    Crystal report 6 behaviour

    The following are my findings on sub-report problems during the past 3 weeks The crystal report by default will abstract the db name from the DSN and put it as name your reference. i.e. If you refer to a table MyTable of Mydb, the object reference will be Mydb.dbo.MyTable. Under this...
  2. thomasyu

    How to read existing querydef object in a mdb that require parameters

    I already define a querydef called ABCDelete in MS Access mdb which have the following definition. PARAMETERS [param1] date, [param2] text; DELETE FROM ...... How can I execute and supply the parameters by means of DAO in VB or VBA? The following cause runtime error at the CreateQueryDef - too...
  3. thomasyu

    Subreport: cannot/don't know how to refresh subreport dbname thru VB

    Environment ========== I have a CRW6 report with 2 sub-report that retrieves data from SQL server. The report is running as a .rpt file and is triggered by a Visual Basic exe. Symptom ======= The report produces error stating that dbname.table.field not found when the sub-report is present...
  4. thomasyu

    Unable to refresh DBName of subreport

    I have a rpt of CRW 6.0 which contain a sub-report. I invoke the rpt file thru a VB executable with connect property of the OCX set to the proper database. It is because the report is intended to run under different db, a testing db, a UAT db, a production db. I have downloaded a utility in...

Part and Inventory Search

Back
Top