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 strongm 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: *

  1. aug4570

    Excel-run macro when cell is populated

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

    How to separate full name string into first name and last name fields

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

    Converted FAT32 to NTFS now having problems w/user id and OE

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

    XP: Converted from FAT32 to NTFS, now cannot open Outlook Express

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

    Converted FAT32 to NTFS now having problems w/user id and OE

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

    XP: Converted from FAT32 to NTFS, now cannot open Outlook Express

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

    Excel - Converting Julian Date to a Calendar Date

    Thanks carrr. That worked!
  8. aug4570

    Excel - Converting Julian Date to a Calendar Date

    Anyone know how? Thanks.
  9. aug4570

    Calculating field based on the value of another field

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

    Prevent Excel Worksheet from displaying formula bar

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

    Prevent Excel Worksheet from displaying formula bar

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

    Prevent Excel Worksheet from displaying formula bar

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

    Prevent Excel Worksheet from displaying formula bar

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

    Laptop Doesnt Switch On

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

    Config.sys & Autoexec.bat

    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.*...
  16. aug4570

    Config.sys & Autoexec.bat

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

    Running Record Count

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

    Where is the PageHeader Property Located?

    gus is right, you have to be in the report properties to find what you're looking for.
  19. aug4570

    Where is the PageHeader Property Located?

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

    New memory not detected

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

Part and Inventory Search

Back
Top