Deleting all items from list box

[gaju_3112]

How can we delete all items from list box? I tried using ListCount property in FOR LOOP but it flashes error after deleting some items...
Please anybody tel me the solution...

 

[namliam]

Listbox items should IMHO be contained in a table... that way they are much easier to maintain, change, delete and re-use elsewhere.

Good Luck

 

[gaju_3112]

What is IMHO? I want to add today's date and last seven days from today's date in list box. This list box should be get populated automatically each time when we open application. How can I do that?

 

[namliam]

IMHO = In My Humble Oppinion
Which I thought to be a "normal" internet acronym?

Again I would use a table... probably... unless you are REAL sure you wont need this list anywhere else... Then again... it could be real simple like...

1) Table
Create a table which contains values 0,1,2,3,4,5,6

2) Query
Base your listbox on this query,
Select date() - [column_from_above_table] as last_days from [above_table]
order by date() - [column_from_above_table]

That should allways populate your listbox with the last 7 days, simply add 7,8,9,10,etc as needed...
Short, simple, easy and no messing with listboxes...