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 Chriss Miller 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. TheOneRing

    Samba Server Authentication from Win2000 Server

    I am having trouble getting smb_auth to work. I have setup the Samba Server and I can see if from the Windows 2000 box etc, I just installed smb_auth, but when I run >smb_auth -W BONVILLE and then type in the username and password (with a space), I get ERR. I can ping the Windows 2000 box...
  2. TheOneRing

    Data Environments in VB6

    I have a data environment in VB6 which is grouped by a certain field and then a datareport linked to this. If I put in the default SQL statement and run the datareport it works fine, but if I go to update the source of the data environment with exactly the same SQL, then it says that it cannot...
  3. TheOneRing

    Sorting on Aggregate Functions

    Gedday, I have the following SQL Statement: SELECT tblCustomers.CompanyName AS Company, tblCustomers.CustomerID AS CustomerID, tblCustomers.TypeofCustomer, Count(*) AS Numcalls, Sum(tblInvoice.dblSubTotal) AS TotalDollars FROM tblCustomers INNER JOIN tblInvoice ON (tblCustomers.CustomerID =...
  4. TheOneRing

    Data Report and Data Environments is VB6 Enterprise

    I am having a problem with writing a datareport. I have the following SQL Statement in a dataenvironment SELECT tblServiceEquipment.strSerialNumber, tblCustomers.CompanyName, tblServiceTask.strServiceTaskNumber, tblServiceTask.dtmServiceTaskCreatedDate, tblServiceTask.dtmServiceTaskEndDate...
  5. TheOneRing

    Changing Label contents in DataReports

    I have a data report that has two label boxes in the page header section of the datareport. I want to change the contents of this at run time. Does anyone know how to do this?
  6. TheOneRing

    Accessing Data using the DataCombo box

    Gedday, I have a datacombo box that is filled with customer names from a dataenvironment command. What I want to know is there any eay way to retrieve the relevant data from this control without have to search the whole table to find the match. i.e. I select say John Smith in the list. Now I...
  7. TheOneRing

    Eliminating Duplicates in SQL Query

    I have two tables. tblServiceTask and tblServiceTaskTech tblServiceTask holds the billed labour etc for each task and tblServiceTaskTech holds all the times for each technician that worked on a particular task. Now if I do a query joining these tables together, then I can get duplicate values...
  8. TheOneRing

    Using Aggregate function in data environments in VB6 with SQL

    I have a database that has a number of tables in it. tblServiceRequest - requests for service (custid etc) tblServiceRequestType - service request names(eg: WORKSHOP) tblServiceTask - the tasks for each request (ie. PCREPAIR) tblServiceTaskType - info for each task (i. labour hrs etc)...

Part and Inventory Search

Back
Top