Another question for the day, Listbox limits

Another question for the day, Listbox limits

• RichJ79

  lil_isie wrote:

  Hi, sorry for posting two questions in one day.

  You never have to apologize for posting a question

  lil_isie wrote:

  I was wondering if there is an easy way to limit the amount of items in a listbox. For example, i am getting information off of a SQL server and putting the information in the listbox. However, there is a lot of information, and I don't want more than the newest 200. Is there a simple way for me to do this

  How about using a "TOP n" query. You know - SELECT Top 10 yada, nada, blah...

  FYI - I generally do not poulate my list boxes with more than around 2 dozen items unless I am using a Quicken style QuickFill combo because too many items is just user-hostile interface.

  JMHO.

  
  
  

• James81

  lil_isie wrote:

  Also, I'll make sure I keep myself posting here then. I have yet to even take a databases class yet (I am only 19) and I am a programmer at my office already. I get to do the "throw you in the pond, and learn how to swim that way" approach to laerning.

  Do yourself a favor and go to http://www.hentzenwerke.com/catalog/fund6.htm and grab a copy of "The Fundamentals". It will really help you get up to speed.

  
  
  

• joy4u

  Thanks, again I appreciate it. I have NO idea why I didn't think about it that way before. Originally I was thinking of a way to do it with the information from the cursor.
  
  Also, I'll make sure I keep myself posting here then. I have yet to even take a databases class yet (I am only 19) and I am a programmer at my office already. I get to do the "throw you in the pond, and learn how to swim that way" approach to laerning.
  
  Thanks again!
  
  
  
• Another question for the day, Listbox limits