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

    String Extract

    Crystal XI, SQL2000 30 Char String field (CODELIST), they contains several 2 char codes, with no seperator values. Need to get the 2 char code and lookup the Text value. Rec 1: AABBCCDDEE Rec 2: AACCDD Rec 3: Blank or null "AA" = Part 01 "BB" = Part 02 "CC" = Part 03 etc... Result should look...
  2. maccrystal

    Merging two Databases

    Has anyone used the Export\XML and Import\XML functions in Goldmine 6.7 to combine a standalone (single user)Dbase version into a SQL version 6.7. The XML set would be "Appended" to the SQL Contact set. Dbase The Dbase version has the usual contacts, activities, Sales forecast. Both copies of...
  3. maccrystal

    Manual Crosstab Print Month Headings

    Crystal 8.5 MS SQL2000, Manual Crosstab Report with Starting and Ending Date parameter. Report Format: Jan..Feb..Mar........Sep...Oct..Nov..Dec. For a Date Range of 9/1/06 to 8/31/07 Need to print the mm/yy above the Months as Below: 01/07.02/07.03/07......09/06.10/06.11/06.12/06...
  4. maccrystal

    SERVER PSQL 8.5 Move

    is there a way to move (Export) the PCC Database settings for an old server on Windows 2k to a new server Win 2003 without rekeying them. The Old server has about 30 DB's defined. www.appstratinc.com
  5. maccrystal

    SQL errors out on date functions

    Version 6.7 Dbase: SQL querys that use date function returns error. If you remove the Date(), Date()-30 or getdate() and sub "01/01/2006" the query works. Invalid use of keyword. Context: SQLQuery: select company, contact, lastconton, lastuser,contact1.ACCOUNTNO from contact1, contact2...
  6. maccrystal

    Addsoft Scheduling Control

    Does anyone has a suggestion for a replacement for AddSoft Scheduling Control. www.appstratinc.com
  7. maccrystal

    Peak Best of OE to 7.6.300

    Has anyone converted a site running Peaks Best of OE enhancements to 7.6.300. If so any issues, key differences or observations? www.appstratinc.com
  8. maccrystal

    Flex VBAConnect.init

    Has anyone encountered an error meesage from VBACOnnect.init "Too Many Files Open". This message occurs randomly. 7.6.100spa. Will effect one station and cascade through the other that use the Flex modified OE. www.appstratinc.com
  9. maccrystal

    Print Drawings From VB App

    What is the simplist method to print a single or group of autocad drawings from within a VB application. The application can read an item file that contains the drawing name. The user would like to select the group of items and print the respective drawing sheets.

Part and Inventory Search

Back
Top