ansaurus

Question

MS Access 2003 - Automatically show last records in list box on a form rather than first

Answer 1

A:

How did you set the listbox items? Are they from a database? If yes, then you need to update the SQL statement with an "order by columnName".

Gerardo Abdo 2010-02-26 17:57:30

yes it is a sql statement that just selects the dataset that I want and that is working fine. But i am not reffering to an "order by" of left to right, etc....rather something that makes the listbox object always have the scroll bar start on the bottom rather than on the top

Justin 2010-02-26 18:04:05

@Gerardo Abdo: What part of "Now I don't mean reversing the order from bottom to top" was unclear in the original question?

David-W-Fenton 2010-02-26 23:43:57

Answer 2

A:

You could add some code to the form load event so that it will do this:

YourListBox.SetFocus
YourListBox.ListIndex = YourListBox.ListCount - 1
YourListBox.Selected(YourListBox.ListCount - 1) = False

It basically selects the last item in the list box so it will scroll down to it, and then unselects it.

patmortech 2010-02-26 18:04:00

so...this is the exact idea I was looking for. however this is resulting in an error: RunTime error 7777 : You have used the ListIndex property incorrectly.

Justin 2010-02-26 18:11:18

Thanks! I do appreciate it; this is what I am after...once I can make it work!

Justin 2010-02-26 18:12:03

I got that same error before I put the SetFocus line in there.

patmortech 2010-02-26 18:21:02

while stepping through i noticed it got thrown to error on the second line of code....

Justin 2010-02-26 18:25:14

I was saying that when I take out that first line (ListBox.SetFocus), I get the same error you are mentioning. After putting it in, the error does not come. So make sure that is in there properly.

patmortech 2010-02-26 18:40:59

i know. i have it exactly how you have it above (with the exception of re-naming my listbox). so I have the .rowsource method for this listbox right above it in the load event? do you think this might be effecting it?? I would want this to take place after the .rowsource sql statement so I wouldn't think so??I know i must be overlooking something else....just trying to find it

Justin 2010-02-26 18:47:20

I don't know why you're getting the error you're getting, but setting Selected to False does not cause the listbox to scroll. @Remou's code is what actually works, and you should accept that as the answer. And the listbox does *not* have to have the focus for his answer to work.

David-W-Fenton 2010-02-26 23:51:09

You're right, setting selected to false doesn't scroll the list box. but setting the ListIndex to the last item DOES. I then added the last line so that the item does not remain selected (since he may not want the thing to be selected). And by the way, this does actually work.

patmortech 2010-02-27 03:06:24

Answer 3

+2 A:

In a suitable event, such as the current event:

 Me.ListX.Selected(Me.ListX.ListCount - 1) = True

Remou 2010-02-26 20:15:32

perfect!! thanks as always Remou!

Justin 2010-02-26 23:36:52

ansaurus

tags:

views:

answers:

MS Access 2003 - Automatically show last records in list box on a form rather than first

related questions