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!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by xidnad

  1. xidnad

    Change UserForm data type

    Thanks Gerry, I was thinking that was going to be my option but I wanted to check if there was another way.
  2. xidnad

    Change UserForm data type

    I am not using a data source. I have one textbox that I want the user input (Cost) to display with thousand separators and one that displays a formula value that I also want to display with commas. The formual sums data previously posted in the workbook from the user input (the sum of all Cost...
  3. xidnad

    Change UserForm data type

    I am creating a UserForm in Excel2000 and I want to change the data type for two of my text box variables to "double" and format them with a comma for the thousand separator and no numbers to the right of the decimal. Is this possible? Thanks
  4. xidnad

    run macro on PC boot-up

    longhair, So sorry I forgot to say thanks. I do believe that that is my best option. Thank you, xidnad
  5. xidnad

    run macro on PC boot-up

    macropod, That would be once a day regardless of whether I manually start Excel. Thanks for asking, xidnad
  6. xidnad

    run macro on PC boot-up

    I have a macro I would like to run once a day (not everytime I open Excel). I have tried storing the workbook with the macro in my Start Up folder and sometimes it runs and sometimes it doesn't. I am using Windows & Excel 2000. I also have a virus scan that runs at boot-up and am wondering if...
  7. xidnad

    Field suppression for two conditions

    Thanks for your remarks once I made those changes and reversed the order ({ado.UnitType} like "*PPAV*") or({ado.Influ3Code} like "*OVL*" and {ado.Influ3Percent} = -100) it worked.
  8. xidnad

    Field suppression for two conditions

    I am using Crystal 7.0 and trying to suppress a text field, using the Format Editor, based on two different conditions. The suppression works with either condition but ignores the second condition if I try to use them together. I am trying to use: {ado.Influ3Code} like "OVL" and...
  9. xidnad

    Menu Item to Display Calc Option

    When the problem occurs it is set to (3)? Manual
  10. xidnad

    Menu Item to Display Calc Option

    I have a user with a quirk in his Excel that seems to turn off the Automatic Calculation. We have tested several scenarios and cannot determine why this happens. I looked through the built in tool bar customization options and didn't see one for this function. Is it possible to create a custom...
  11. xidnad

    Conditionally Suppress a Text Field in the Page Header

    Thanks for the solution. Unfortunatly the third party software I run my reports in doesn't work well with subreports so I'll have to rethink my design.
  12. xidnad

    Conditionally Suppress a Text Field in the Page Header

    I am trying to supress multiple text fields in my page header using formulas simular to: NOT({ado.Code} in ["025","030","031","032","033","034","035","036"]) there are for different text fields, each with their own group of codes. In testing this I found that only the code in the first record...
See more

Part and Inventory Search

Back
Top