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

    OLAP Pivot Table in Excel 2000.

    To handle the problem I originally posted, I decided to upgrade to Excel XP (2002). This new version allows a user to select multiple items from a drop down list of dimension values. I did not find another of doing this in any older version of Excel. There are a number of additional new...
  2. Mikey2000

    OLAP Pivot Table in Excel 2000.

    I am using an OLAP pivot table in Excel 2000, and I understand some of the functionality of the pivot table is lost when compared to a non-OLAP pivot table. With a non-OLAP pivot table, I had the functionality of going into the settings of a field and hiding values. For example, if I had data...
  3. Mikey2000

    Printing Web Page as it appears in browser.

    Thanks for all the help. There is an option I selected titled, "Print background colors and images" in Internet Explorer under Tools, Internet Options, Advanced. This enabled me to print the page as it appears without hiding any graphics.
  4. Mikey2000

    Printing Web Page as it appears in browser.

    I want to keep hard copies of a web page in color. In other words, I want to print a web page in color as it appears in front of me in a browser. The problem I am running into is when I print the page I can not find an option to print all images and backgrounds. I have tried saving the page...
  5. Mikey2000

    Hiding cells when printing worksheet

    Thanks for your help. I took your advise and ended up creating a new print button that changed the font color, hid the button, printed the sheet, changed the font color back, and then made the button visible again. It works great!
  6. Mikey2000

    Hiding cells when printing worksheet

    How can I hide a cell or range of cells when printing a worksheet? I bring this up because I know in Visual Basic you can hide objects by setting the visual property to false, but I am not too familiar with VBA.
  7. Mikey2000

    Date queries

    If "Is Null" doesn't work, perhaps there is a default value you can query for.
  8. Mikey2000

    multiple betweens in one query

    You can also try this if you only want one query: Click the Totals button (funny looking 'E') Then for column one type: 1-9: IIf([fieldname] between 1 and 19,1,0) Column two: 10-19: IIF([fieldname] between 10 and 19,1,0) Column three: 20-29: IIf([fieldname] between 20 and 29,1,0) Finally...
  9. Mikey2000

    Default Rows Returned in Enterprise Manager

    I'm not sure if it is possible. You can try looking in the system tables though.

Part and Inventory Search

Back
Top