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

    DATE COLUMN

    I am connecting to Oracle through MS QUERY. The result is put into excel. Set Query = QuerySheet.QueryTables("MONEY") Query.Sql = "SELECT NUMB_TBLE.NUMB_NAME, TO_CHAR(NUMB_DATES_TBLE.DAY_MTH_YR, 'MONTH'), SUM(NUMB_TBLE.NUMB_PAY) " _ & "FROM JES.NUMB TBLE NUMB TBLE, JES.NUMB_DATES_TBLE...
  2. gencom99

    Column alias

    I would like to put column aliases on some of the fields in the SELECT statement. Private Sub CommandButton1_Click() Dim NumList As String Dim SourceBook As Workbook Dim ListSheet As Worksheet Dim QuerySheet As Worksheet Dim Query As QueryTable Dim Numb As String Set SourceBook =...
  3. gencom99

    Run-Time Error '1004' General ODBC Error

    Private Sub CommandButton1_Click() Dim NumList As String Dim SourceBook As Workbook Dim ListSheet As Worksheet Dim QuerySheet As Worksheet Dim Query As QueryTable Dim Numb As String Set SourceBook = Application.ActiveWorkbook Set ListSheet = SourceBook.Worksheets("Main") Set QuerySheet =...
  4. gencom99

    Run-Time Error '9' Subscript out of range

    I am using a spreadsheet. It has two tabs MAIN and TOTAL CASH. On the MAIN tab is a BUTTON and a cell where to enter a number. After you put a number in the cell and click the button, the results of the query is in the tab TOTAL CASH Private Sub CommandButton1_Click() Dim NumList As String Dim...

Part and Inventory Search

Back
Top