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 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.
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
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.*...
Hey all,
Advice please, about my msconfig settings on my laptop. In both Config.Sys and Autoexec.bat there are long lists of check boxes on each tab. I understand these are commands that automatically run upon starting up Windows; however, next to several of these checked boxes (approx 10-12...
Put an unbound text box in your detail line section (you can either just delete the label box or use it with a period in it if you want a period after your numbers). In the properties for the text box, under the "Data" tab select Running Sum - "Over All" if you want all...
In design view, place your cursor exactly on the page header bar after you've activated it, right click and select properties. Either on the "format" tab or the "all" tab is the option for the page header that you're looking for.
I gave u that star Topscribe. Went to that site u cited, downloaded Sandra Standard and ran it on my 'puter. It provided a lot of interesting info about my computer and gave recommendations on improving my system.
After all the help and information everyone has given me, I'm returning the...
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.