Recent content by aug4570

I'm a newbie w/VB and have the same problem but I don't understand what I need to do with the Worksheet_Change sub to have it automatically run my macro when I enter information in the cell. Where do I put this code on the worksheet and do I get it to run the macro? Thanks.

The field in the database has "Tom Thumb" and when I get this value from the database I want to separate it into a first name field "Tom" and a last name field "Thumb". Is there a string method that separates a string at a space? Thanks

Without having to go thru the backup restore process, I managed to fix my problem with this MS article: http://support.microsoft.com/default.aspx?scid=kb;en-us;310894&Product=oex Thanks

I moved this question to the Windows XP Pro forum since I think it's more than just an email issue. Thanks, aug4570

I now cannot open my Outlook Express under my user id. I get a message that it is out of memory or the disk space is full. Then I get another message that it cannot initialize MSOE.dll. When I look in explorer under Document and Settings and under my login folder, the Application Data folder...

Getting error message that there is not enough memory or the hard drive is full and that it cannot initialize MSOE.dll. I have the same amount of memory prior to the NTFS conversion. I reinstalled Windows XP and I still cannot open Outlook. Any help is appreciated.

Thanks carrr. That worked!

Anyone know how? Thanks.

Hello, Just wondered how to calculate the value of one field based on the value of another. Example: If Field1 value is 'A' then Field2's value is 5%(Field3 + Field4). If Field1 value is 'B' then Field2's value is just 5% of Field3. Thanks for the help

Thanks Bob and Hasit, that helped me. Appreciate the info, your help, and definitely this valuable site!

Thanks Acron, That works. Now does anyone have a formula that will convert a calendar date to a julian date?

Additional clarification: I want to prevent the user from acessing Tools/Options and selecting the formula bar status. Thanks again.

Hi, Does anyone know how to prevent the formula bar from being viewed by the user? The protect worksheet does not work for this feature. Also anyone have a formula to convert a calendar date to a Julian date? Thanks

Don't know whether this could be your problem but same thing happened to me just recently. I've been using my Compaq laptop w/ac power and battery installed for a long time had no problems whatsoever. The other day tried to turn it on and...nada, nothing happened, just a dark screen. Power was...

Thanks all. Went into sysedit and this is in autoexec.bat: @ECHO OFF @REM Setup for QR, BW & HIBERNATE @PATH C:\CPQS\SAVEREST;C:\CPQS\TOOLS;C:\WINDOWS\COMMAND;C:\WINDOWS;%PATH% @IF EXIST C:\APPL.ZIP\*.* IF EXIST C:\WINDOWS\SMARTDRV.EXE C:\WINDOWS\SMARTDRV.EXE @IF EXIST C:\CPQS\SAVEREST\QRSETUP.*...