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 strongm 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. StephenSB

    Counting an NthMostFrequent Field

    Is it possible to count the number of occurrences of the most frequent field? I have a product description which I have the most frequent description for, but I also need to know how many times the description has been found. I have tried to do a conditional count but get an answer of 0 every...
  2. StephenSB

    Error with Database Dll on Sub Report

    Hi. I am currently writing a crystal report in 8.5 which uses 2 sub reports. However when trying to run the report I am getting two error messages: ODBC error: [Microsoft][ODBC SQL Server Driver] Connection is busy with results for another hstmt Then Error with Database dll It happens only...
  3. StephenSB

    Rights on login

    That's great! Thanks for your help. It turned out to be a rights problem and is now running fine :)
  4. StephenSB

    Rights on login

    I will give that a go. The drive mapping does use the MAP ROOT command.
  5. StephenSB

    Rights on login

    I am attempting to launch an application which performs a scan of a PC when a user logs in. I have mapped a drive where the application resides with a directory within it that is used to store the data collected from the PC scans. I seem to be encountering a problem when trying to save the...
  6. StephenSB

    Hours and Minutes from a DateTime field

    Hi, I am trying to get the Hours and minutes elapsed from two datetime fields (both in the format DD/MM/YYYY HH:MM:SS)They both have hours and minutes as well as the date. I have tried using the DateDiff formula but I could only get hours or minutes. Is there any way I can get both?
  7. StephenSB

    SQL Script Installation under WISE

    Hi, I have developed an application which uses SQL Server. In order to create the relevant databases and stored procedures I am relying on Scripts. At the moment I am having to run these separately to the installation through OSQL. Is there a way to integrate the scripts into the Installation...

Part and Inventory Search

Back
Top