DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: storing in ORDER from vb6 to access...plz help

  1. #1
    Join Date
    Feb 2008

    Unhappy storing in ORDER from vb6 to access...plz help

    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

  2. #2
    Join Date
    Nov 2003
    Portland, OR
    What is the value of the ADODC's RecordSource property? You can set it to a SQL query which specifies the record sequence, e.g.:

    SELECT column1, column2, column3 FROM TableName ORDER BY column1
    Phil Weber

    Please post questions to the forums, where others may benefit.
    I do not offer free assistance by e-mail. Thank you!

  3. #3
    Join Date
    Feb 2008

    Smile Thanks Mr Phil Weber

    The solution is so simple and i didn't see it. Thanks again

Similar Threads

  1. Converting Access 97 to 2000 via VB6?
    By syme321 in forum VB Classic
    Replies: 1
    Last Post: 03-04-2005, 10:09 AM
  2. Can VB6 still access encrypted DB?
    By Shannon in forum VB Classic
    Replies: 2
    Last Post: 02-23-2003, 04:10 AM
  3. Replies: 60
    Last Post: 09-13-2002, 05:41 PM
  4. vb6 and Access 2000
    By Ariane in forum VB Classic
    Replies: 4
    Last Post: 10-28-2000, 03:13 PM
  5. Access 2000 automation from VB6
    By Mak Foka in forum authorevents.kurata
    Replies: 3
    Last Post: 04-18-2000, 08:21 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center