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 wOOdy-Soft 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: mathon
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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
  7. mathon

    Calculations with IF and lookup

    Hello, maybe someone can help me here: A B C D Member 1 Member 2 Member 3 1 01.05.2007 No. of Hours No of Hours No of Hours 2 02.05.2007 .... .... 3 03.05.2007 4 04.05.2007 5 05.05.2007 6 06.05.2007 7 07.05.2007 8 08.05.2007 9 10.05.2007 10...
  8. mathon

    Consolidate Data from several Excel Files

    Hello I have several Excel-Files which contains among others the following information: A B C D E F 1 2 3 4 Name Project1 5 6 7 8 9 10 TimeDistribution Hours 11 0001 ProjecMember1...
  9. mathon

    Convert XML-File in PDF

    Hello, I want to convert an existing XML-File in PDF with the help of XSL:Fo. I already looked at the apache fo project but there in the examples section i only find examples for XSL:Fo files. Does anybody know where i can find a complete example - means an XML-File and a corresponding XSL:Fo...
    • mathon
    • Thread
    • Replies: 2
    • Forum: XML
  10. mathon

    exception handling_urgent help please

    I have written a testscript with an input-file where the control names, window names, etc. are quoted. Furthermore I have defined GUI-Maps and the parameter in the input file are defined according to the GUI-Maps. Now I want to add an exception handling if the test case could not be executed...

Part and Inventory Search

Back
Top