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

  1. mathon

    Insert Data in Access via VBA

    Hi, thank you very much for you answer. Yes I want to add a record in my table. the thing is i want to use Recordset.AddNew.Fields It should be possible with this statement or?? matti
  2. mathon

    Insert Data in Access via VBA

    Hello, i try to write some data via VBA-Excel-Module in an Access-DB. Unfortunately is there an error in my VBA code and im not able to fix it.:(( My method looks as follows: Private Sub CommandButton2_Click() Dim DBFullName As String Dim Cnct As String, Src As String Dim...
  3. mathon

    ADO and EXCEL

    Hi, I want to understand the code of the following example http://www.online-excel.de/excel/singsel_vba.php?f=137 I have a worksheet with the follwing table starting at A1: Monat Wert Januar 1 Februar 2 März 3 Januar 4 Februar 5 März 6 Januar 7 Februar 8 März 9 Januar 10 Februar...
  4. mathon

    SQL Query for DB2 with group by

    hmm...when I this query the AQT is processing the query and does not stop, but the table has not so many entries that it will process with no end...is something wrong with the query?
  5. mathon

    SQL Query for DB2 with group by

    Unfortunately not, because when I use this query there are still displayed more rows per number in Col.2. But I would like to have one row per number in Col.2 and it should be this row where there is the minimum in Col.1. So for the first number 03869723 it should be the row with the number...
  6. mathon

    SQL Query for DB2 with group by

    hi, I have the following table Col.1 Col.2 Col.3 5032 03869723 228.25 5033 03869723 228.25 5034 03869723 178.55 5035 03869723 49.7 5036 03869723 6 5037 03869723 104.75 5038 03869723 43.7 5039 03869723 67.8 5040 03869723 6 1 03870085 136.19 7 03870085 136.19 125 03870085 47.62 127...
  7. mathon

    SQL Query to check numbers

    I actually dont really know how to define this sql statement, could you help me with that? :-/
  8. mathon

    SQL Query to check numbers

    Hi, I have a table called TableA, this table has columsn Column1, Column2, Column3 and Column4. Column3 contains 8-digit numbers saved as text. Now I want to check if a certain amount of numbers is already in the table. I guess I have to use the keyword IN and the numbers I want to check...
  9. mathon

    Export data from word file in an excel with a macro

    the problem is that i cannot load the word document in an excel sheet, it does not work with Data - Import External Data - Import Data because in that case I would have to to choose a data source. how can I load the word document in excel? :-/
  10. mathon

    Export data from word file in an excel with a macro

    unfortunately it does not work with the import external data. the word file is generated from a document generator which i use in another program. is there not the possibility to write an easy macro to import the corresponding word data to an excel sheet? :(
  11. mathon

    Export data from word file in an excel with a macro

    Hi, I have word file with many data groups which look for example like this: Test Name: Test User Interface Linked Defects: Defect ID LinkedEntityID Defect:Summary 414 1019 Button is too small Test Name: Test Performance Linked Defects: DefectID...
  12. mathon

    Count areas of numbers

    Is this not possible with functions? because the values can change.
  13. mathon

    Count areas of numbers

    Is that possible? with count and then write the correponding number only once in the other column or something like that? I appreciate every tipp. Regards matti
  14. mathon

    Count areas of numbers

    Hi, I have an excel-sheet with the following column of numbers 25 25 25 25 25 25 26 26 26 26 26 26 26 27 27 27 27 27 27 27 28 28 28 28 28 28 28 29 29 29 29 29 29 29 30 30 30 30 30 30 30 31 31 And I want to get the following column from the above column: 25 26 27 28 29 30 31
  15. mathon

    Calculations with IF and lookup

    Sorry but i cannot see a source structure that you have postet. Please dont get angry because I am not the best excel programmer. I used the Format - Cells - General then all dates become numbers i checked that. But the date formular you posted earlier doesnt work either... :( could you maybe...
  16. mathon

    Calculations with IF and lookup

    The sourcedata are hours each member has worked at day. you can change the structure if you can calculate the things easier then..?
  17. mathon

    Calculations with IF and lookup

    Im sorry, its difficult to poste source data because the formatting is destroyed after submitting the posting. okay I have the following source data: CW Datum Mem 1 Mem 2 Mem 3 Mem 4 25 19.06.2007 10 20 30 40 25 20.06.2007 20 30 40 50 25 21.06.2007 30 40 50 60 25 22.06.2007 10 50 60 70...
  18. mathon

    Calculations with IF and lookup

    oh sorry, maybe I thought in the wrong way, the dates in the column are calculated like that: A 1 01.05.2007 2 = A1+1 3 = A2+1 4 etc. 5 6 7 Is it also possible to calculate the Periodstart and Enddate? Regards matti
  19. mathon

    Calculations with IF and lookup

    No these are all real dates, so that could not be a problem. You have ideas how I can implement that? matti
  20. mathon

    Calculations with IF and lookup

    Hi, Yes sorry, the source data looks like this: DateColumn MemberColumn HoursColumn And in the DateColumns are quoted days as Date and what I wanted to do first is calculate two tables next to this source table. 1. Table: First which calculates all periods in a year in two columns (first...

Part and Inventory Search

Back
Top