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 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: *

  1. losthorizon

    Access 97 to Access 2000 - database upgrade problems

    Please excuse the duplicate posting; this having been posted under "Relationships" before... At first, we thought our problem was a "relationship" problem, but that now all seems okay, after doing some more checking. We were having a problem with '#deleted' showing up in bound controls...
  2. losthorizon

    relationship deleted - how did that happen?

    Posted this earlier under 'Other Topics,' then found this subject heading; felt it was more appropriate posted here, instead!: When I create a relationship between any two tables in the relationship window, enforcing referential integrity and cascading deletes, it is created without any error...
  3. losthorizon

    Relationships deleted in relationship window.

    When I create a relationship between any two tables in the relationship window, enforcing referential integrity and cascade deletes, it is created without any error messages. When I go back in, the two tables are there but the line showing the relationship is deleted. The tables then behave as...
  4. losthorizon

    How to display only a sampling of records for each group?

    There is only one group on the report. The group is: multiple / various types of insurance plans. For each plan type that the insurance company offers, of course, there are multiple detail records, based on policies sold (certificates). The boss only wants to view about 3 or 4 records (a very...
  5. losthorizon

    If 'convert null to default' isn't set, what can go wrong?

    When using a Microsoft Access database, is there ever any reason why we should NOT set 'convert null to default' in Crystal Reports? What are all the possible problems that could arise by NOT setting the reporting options in Crystal to 'convert null to default?' (Our Access database presently...
  6. losthorizon

    Grand total count of a formula result required

    There are actually three distinct formulas (all very similar) that I am seeking a solution for (all in the same report): 'Formula 300' is: {DistinctCount ({MEMBER.MEMBERNUMBER}, {BASICMASTER.BRANCH}) / 300}. 'Formula 350' is: {DistinctCount ({MEMBER.MEMBERNUMBER}, {BASICMASTER.BRANCH}) / 350}...
  7. losthorizon

    Address Correction Dilemma

    We are working on an address correction report, to track down "lost" members, and to bring our records up to date. We are running into the following problems: Some entries in our {member.address} database have been corrected or changed multiple times, either because a member has...
  8. losthorizon

    Problems placing a subreport in a report header.

    When we re-run a Crystal Report containing a subreport, incorrect data appears. How reliable is it to place a subreport in a report header section? I've read elsewhere that it's unreliable to place a subreport in the report header section, but that's the way the report currently stands...

Part and Inventory Search

Back
Top