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 Rhinorhino 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: *

  1. SashaBuilder3

    select a single row based on conditions in multiple rows

    Hi George, Yes, they both work. The second is a straightforward and the first I modified so it became a base query from which I can extract a desired result: select i_spID FROM (select i_spID, max(case When t_property = 'nmb_legs' Then i_property_val End) As nmb_legs...
  2. SashaBuilder3

    select a single row based on conditions in multiple rows

    Hello dear SQL experts, I am working on a project related to arthropod species identification. Here is a simplified table where we list various arthropod species with their properties: i_spID t_property t_species i_property_val 1 nmb_legs Blatta germanica 6 1 nmb_wings Blatta germanica...
  3. SashaBuilder3

    import CSV file into MySql table in PhpMyAdmin

    Hello there! I am trying to import some data from a CSV file into an existing table in MySql database using phpMyAdmin. I’ve created and saved a CSV file GU_t_rf_imgTp.csv, here it is: Now in phpMyAdmin I do: first, I choose the table which to fill (in this case “GU_t_rf_img_type”). Then I...
  4. SashaBuilder3

    left join with "soft" condition

    Hi JarlH, Thanks for the solution. I need it for SAS (they have their SQL facility) and I will think how to adopt the statement for it. Thanks again! Alex
  5. SashaBuilder3

    left join with "soft" condition

    Hello everybody, I need to join two tables.The first table has the patient ID and dates of some test. t1 ID Dt1 1 05-jan-2010 1 14-mar-2011 2 02-feb-2009 2 17-jan-2010 The second has dates of some other test with a few additional parameters. t2 ID Dt2 Param1 Param2 1...
  6. SashaBuilder3

    In code in Access, copy and paste an entire table

    Probably you can do somethinbg like this: Dim str_SQL As String DoCmd.SetWarnings False str_SQL = "select * into tbl_new from tbl_old;" DoCmd.RunSQL (str_SQL) str_SQL = "Drop table tbl_old;" DoCmd.RunSQL (str_SQL) DoCmd.Rename "tbl_tmp_old", acTable, "tbl_new"...
  7. SashaBuilder3

    Excel 2002: generates values in cells by itself...Virus?

    Hi Everybody, I have the Office 2002 (Win.XP). A strange thing is happening today in Excel and Word. When I work in a workbook or in a word document some words appear by itself, especially if I don't hit keys for a while. Not just a set of unrelated characters but real words, ex. 'The', 'and'...
  8. SashaBuilder3

    program works inside Borland-C++ Builder3 but doesn't separately

    Hi 2ffat, You are right, I need to ouput a detailed log file to see what's going on. Thanks anyway! Alex
  9. SashaBuilder3

    program works inside Borland-C++ Builder3 but doesn't separately

    It's Windows 2000. Well, the program is supposed to search a certain string in the files in a certain folder. It's similar to the standard Windows search facility. So if the string is found the name of the file gets written in the result text file. When I run the program from within Borland...
  10. SashaBuilder3

    program works inside Borland-C++ Builder3 but doesn't separately

    Hi 2ffat, Thanks for the tips. I tried to run the tdump, it indicated two files: KERNEL32.dll and USER32.dll. Now what? -- I added the files to the project (not sure this was what I needed), re-made the project but this didn't help. I also made sure the 'Use dynamic RTL' in the Linker pane...
  11. SashaBuilder3

    program works inside Borland-C++ Builder3 but doesn't separately

    Hi everybody! I've written a simple console application in Borland-C++Builder-3. It works fine from inside the Borland environment, but when I try to run it separately it gives me a weird result... Any clue? Thanks, Alexandre
  12. SashaBuilder3

    subform doesn't get renewed after its query is rebuilt

    Hi TheAceMan1, Thanks for answering. The statement didn't work either, but that was my fault not posting the code. However you gave me an idea to check on RecordSource and the following line works just fine: Me.frm_result.Form.RecordSource = strSQL Another thing is that I don't have to create...
  13. SashaBuilder3

    subform doesn't get renewed after its query is rebuilt

    Hi everybody, Here is what I have. My simple db contains just one table. I've created a form with a subform. The subform is based on a SELECT query and simply shows the table contents. The main form has a few combo boxes from which a user can choose select criteria to filter data rows for the...
  14. SashaBuilder3

    new Access doesn't recognize ADODB.Recordset statement

    PH, Thanks a lot! Alex
  15. SashaBuilder3

    new Access doesn't recognize ADODB.Recordset statement

    Hi everyone, Here is a problem. I've started using a newly installed Office-2000 and my Access VBA gives me error messages if I try to use ADO components, for example, such a message comes for the following declaration line: Dim rs As New ADODB.Recordset It tells that this is a user defined...
  16. SashaBuilder3

    How to run a simple 'Hello World' application in Eclipse?

    Thanks a lot, Immo! Alex
  17. SashaBuilder3

    VBA: how to asign a value from a table to a variable

    Billpower, Beetee, Thanks for your help. I knew about the recordset way but it seemed to me a bit cumbersome to get just one value from a table. And I suspected there should have been another way. This DLookup function looks like what I was after. Thanks a lot again! Alexandre
  18. SashaBuilder3

    VBA: how to asign a value from a table to a variable

    Hi everybody, I am wondering if there is a way to get a value from a table via SELECT statement and assign it to a variable in a VBA sub. For example, in Oracle it is possible to do the following: SELECT SomeField INTO VarName WHERE... Can anyone help with something similar for Access VBA...
  19. SashaBuilder3

    How to make an image transparent?

    Thanks JackMH! I'll try this Alexandre
  20. SashaBuilder3

    How to make an image transparent?

    Hi everybody, I need to build a complex chart, for this I want at first to create some painted area and then to put a map over it. The map is an image, which consists basically of black lines for state borders, main rivers and lakes on the white background. What I need is to put just these...

Part and Inventory Search

Back
Top