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

  • Users: wv1
  • Order by date
  1. wv1

    User form

    Hi All i have created a userform that contains a list box. This list box builds a UNIQUE list of values from a column- it does so by looping though each row in the column and if it finds a new value it adds it to the list. However, how can I get this list box sorted alphabetically? My code is...
  2. wv1

    Greater than 100%

    ok.... but how do we do this if Perform field is a PERCENTAGE field? ie. Perform = 114.95% Thanks again
  3. wv1

    Greater than 100%

    I was basing it on code I use to pick up nulls and replacing with zeros: Perfomance: IIf(Nz([Perform],0)=0,0,[Perform]) and trying to change it to >100% then show "100%" else if it is not >100 then just show Perform?
  4. wv1

    Greater than 100%

    Have looked at that, but cant seem to get it to find anything over >100%...?
  5. wv1

    Greater than 100%

    Hi All I have a field that calculates a percentage. However i do not want it showing any higher than 100%. Thus if it is calculated at 125% then i simply want to show this result as 100%. How is this best achieved? Thanks again
  6. wv1

    Determine which column is filtered

    Hi All Is it possible to determine which column (1-8) has an autofilter currently ON within it? i.e. If i have columns name, age, school and I have filtered on Column 3 to show only a certain school, is there anyway in a macro that can return to the user which column they currently have a...

Part and Inventory Search

Back
Top