Search results for query: *

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

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

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

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

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

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, Is there any possibility to handle mousedown event in excel cells or is it only for userforms? Pekka "every dog will have his day"

Hi, I would like to avoid using check boxes in my worksheet. I wonder if it's possible to 'mark' selected cell. I mean if I select cell A1 it's value would be 'X'. I mean something pseudo like if range selected = True then range.value='X' Pekka "every dog will have his day"

Hi there, I wonder if it's possible to create after update event for cell in Excel. What I mean is: if I enter something in cell A1 after that cursor goes to cell D4 and so on. Best regards

Hi, I have excel workbook with 3 user forms. Usually forms work as they should but if I leave the workbook open and then try to open form I get the error: Out of memory run-time error 7. Does anybody have any hint how can I avoid this memory lack?

Hi, can anybody advise what has gone with my IE. 6.0 Win Xp. I can get the connection rigt and go to most url's. When I try to go to for example Windows update the page won't load insteed I get the message that my security setting are to high. I have try to modify the settings but no help. It...

Hi, does anyone know how to convert character field to numeric in db2 udb. My problem is the thousand separator period(.) I can use translate function to get rid off the period but it doesn't help much.

Hi, I wonder what's wrong in my Jet. If I'm in the design view and switch to sql view and try to switch back to design view I get the message: "Access can't run the macro or callback function fDesign" ?

Hi, I'm trying to play with free format select statement. I can't find out what I'm missing here: /Free Select Case Zter ; ==> aaaa 5507 30 a 001039 A semi-colon is not specified at the end of a free-form specification. When '8' ; Then ...

Hi, I have a following expression in my query: Kausi:LTrim(Left(Str([LIBL39_EMLCHIS5]![IVDAT8]);7)) when I try to execute the query I get the following error message:Function isn't available in expression in query expression. If I look at the function list in expr. builder I can see them all...

Hi, I have a two column report. I've tried to find the property to set column headings for the both columns. Part no Description 1111111 Filter 2222222 Pump I would like to have Part no Description Part no Description 1111111 Filter 2222222 Pump I can get the columns right but...