A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Records in Listbox Identified in Reverse Order



 
 
Thread Tools Display Modes
  #1  
Old November 23rd, 2009, 08:15 PM posted to microsoft.public.access.tablesdbdesign
Londa Sue
external usenet poster
 
Posts: 50
Default Records in Listbox Identified in Reverse Order

Hello,

I have a list box that is populated as data is entered into the form. (I'm
reusing a database that worked well, but needed editing for a different
project.) In the original database, the records were identified
correctly--first item entered is record 1, second item entered is record 2,...

In the "new" database (I had to modify some data sources), the items are in
reverse. The first item entered is record 2, the second item entered is
record 1,...

Any idea why this is occurring? I've checked what I know to check and
cannot tell what the problem is.

Thank you,
  #2  
Old November 23rd, 2009, 09:01 PM posted to microsoft.public.access.tablesdbdesign
J_Goddard via AccessMonster.com
external usenet poster
 
Posts: 221
Default Records in Listbox Identified in Reverse Order

Hi -

Please give us more information -

What is the row source type for your listbox - table/query or value list?

How are you adding values to the listbox - if VBA, please post the code.

Thanks

John








Londa Sue wrote:
Hello,

I have a list box that is populated as data is entered into the form. (I'm
reusing a database that worked well, but needed editing for a different
project.) In the original database, the records were identified
correctly--first item entered is record 1, second item entered is record 2,...

In the "new" database (I had to modify some data sources), the items are in
reverse. The first item entered is record 2, the second item entered is
record 1,...

Any idea why this is occurring? I've checked what I know to check and
cannot tell what the problem is.

Thank you,


--
John Goddard
Ottawa, ON Canada
jrgoddard at cyberus dot ca

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200911/1

  #3  
Old November 23rd, 2009, 09:24 PM posted to microsoft.public.access.tablesdbdesign
KARL DEWEY
external usenet poster
 
Posts: 10,767
Default Records in Listbox Identified in Reverse Order

Access stores records like a barrel of brick - just a jumble, no set order.

Do not view records at the table level but use a query, form or report.
These can be sorted in any manner that you need to display.

--
Build a little, test a little.


"Londa Sue" wrote:

Hello,

I have a list box that is populated as data is entered into the form. (I'm
reusing a database that worked well, but needed editing for a different
project.) In the original database, the records were identified
correctly--first item entered is record 1, second item entered is record 2,...

In the "new" database (I had to modify some data sources), the items are in
reverse. The first item entered is record 2, the second item entered is
record 1,...

Any idea why this is occurring? I've checked what I know to check and
cannot tell what the problem is.

Thank you,

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:07 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.