Search results for query: *

Thanks! I really appreciate both of you taking the time to help me. [thanks]

Oh wow that is so much clearer! It never even occurred to me to use named ranges. I changed the Thru to =DATE(YEAR(From),MONTH(From)+6,31) but otherwise this was flawless. Thank you so much!

Oh - 5/31 you're right. That was one of my problems - figuring out how to account for the different number of days in the months. I was thinking of using the EOMONTH function (which I just learned about) but I'm really just using this as a conditional formatting formula so I might just put 31...

That is how I stated it. But I failed to state that they have the entire month 3 months before or 3 months after, etc. So the 3 months ahead at the beginning of the month to the 3 months following at the end of the month. So using your example. If the DOB is 2/7/1952 then they have from...

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

Another way is to right-click on the field and choose Format Field. The paragraph tab has a place to set indentations. You can set the first line to -.5 and left to .5 and it will create a hanging indent.

I had to adjust it slightly, but that got me what I needed. Thanks so much Mufasa!

Thanks for responding Mufasa, I believe all the non-standard names would all have a "." included. I'm afraid I don't have a master list though.

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

Thanks!

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

I just wanted to post a follow up in case someone else has the same issue. Unfortunately, I ended up having to reinstall the OS to get rid of the "serious error" messages. The system restore seemed to work at first but the error came back. I tried the other solutions as well but they didn't...

I just finished that. I don't know why I didn't think of it earlier. I didn't realize how far back the problem went, the user just reported it Friday, but it had apparently been going on for awhile before that. She also told me that it's been happening most of the times she logs in, but not...

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

Thanks for the quick response. I wish it would let us use the same pool but when we get to the point where it complains that the pool exists it won't let us go any farther. Oh well, I'll try to run the merge and see what happens - it sounds like what I'm looking for. Thanks, Shauna

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

I think you could join the tables using a left outer join so that you would be able to see all the SSNs from both tables. Then in the Select expert, you could use the formula editor to choose only the SSNs if they are null in the second table. Something like- IsNull ({Table2.SSN}) I hope...

To create a connection, I go to ODBC (RDO) and select Create New Connection and then point it to ORA_SERVER which is the system DSN for the database. For this report I'm connecting to tables and a view.

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