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

    Winamp works but system sounds do not

    This fixed it Go to start, run, type in services .msc; then scroll down down until you find windows audio. Right click windows audio and select properties, then look for where it says startup type, make sure that selection is set to automatic. Make sure you restart after doing this. This should...
  2. mars19301

    Winamp works but system sounds do not

    Thanks, Roland. No luck, but as we know, it's often a case of trial and failure with this stuff. I uninstalled winamp. I narrowed it down to an uninstall of Nero that zapped a drvmcdb file related to Roxio DLA. So I uninstalled Roxio and now have no functional sound whereas SOMAFM.COM used to...
  3. mars19301

    Winamp works but system sounds do not

    running XP3 and FF3 beta 2 on a DELL E310 (YES I've been following the recent similar thread) and lost my mail.wav, chimes, etc. The speaker icon in the system tray disappeared. Not sure if it happened when I upgraded XP or when I uninstalled some software which I do almost daily (trial and...
  4. mars19301

    Insert maiden name into fullname

    Thank you, XLBO, but I've never worked with code in Excel although I'm willing to learn. Can you point me to a resource? m
  5. mars19301

    Insert maiden name into fullname

    I am certain the insert will be in the last space. I'm only dealing with 500 names so I will manually adjust the very few exceptiosn. The suffix is in a separate column so I'll add that afterwards, but the cell formula is stumping me. Ideas? Thank you for your help.
  6. mars19301

    Insert maiden name into fullname

    Is there a cell formula that will insert colum A = "Doe" into "Mary A. K. Smith" so the result is Mary A. K. Doe Smith"? Thank you in advance for any heko,
  7. mars19301

    Excel year format

    Got it. I did a MID into a column and then CONCATENATE on that column into a 2rd column and then copied and pasted "values" into the 3rd column which I used for the required output. m
  8. mars19301

    Excel year format

    Thank you for the suggestion. Actually the data reads: 1997 and I must turn it into '97 Complicated background story, but that's the requirement.
  9. mars19301

    Excel year format

    For a column, I can get 97 from 1997 using MID, but I need '97 (apostrophe prefix). Can somebody give me a pointer? Thank you in advance for your help.
  10. mars19301

    How to limit query count

    Using TOAD, I am querying a very large file, but only want the data for the first 100 records to review. Is there a way to do this? Thank you in advance for all advice. m
  11. mars19301

    Can I install 9i Personal next to 10g network

    Thank you again, Beilstwh. Based on your second comment about the simplicity of uninstall, I decided to try an install Oracle 10EX on my home PC where I know I'd have time to learn. It's a Dell E310 with XP Home (Oracle recommends PRO) SP2 and 512 RAM. The install went smooooth and with a...
  12. mars19301

    Can I install 9i Personal next to 10g network

    Thank you. Got it 10xe, but no home machine with XP Pro and mem resources so I'm going to install it on my work PC and hope it doesn't foul my work config. J
  13. mars19301

    Can I install 9i Personal next to 10g network

    At work, I have limited access to 10g and use some PL/SQL, but do not have create, replace or update rights. I need to learn so I am thinking of installing 9i Personal on my work PC drive C. I need to avoid any potential conflict while I learn. Would this mess up my 10g access? Thank you in...
  14. mars19301

    varchar2 format to AM/PM

    Perfect! Many thanks. m
  15. mars19301

    varchar2 format to AM/PM

    The course starting time is in a 24 hour field (varch2(4))that I must display as AM or PM as appropriate. Would somebody point me in the right direction? Thank you in advance for your help.
  16. mars19301

    Need temporary PC swap on home dsl line.

    It should. Simply disconnect from the old and plug it into the new. I would reboot the new before trying the browser. m [bull]
  17. mars19301

    Need temporary PC swap on home dsl line.

    FYI - per Verizon tech support (fast and accurate by the way), once the modem is configured, it's a simple matter of taking the usb cable from the desktop and plugging it into the laptop. Voila! [bull]
  18. mars19301

    Need temporary PC swap on home dsl line.

    Hello, I am using Verizon DSL w/my Win98 desktop and Westell 2200 modem. I have a new laptop home from work for just the next two days (not my laptop) and need an internet connection. Do I need to run the Verizon install CD and then play with tech support or is there a workaround? Thank you in...
  19. mars19301

    Missing win98 clock

    Properties are normal e.g. Show Clock is checked but there's no clock. If somebody could send me the Win98 registry entry, I'll give it a go. BTW, I reinstalled the affected app, and at least the related schedule alarm is working so it wasn't relying on seeing the (invisible) clock. Now this...
  20. mars19301

    Missing win98 clock

    Thanks for the reply. Unfortunately, neither are there although I think you're on the right trail with the registry. I recall removing and repairing one of those nefarious and unwanted toolbars just before the clock vaporized.

Part and Inventory Search

Back
Top