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 IamaSherpa 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. turtledisc

    Change military time to standard time

    How are the times displayed? Does it show 1845 for 6:45pm? Could you post some sample data and what version of crystal reports you're running? Jacquie Kelly
  2. turtledisc

    Change military time to standard time

    Is the field itself a datetime or time field? If so, you can change the format by right-clicking on the field and selecting "Format Field". Click on the "Time" tab and select the appropriate option from the list displayed. Jacquie Kelly
  3. turtledisc

    Show First Letter

    try left(field,1) Jacquie Kelly
  4. turtledisc

    Scheduled DTS task to import data from Informix 7.2 not working

    Just a quick update - it started working after the reboot of the server. Jacquie Kelly
  5. turtledisc

    Scheduled DTS task to import data from Informix 7.2 not working

    Hi Mutley1, I've checked all of the settings suggested in that link and as far as I can see it's all set up correctly. I'm thinking of rebooting the SQL Server server just to be on the safe side. Thanks, Jacquie Jacquie Kelly
  6. turtledisc

    Scheduled DTS task to import data from Informix 7.2 not working

    Hi, I've created a DTS package to import data into SQL server 2000 from Informix 7.2. I'm using the Informix Client SDK ODBC 2.81. The DTS task works when I run it manually but gets an "Unable to load translation dll" when it runs as a scheduled job. I've checked the INFORMIXDIR and it all...
  7. turtledisc

    Limiting Parameter Values

    Thanks lbass - that worked. Jacquie Kelly
  8. turtledisc

    Limiting Parameter Values

    I'm using Crystal Reports XI to connect to a SQL Server 2000 database. Table Name: Location Field Names: PrimaryName, Reportable, Active I'm trying to create a report that will allow a user to select the PrimaryName from a drop-down list that only shows PrimaryNames where Reportable and Active...

Part and Inventory Search

Back
Top