Search results for query: *

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

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

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

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

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

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.

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

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

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

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

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.

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

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.

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

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

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

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

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

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.

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