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!

Recent content by rrtraverse

  1. rrtraverse

    How do I change the decimal place for a fixed length numeric value

    Current field value coming from sql table is numeric (6,2). I am using this field in an interface to another application that requires fixed length numeric (7,3). Changing the strings to fixed length has been easy enough, but numbers - not so much. my formula is: if {table.colname} >= 1.0...
  2. rrtraverse

    Crystal Reports 8.5 Won't Export Sub Reports to Excel

    I have created a Crystal 8.5 report that pulls data from a sql view. My report contains a sub report and is set to run and export to Excel nightly, using Info Scheduler 7. My problem is that when the main report has no records, the export for this report shows no records, even though there are...
  3. rrtraverse

    Crystal Reports 8.5 Won't Export Sub Reports to Excel

    My Crystal report contains one sub report that exports correctly to Excel 7, but does not export the sub report at all when exporting to Excel 8. I have looked through the patches available for Crystal 8.5, but I see nothing that pertains to this issue. I guess I've missed something. Can...
  4. rrtraverse

    Access Report Page Breaks

    I went back and checked - Force New Page was in a group footer. Thanks for your help
  5. rrtraverse

    How Do I Get Rid of Page Breaks in This Report?

    I have inherited an Access report running in Access 2000, that is page breaking after each 'group'. I don't want these page breaks to happen and have checked the properties of the Page/Report/Group headers and footers to verify that each is set to "No" for "Keep Together", Force New Page is set...
  6. rrtraverse

    Access Report Page Breaks

    Force New Page was set to None. Anything else I can check?
  7. rrtraverse

    Access Report Page Breaks

    I have inherited an Access report running in Access 2000, that is page breaking after each 'group'. I don't want these page breaks to happen and have checked the properties of the Page/Report/Group headers and footers to verify that each is set to "No" for "Keep Together", and that is the extent...
  8. rrtraverse

    How do I export to a prn file format

    I need to be able to export my Crystal reports to a prn file format. Is there any way to do this?
  9. rrtraverse

    Microsoft Word can't hyphenate this document error

    End user with Windows 95 downloads Performance Review form with VB macros and receives the following error: Microsoft Word can't hyphenate this document. This feature is not currently installed. Other Windows 95 users have used this Performance Review form with no problem. Any idea what is...
  10. rrtraverse

    Spell Check on a Write Protected Word Template

    Thanks so much - I had no idea about the continuous break thing. I'll try that!
  11. rrtraverse

    Spellchecker for VBA Source

    Someone here just found the code for this - wanted to share with you...go to this linkhttp://word.mvps.org/FAQs/MacrosVBA/SpellcheckProtectDocContent.htm
  12. rrtraverse

    Spellchecker for VBA Source

    We are having the same problem. Does anyone have a solution? Thanks
  13. rrtraverse

    Spell Check on a Write Protected Word Template

    We created a Performance Appraisal template in Word that our managers will access from the company intranet. The managers will record their responses on the template. The template has been write protected to prevent changes to the template, but this prevents spell check of the manager...
  14. rrtraverse

    Multiple transaction records in one table

    I used synapsevampire's solution and everything works great now except if there is Repaid Date and not a Loan Added Date. I think I understand why this isn't quite working, but I don't know how to fix it. The group footer formula says if Repaid Date <> cdate(1950,1,1) then Repaid Date - Loan...
  15. rrtraverse

    Multiple transaction records in one table

    Using Crystal v.8.5 to connect to an SQL database through an ODBC connection. All transactions (actions) for a particular loan are stored in a table called Log, which is actually a history file. There are many transaction codes available for a loan, but I am only interested in the Loan Added...

Part and Inventory Search

Back
Top