Results 1 to 2 of 2

Thread: SQL / DBGrid problems

  1. Nov 1st, 1999, 10:04 AM #1
    student123
    student123 is offline

    Thread Starter
    New Member
    Join Date
    Nov 1999
    Posts
    1

    Post

    I'm having a bit of trouble with an SQL join in VB5 with an Access back end. I am trying to join two tables on one field that is an autonumber, and the other field being a number. Not sure how to make this work.

    Also can't figure out how to populate a DBGrid without using a data control (I'm trying to use a recordset created at run time). I can get the column headers, but not the actual records. Any suggestions?
    Reply With Quote Reply With Quote
  2. Nov 1st, 1999, 11:46 AM #2
    Clunietp
    Clunietp is offline
    Guru Clunietp's Avatar
    Join Date
    Oct 1999
    Location
    USA
    Posts
    1,844

    Post

    An easy way to get the SQL necessary from Access is to setup the query in access (make sure it works) and click View --> SQL to get the sql necessary to put it in your program

    Tom
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width