Recent content by mathon

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

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...

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...

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?

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...

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...

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

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...

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? :-/

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? :(

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...

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

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

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

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...