Search results for query: *

Thanks, jag tackar och pockar. Skål! Pekka "every dog will have his day

Hi, I have a following data forexample: Tp Tp_k Se_1 A10 B10 1 A10 B10 2 A20 B11 2 A20 B10 1 A20 B12 1 I would like to have those Tp values that have nothing else than Tp_k = B10 rows. In my example I would only accept Tp=A10. Pekka "every dog will have his day

I used "Analyze it with..." I noticed that in Excel 2002 you can open mdb from excel and with that memo fields returns as expected. Pekka "every dog will have his day

Hi; I'm trying to output my query to excel. Excel is cutting memo field to 255 characters. Is there any way to override that limit other than splitting the memo to pieces? Pekka "every dog will have his day

Thanks, I found another approach to solve the problem: first calculate the sequence number for each year/period group: (year-1900)*12+period as datex and to be compared it with current: (year(getdate()-1900)*12+Month(getdate() as curdatex Then something like Select case when datex=curdatex-1...

Hi, I'm trying to make a 12 months rolling total query. I have a table foe example: Period Year Total 1 2004 123 2 2004 144 3 2004 1244 . . 1 2003 111 2 2003 1222 I would like to it have for eample for august: Sum_of_august Sum_august-12_months Is there any other...

I managed to get my grouped options to work by editing the field properties in FrontPage. Pekka "every dog will have his day"

Ok, for functions I need VbScript. But what about the options buttons? Does they also need script? Because check box works nice without any scripting by my own. Pekka "every dog will have his day"

Hi, I'm usin Access 2002 and I'm trying to play with it's new feature, data access pages. I know nothing about scripting and other web stuff. I can designg the page quite similiar to forms, but I just can't get the options buttons work. In forms I can use e.x dlookup function for value but it...

Thanks. I would like to say that I've tried, but...That's it! Pekka "every dog will have his day"

Hi I want that my textbox's value change between two functions but I cant get it work. Private Sub Command0_Click() DocumentTables Me.Form.Refresh Me.Form.Repaint Pause 5 Me.Info.Value = "Tietoja paivitetaan! Malta nyt hetki...." Me.Info.Visible = True Pause 1...

Didn't I mean something following: SELECT fl.id, fl.Dest, fl.Orig, DLookUp("[Out]","fl","[ID] = " & [ID]+1) AS Out_next, fl.[In], (DLookUp("[Out]","fl","[ID] = " & [ID]+1))-[In] AS Time_on_ground FROM fl WHERE (((fl.Dest)=DLookUp("[Orig]","fl","[ID] = " & [ID]+1))); Pekka "every dog...

This example is from Microsoft's query samples: SELECT id,Dest, Orig AS next_row_orig FROM fl WHERE (((fl.Dest)=DLookUp("[Orig]","fl","[ID] = " & [ID]+1))); If I understood right this will give you some hint. Pekka "every dog will have his day"

Thanks Ken. I missed that it be can referred to subform with Form. Pekka "every dog will have his day"

Hi, i'm trying to change the form's subform's source object and populate the data by selected criteria. with this, i get the error message that the form cannot be found and it's and it even bring the form as subform with no recordsource. Forms!up_tulov_f.RecordSource = tiet2...

Hi, is there any way how I could higliht the variables in a string? I mean if I have: uniik = "Arvoja:" & " " & ListBox1 & " " & "loytyi " & vast & " " & "kpl" I would like it to brings ListBox1 and vast as bold formatted. Pekka "every dog will have his day"

Hi, without any possibility to check online helps, does anybody know the equivalent function in SQL server for and sql function: to_char? Pekka "every dog will have his day"

Hi, I've defined a subdatasheet view in query. How can I get it work also in a form based on that query? Pekka "every dog will have his day"

Hi, we have excel 2002 and it is localised version. So it's is in finnish also all the built-in function are translated. I have used the english verion for years. So, how can I use english functions in my finnish excel? Pekka "every dog will have his day"

Hi, in this access odbc example the file could be a nativive db2 table. 1. Create new access 'database' 2. in access. File->Get external data->link tables. in link dialog select types of files: Odbc drivers. (yep, you have to define it). Select yor dns. Select your table. The link is...