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!

  • Congratulations SkipVought 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: jwillard
  • Order by date
  1. jwillard

    Modify Text Issue

    GOT IT!!!!! Thanks so much to you all..... [2thumbsup] Boycott Sony
  2. jwillard

    Modify Text Issue

    Im very close. If I put a 1 in a cell by itself and then drag down to fill cells below, how can I make it count 1 2 3 and so on instead of it just putting a 1 in all the cells. Hope i explained what I want there clearly... Boycott Sony
  3. jwillard

    Modify Text Issue

    The only one thats not a constant would be the number 1 in the beginning. That would need to count by 1 as I go down the sheet. Bluedragon and anotherhiggins - Both seem to work except for my failing to mention the above variable about the first column counting. Thanks again for all the...
  4. jwillard

    Modify Text Issue

    Thanks for the quick replies. Yes it is Excel I am using. Tony, The first one always shows the formula and not the results. The second one does not put the double quotes around the info. This is what I got with the 2nd one chrysler plymouth,103aca,,,,,,,,,,,,,,,$0.00,,,0 Very close all I...
  5. jwillard

    Modify Text Issue

    I am trying to modify 2 fields (Customer name, customer number) that are shown below and add some text also. AUTO SALON FIN363 I need the output to look like 1,,"auto salon","fin363",,,,,,,,,,,,,,,$0.00,,,0 Note that the numbers, quotes, and commas must all be added. I have tried using...
  6. jwillard

    Opening 2005 Data in SQL2000

    Thanks for the replies. I will try over the next couple of days.... Boycott Sony
  7. jwillard

    Books For Beginners

    Thanks for the replies. I did look at FAQ183-3324 but noticed that all or most seem to be SQL2000 and the post itself is from 2003. With 2005 having been out for a while now, I thought they may be more updated books. Boycott Sony
  8. jwillard

    Books For Beginners

    Can anyone recommend any good books for someone looking to learn SQL. Thanks, Boycott Sony
  9. jwillard

    Opening 2005 Data in SQL2000

    Does anyone know of a way this can be done? We have a remote server with 2005 but I only have 2000 locally and I want to work on the data locally...... Boycott Sony
  10. jwillard

    Excel - Sort Part Nmubers

    AnotherHiggins, If you have time to answer, I am curious.... I just used the formula that you gave me again - =Text(A1,"@") - and I was wondering how does the @ sign do this. I see no reference to the @ sign in the Excel help files. Also what exactly is the @ sign doing? Is it just inserting...
  11. jwillard

    Registry Edit with Batch

    Nice thought Linney. thanks Boycott Sony
  12. jwillard

    Registry Edit with Batch

    Well I actually meant a .reg file that I could keep on my desktop to clear that value when I wanted. For anyone else who may want to know it goes like this. Windows Registry Editor Version 5.00 [HKEY_CURRENT_USER\something\something\something\IsoDoc] "VolumeLabelISOTemplate"="" Thanks for...
  13. jwillard

    Registry Edit with Batch

    Is it possible to edit an individual string value in the registry with a batch file? If so how do I do it. Any help is greatly appreciated.... Example: NAME TYPE_SZ data VolumeLabelISOTemplate Reg ThisNeedsToBEChanged NAME TYPE_SZ data...
  14. jwillard

    Excel - Sort Part Nmubers

    Thank you AnotherHiggins. Your option 1 worked great. Appreciated the help from everyone. Boycott Sony
  15. jwillard

    Excel - Sort Part Nmubers

    Thats a good idea but that leads me too, how do I pull everything from the dash over to another column. Excuse my ignorance but im kind of a newby to formulas. Boycott Sony
  16. jwillard

    Excel - Sort Part Nmubers

    I need to sort Part numbers with mixed numbers and text. Any help would be greatly appreciated. Currently the data sorts as follows 200 203 205 207 310 315 330 336 340 345 350 225-2T 250-2T 260-2T 270-2T 275-2T 300-2T 305-2T 306-2T 310-2T Needed Result: 200 203 205 207 225-2T 250-2T 260-2T...
  17. jwillard

    Word 2003

    You can try this and see if it helps... 1. On the Tools menu, click Options, and then click the Print tab. 2. Click to select the Background colors and images check box, and then click OK. Boycott Sony
  18. jwillard

    Backup Job Edit Problem

    I have been in touch with CA support. they had me delete the database and add an empty one. So far all is good. I have been able to edit jobs. Thank for the help Boycott Sony
  19. jwillard

    Backup Job Edit Problem

    I did install the service pack. It made no difference. Boycott Sony
  20. jwillard

    Backup Job Edit Problem

    PAPushka, I did try your solution. No Help.... VSChumpy, I am running Windows Server 2003. It is fully patched to date and IE is also fully patched. Win - SP1 IE - 6.0.3790.1830 It was working fine for a long time before. I think the last patch tuesdays updates may have caused this because...

Part and Inventory Search

Back
Top