Results 1 to 5 of 5

Thread: databases, beginner

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Apr 1999
    Location
    New Jersey
    Posts
    334

    Post

    hi!
    I don't really know anything (barely anything) about working with mdb databses. All I know how to do is load databases, display tables in a grid, and sort them using SQL code. I wanted to know three things:
    1)When I sort items (numbers) in a table, how can I get the bigger numbers to show at the top, rather than the small numbers?
    2)How can I write to databses in run-time?
    3)Will my program be able to run on a machine that doesn't have Acces installed?


    ------------------
    Regards,
    Alexander McAndrew
    VB Zone
    http://gsenterprise.server101.com


  2. #2
    Addicted Member
    Join Date
    Jan 1999
    Location
    Sydney,NSW,Australia
    Posts
    178

    Post

    Ok don't know about 1

    but
    2) Gee how do you want to do it. Bound, un-bound etc. l generally use the un-bond approach, try something like

    rs.addnew
    rs!Key = Key field Data
    rs!Fld1 = Name
    rs!Fld2 = Address
    rs.update

    Can email you an example of handling databases if you want (jritchie@genauto.com)

    3) Yes, when you build your distribution disks the Jet database dlls are loaded, therefore you don't need Access

  3. #3
    Hyperactive Member venkatraman_r's Avatar
    Join Date
    Jul 1999
    Location
    Chennai, INDIA
    Posts
    284

    Post

    Hi Friend,

    Answer for you first question is really, simple. When you create ur fields in the table, you can set the sort order to "Descending", and this help you. Hope this is what you need.

    Good Luck and Regards,

    Venkat.

  4. #4

    Thread Starter
    Hyperactive Member
    Join Date
    Apr 1999
    Location
    New Jersey
    Posts
    334

    Post

    Thanks both of you. Jritchie, can you please send me whtever you offered to send me to:

    gs_enterprises@hotmail.com

    Thanks again.

    ------------------
    Regards,
    Alexander McAndrew
    VB Zone
    http://gsenterprise.server101.com


  5. #5

    Thread Starter
    Hyperactive Member
    Join Date
    Apr 1999
    Location
    New Jersey
    Posts
    334

    Post

    Thanks both of you. Jritchie, can you please send me whtever you offered to send me to:

    gs_enterprises@hotmail.com

    Thanks again.

    ------------------
    Regards,
    Alexander McAndrew
    VB Zone
    http://gsenterprise.server101.com


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width