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 bkrike 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: ksnpc
  • Content: Threads
  • Order by date
  1. ksnpc

    conditional formatting formula with date ranges

    B15 is a date of birth field where a user enters a date. B16 is a date received field where a user enters the date an application is received. I am trying to figure out how to create a conditional formatting formula that I can use to flag B16 as red if an invalid date is entered. Here are the...
  2. ksnpc

    parse string query

    I would like to take a scientific name string a parse it into three separate columns - genus, species, and subspecies. Examples: Mustela nivalis --> genus: Mustela species: nivalis subspecies: <blank> Ophisaurus attenuatus longicaudus --> genus: Ophisaurus species: attenuatus subspecies...
  3. ksnpc

    java -version?

    I was asked to ensure that a user's java version was 1.5 or greater. I went to Java's test page and it reported 1.5.0_09, but when I typed java -version at the command prompt, it reported 1.3.1_01. I checked the Java control panel and it also reported 1.5.0_09. I was under the impression that...
  4. ksnpc

    system recovered from serious error

    Hi, I have an XP Pro SP1 pc that has suddenly started giving me an error message on login that says something like "This system has recovered from a serious error". If I press the Send Error Report button it tells me it's an unknown driver error. There haven't been any hardware changes so I'm...
  5. ksnpc

    what happens if you change media pools?

    I'm not sure I know exactly how to word my question, but here goes. We use Brightstor 9. We've been doing a gfs rotation schedule where we do a full backup Tuesday and differential backups on the other weekdays. We keep a weekly set for four weeks, a monthly set for a year, and one monthly...
  6. ksnpc

    failed to open rowset; unknown query engine error

    Hi, I'm using Crystal Reports 9 (an OEM version) connected to Oracle 9i. I try to run my report on a certain record and I get the "failed to open a rowset" followed by "unknown query engine" errors. The report has been working well for a long time and so far I've only come across this error on...
  7. ksnpc

    Outlook 2000 freezes as soon as it's opened

    I have a user running Outlook 2000 on a Windows XP Pro computer. When she goes into Outlook, she can see her list of emails but she can't open anything. Right after the program opens, you can hear an error ding and then it just freezes up. I tried re-installing Outlook but that didn't seem to...
  8. ksnpc

    Problems printing header, footer, and text boxes in Word 2000

    We have a user who is having weird results when trying to print from Word. She can open a document and see everything as it should appear, including the header and footer info. But when she goes to print preview (or straight to print), the text in the header disappears completely. There's a...
  9. ksnpc

    display the last ten characters of a string

    It seems like it shouldn't be too hard to do this, but I can't get it to work. I am trying to see the last part of a clob field. Does anyone have any suggestions on how to do this?
  10. ksnpc

    How do I get a subset of a string, up to a certain character?

    Hi, I'm trying to write a sql query in ToRA connected to an Oracle9i database. I have a string field that looks like this - "142.000000 - 34527". The first part of the field is the same value as the primary key of another table (142). I would like to get just the first part of the field up...
  11. ksnpc

    incorrect and inconsistent results each time rpt runs

    I'm running CR 9 on Windows XP, connecting to an Oracle 9i database. My report is showing rare and endangered species grouped into types of species. I was checking over a printout of the report and found that 12 species were missing from the list. I checked the database and could find nothing...
  12. ksnpc

    Excel hyperlinks have become corrupted

    I have a workbook that lists the projects that I'm working on with hyperlinks that I can click to take me to related documents and images on my networked drives. It also includes a few web hyperlinks and email links. Recently, all the hyperlinks to networked drives have changed and become...
  13. ksnpc

    how do I connect multiple computers through one network connection?

    I'm supposed to set up our conference room to do a hands-on training session for 6 people. They will all need access to the network but there's only one network jack in the room. Is there a way to share that connection between all the computers? I don't even know the right terminology to use...
  14. ksnpc

    adobe reader crashes when trying to print

    I have a user who was using the free Adobe Reader 7 on Windows XP SP1. It had been working fine for awhile then suddenly started misbehaving. When she tries to print anything, an application error pops up and the program ends. I've tried: 1) Installing the update for version 7 2)...
  15. ksnpc

    not like

    Hi, I'm using CR 9 connected to an ODBC database. I have a memo field where the data string should always begin with a year. I'm trying to find records that don't follow that format so they can be corrected. I've tried to use the the formula editor to select records that do not begin with...
  16. ksnpc

    Outlook 2000 - adding inbox of another user for review

    Hi, I need to add the boss's Exchange mailbox to the secretary's Outlook. I already have the mailbox from two other people in there and they work fine. But when I try to add his, Outlook says "Unable to display the folder". I tried deleting it and adding it several times but that did not work. I...
  17. ksnpc

    McAfee problem at login - webscanx.exe

    Hi, I have a Windows 2000 machine that gives the following message every time someone logs in: "WebScanX.exe has generated errors and will be closed by Windows. You will need to restart the program. An error log is being created." I can't figure out why this is happening or how to fix it. I'm...
  18. ksnpc

    cd rom stopped working

    I have a Windows NT user who reports that his CD-ROM drive has suddenly stopped working. He has used it in the past week with no problems, but today it says that the drive is not accessible. He has tried rebooting and he has used CDs that have worked in the past on that machine. There have...
  19. ksnpc

    Windows NT CD-ROM drive not accessible

    I have a Windows NT user who reports that his CD-ROM drive has suddenly stopped working. He has used it in the past week with no problems, but today it says that the drive is not accessible. He has tried rebooting and he has used CDs that have worked in the past on that machine. Does anyone...
  20. ksnpc

    Restrict records based on number of words in string field

    I'm using CR 9 with an Oracle database. I have a string field that contains scientific names. This is an example of my current output: Bufo americanus Bufo americanus americanus Bufo americanus charlesmithi Gyrinophilus porphyriticus Gyrinophilus porphyriticus duryi However, I want to...

Part and Inventory Search

Back
Top