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: *

  • Users: btrini
  • Content: Threads
  • Order by date
  1. btrini

    Error 3544: Partial string matching requires character operands

    Hey guys, I run the below code and get the error "3544: Partial string matching requires character operands" Not sure why since both fields are character fields. I tried to Cast to ensure they are character. Any help would be appreciated. Select * From BA_HARD_HOLD BA Left Join...
  2. btrini

    Fastload logon shows as invalid but I can log on to Teradata SQL Assistant with the same credentials

    Hi, I built a SQL script which I am calling at the Fastload DOS prompt however I am getting an error message that my UserID, Password or Account is Invalid. I am using the same User Id and Password I use to logon on to Teradata SQL Assistant. Is there another setting I need to change to get...
  3. btrini

    VB - Excel formula problem

    Hi all, I am having a problem with the following Excel formula:WS_2.Range("BJ" & CStr(Temp_Cell)).FormulaArray = "=SUM((DATE(YEAR('SOURCE TM DATA'!$AJ$2:$AJ$" & LastRow & " ),MONTH('SOURCE TM DATA'!$AJ$2:$AJ$" & LastRow & " ),1)<=DATEVALUE(""1/""&LEFT(L" & CStr(Temp_Cell) &...
  4. btrini

    Find record based on Combo box selection after open with where clause

    Hi all, I have a Review form that has a sub-form which lists all observations made for that particular review. I have a "VIEW" option for each record in the subform that allows you to open the Observation form and view or modify the selected observation. The "VIEW" option opens the observation...
  5. btrini

    base query on optional criteria entered in a form

    I have a form on which the user can select any one or combination of criteria. Based on the combination entered, I would like to query my table. I am thinking this can be done in code by using if...then..else. However I am having difficulty writing an AND clause. Can someone tell me if this...

Part and Inventory Search

Back
Top