Search results for query: *

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

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

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

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

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

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