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

    Excel - Hide calculated field resulting in zero within a pivot table

    Mark, Which version of Excel are you working in ? I didnt see it (doesnt mean it wasnt there, just that I didnt see it =) And did the solution finally click for you ? If you are working in 2007... I only just discovered you can have the values in both the Data section while simultaneously...
  2. MrSnid

    Excel 2007 - Unreadable Content

    I get the message frequently as well... I dont think ALL the files can be corrupted. When opening spreadsheets created in previous versions, I also get the message "the named rang is already inuse in the workbook...do you want to change it" where there are no named ranges originally. Does...
  3. MrSnid

    Anyway to link the size of fields to a field that 'Can Grow' ?

    I found this posted on anther board... Don't use borders. Instead, draw the boxes using the Line method in the Print event. For example, add a line of code for each text box: Me.Line (text1.Left,0) - Step(text1.Width,Me.Height),,B Which tells me there is a way to do it, just not...
  4. MrSnid

    Anyway to link the size of fields to a field that 'Can Grow' ?

    I've come up with another way to ask my question... Is there a way to reference another Field's property in the field property of another field. For Instance, I would like Field194 to have the same dimensions of Field294 where Field294 Can Grow=Yes.
  5. MrSnid

    Anyway to link the size of fields to a field that 'Can Grow' ?

    Aceman1 I am doin pretty fair today (thanks !) feel like I need to say 'long time listner, first time posting'... The 'notes' field is expanding the way it should, it is the other fields on the line that do not expand. Is there a way to have the entire line grow in proportion to the one...
  6. MrSnid

    Anyway to link the size of fields to a field that 'Can Grow' ?

    I have been asked to 'fix' a report which allows a 'notes' field to expand with the length of the note. The 'Notes' field expands and the rest of the line does not which "could cause some confusion for those reading the report". Thanks Leon

Part and Inventory Search

Back
Top