How do i store data in order from visual basic6 to MS access?

I can store data and everything. But the problem is as follows :-

e.g. i have a table that contain 26 records. "A" till "Z". When i open my access database, the first record on row 1 is the letter "A".

Now, i use ADODC control in vb6 to connect to the database. i used a text box to display the current record being pointed by the adodc. however when i do "adodc.recordset.movefirst" or even if i click the "|<" button on the adodc, it points the first record as "Z", not "A".

how do i solve this problem? i cant change from ADODC to another method. there are thousands of lines of codes depending on it. thanks

Do you have an index on this table? If not, create one in Access
or use "select * from table order by Field1" as your adodc source.

Tags

　　General - Computers & Internet 　　Software 　　Security 　　Programming & Design 　　Facebook 　　Flickr 　　Google 　　MSN 　　MySpace

Related information

Why is this javascript not working in FireFox? Nothing shows.?

I've added a statement after the line function randomlyselectMessage1() { --------------------------------------... var Message1 = document.getElementById( 'Message1' ); -----...

If computer are ones and zeros how do sounds and moving images work?

I want to write a huge answer. I'll try to keep it short. The wonderful variety of media you are used to seeing is simply the result of very complex and numerous sets of these 0's and...

Need help calculating in access?

First off, you don't need [order line id] field in your order table: in fact you don't need [order line id] at all: you can create a combined key on [order id] and [item id]. Design a ...

Creating and using dll files in VC++ and its advantages?

The creation and use of DLLs with VC++ can be somewhat complicated depending on your requirements. If you create your own using the MFC wizard, it's not too bad at all. A great explanation w...

I need a real advice please about making my website duplicatable...?

You should hire a web design company to do the work for you. Once they do it, you can give everyone what they need with ease.

...

How do you add a html code to a image?

Hi! The HTML Image tag is as follows <img src="path_to_the_image.jpg" width="image_width" height="image_height" border="0" alt="image_descripti...

What is the purpose and functions of a network operating system?

A network operating system (NOS) is a piece of software that controls a network and its message (e.g. packet) traffic and queues, controls access by multiple users to network resources such as file...

There are multiple users sharing a single Datasheert..?

Yes you can all you do is open the workbook, then on you menu click TRACK CHANGES>HIGHLIGHT CHANGES, then on the dialogue box check the box that says "TRACK CHANGES WHILE EDITING. THIS WILL...