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...
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...
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...
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...
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...
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...
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...
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...
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?
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...
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...
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...
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...
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)...
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.