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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by losthorizon

  1. losthorizon

    Dynamic Crosstab - Are they possible?

    Thanks! I'll give that a look.
  2. losthorizon

    Database Conversion

    Be sure to read Windows Support on the Win Update site, especially if you are "running multiple versions of Access" on the same network, or machine. You'll find there are numerous "Whitepapers" on the subject.
  3. losthorizon

    Dynamic Crosstab - Are they possible?

    Crystal Reports, version 8.5 (dated now, but what I'm currently using) has a cross-tab wizard. However, I've only done tutorial / virtual learning stuff with it; & never really used it in an actual business / job situation. Crystal emphasizes how important their usage is, but we don't use them...
  4. losthorizon

    Creating Help Systems

    Do a Google search on 'FastHelp' which formerly was known as 'DotHelp.' It utilizes 'Microsoft's Help Workshop' to build 'help text' that can be tied-in to the 'F1' key function with some basic Visual Basic programming techniques. You may use 'Paint' to create your 16 bit .bmp graphic...
  5. 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...
  6. losthorizon

    relationship deleted - how did that happen?

    At first, we thought our problem was a "relationship" problem, but that now seems okay, after doing some more checking. We were having a problem with #deleted showing up in bound controls, though we didn't have this problem with Access 97, using the exact same code. (The code does, in fact...
  7. losthorizon

    relationship deleted - how did that happen?

    I should add that everything was working okay when we were using 'Access 97,' but this has only happened since we converted it over, into an 'Access 2000' database. There are many linked tables in our (insurance-related) database!
  8. losthorizon

    relationship deleted - how did that happen?

    I'm still reading / searching the posts to see if anyone else has experienced this problem. Have found a couple of "deleted relationship" posts, so far, but I'm still looking for an answer.
  9. 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...
  10. 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...
  11. losthorizon

    Query question

    Interesting! (I have a boss that uses the &quot;<>&quot; symbols often in his formulas.)
  12. losthorizon

    Adjusting text objects without distorting them

    I just thought of something else. Go to: File > Options > the Layout Tab > the section called &quot;Grid Options.&quot; Uncheck the &quot;Snap to grid&quot; checkbox. This will also make your formatting work easier.
  13. losthorizon

    More Date Problems

    Here's what's in the Help file: Action: CDate (number) converts and returns a Date given a number which is the number of days starting from December 30, 1899. CDate (string) converts and returns a Date given a string. CDate (dateTime) converts and returns a Date given a DateTime value. CDate...
  14. losthorizon

    UK format dates in Crystal 9

    The person viewing the report may have to adjust their &quot;Windows&quot; settings? Settings > Control Panel needs to be adjusted on the viewer's machine , perhaps? Not really certain about this, but we had a similar problem here just weeks ago...this technique fixed it!

Part and Inventory Search

Back
Top