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

  • Users: jcf27
  • Order by date
  1. jcf27

    using a laptop drive as external in another laptop

    Never mind.... I did a little bit of research and found a work around. Sorry for the trouble. regards, J
  2. jcf27

    using a laptop drive as external in another laptop

    People, thank you so much for your advice. I removed the HHD and put in and external case. I was able to retrieve 99.99% of the data using another laptop. The HDD had a lot of errors. I ran chkdsk to recover some of the data. My next questions is -- When I try to access the remaining...
  3. jcf27

    using a laptop drive as external in another laptop

    I am in need to retrieve some data from a dead Toshiba Satellite laptop. Is there an adaptor(s) of some sort I could use to connect the Satellite's hard drive as external drive into another laptop via USB? Thanks in advance. J
  4. jcf27

    Reading autofiletered data

    Gavin, Thanks for the reply. For some reason it did not work. It returned 1; where in actually, after the filter is selected, there are 200 lines or so. Here is part of my original code (I have 2 active sheets). SheetARows = SheetA.UsedRange.Rows.Count For Sheet_A_Row = 2 To SheetARows...
  5. jcf27

    Reading autofiletered data

    I wrote some basic code to process data from a simple spreadsheet of 3 columns. So far, no problems. The user incorporated an autofiler. How do I make the code recognize only the auto filtered data as opposed to the whole sheet? For example -- TOTRows = SheetA.UsedRange.Rows.Count still...
  6. jcf27

    powerpoint - tile master question

    Greetings, For some reason the title master in a presentation does not show up in show mode. I remember having the same problem a year ago and was able to fix it. Any help is greatly appreciated. Thanks in advance! J.
  7. jcf27

    Searching for a particular column in a db - Q?

    Greetings, I need some help searching for column names. I'm working with a 500+ table db. How do I go about finding in which table(s) a particular column appears? For example: list all the tables that contain column "first_name". Thanks in advance! J
  8. jcf27

    video display problem

    Martin, Thanks for the help. I tried different display settings and not much changed. The max refresh rate is 60hz for the display. I also have the latest drivers. Jorge
  9. jcf27

    video display problem

    I just got a vaio grz660 laptop from work and found something peculiar with its video diaplay. Some of the fonts appear to be fuzzy. For example, the threads headings look fuzzy, like if it were missing some pixels, or like if they were bleeding. This happens in just about all applications...
  10. jcf27

    conditional select

    I need help in building a conditional select (nested?) based on different cells values. For example: Table A Item Date Description 123 12/31/02 small widget 345 12/31/02 small widget 333 12/31/02 big widget 444 10/10/03 small widget 555 10/11/03 big widget 666 02/02/03 big widget I...
  11. jcf27

    ratio math calc in sql

    All, Thank you so much for the input provided. It was very valuable. Because of the complexity of the problem and time constraints, our team leaders are thinking of transforming the data programmatically. Thank you, once again. J.
  12. jcf27

    ratio math calc in sql

    Zathras, Thanks for the reply. Unfortunately, the input could be any number. There is no way to anticipate values.
  13. jcf27

    ratio math calc in sql

    I ned to transalte a real number into ratios. For example: .66667 = 2/3; 1.5 = 3/2; .8 = 4/5, and so on... The input I ge is the real numner .66667. In this case I need the 2 and the 3. Is this possible in sql? Many thanks in advance. J.
  14. jcf27

    column self-update query question

    I need help in writing a query that will self-update a column. For example: Column A contains 'ABC.myname'. 'ABC.' is a constant and appears in certain records. How could I easily get rid of it? I tried doing a self-update doing a substring, however, I failed somewhere in the self-join...
  15. jcf27

    update query selection criteria

    The following update query runs OK, except that it clears out fields corresponding to rows not meeting the criteria. How can I make it update only the selected rows and leave others as they are? Thanks in advance. J. update address fa set address = (select psc.value FROM sec_code p WHERE...
  16. jcf27

    select key value pairs into a single row.

    I need help trying to convert key value pairs into a single row. For example -- Table A id code value 1 A 30 1 C 20 1 H 10 2 B 5 2 C 10 and so on... How can I easily create a select that could convert the key-value pair...
  17. jcf27

    counting number of non-blank cells

    Just what I needed. Worked great! Thank you! J.
  18. jcf27

    counting number of non-blank cells

    It works for blanks, how about counting non-blanks? Thanks! J.
  19. jcf27

    counting number of non-blank cells

    Newbie question -- What is the proper syntax in excel to count the number of non-blank cells in a range (A1:A1000) ? The cells may contain anything. Thanks in advance! J.
  20. jcf27

    MAX value in subsidiary table question

    I have the following two tables -- Table A Apkid, name, transaction (distinct records) Table B Bpkid, Bdate, Bvalue Table B gets a new record every day. For example 1,10/01/02, 3 1,10/02/02, 5 1,10/03/03, 7 Apkid and Bpkid are the same. The objective is to create a select statement...

Part and Inventory Search

Back
Top