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

    display member

    strCode = "RR" Me.ComboEvent.DisplayMember = strCode Where strCode is in the combo. Why is this value not being displayed in my combo box?
  2. VICKEL1

    format issue

    I have a string "01/12/2006" and i need to format it to dd-mmm-yyyy (01-Dec-2006).
  3. VICKEL1

    dbisnull

    I am receiveing an error on this line of my code, If Not IsDBNull(CStr(rs.Fields("a_date").Value)) Then .Items(i).SubItems.Add(CStr(rs.Fields("a_date").Value)) End If Any ideas?
  4. VICKEL1

    Connecting to Oracle

    I am connecting to an Oracle database using a connebction string. However, I am getting the error Run time error '-2147217871 (80040e31)' [Oracle][ODBC][Ora]ORA-01013: user requested cancel of current operation. My connection string is Set con = CreateObject("ADODB.Connection") Set rs =...
  5. VICKEL1

    DB variable Name

    I have a 3 part DB naming convention such as DB1.dbo.client Is there any way to make the first part into a variable such as; DECLARE @DB as varchar(20) SET @DB = 'DB1' SELECT * FROM @DB + '.dbo.client' Any help would be appreciated
  6. VICKEL1

    SQL with Excel

    I have created an ADODB connection to a sql server 2000 database. However, when I use the copyfromrecordset command I don't get all the data back. The field which the command doesn't like is a field declared as text with a length of 16. Is there any other way I could get the data?

Part and Inventory Search

Back
Top