Results 1 to 12 of 12

Thread: [RESOLVED] Querying

Threaded View

  1. #1

    Thread Starter
    New Member
    Join Date
    Apr 2007
    Posts
    8

    Resolved [RESOLVED] Querying

    Here's what I'm trying to do:

    1. An Access table exists with two fields. OrderID and ItemID
    2. The user enters, in a VB6 form, the OrderID they wish to find information for and clicks a command button.
    3. The data from the ItemID field for each instance of the entered OrderID are added to a listbox.

    Using a data control.

    It should be straightforward to carry out, but I'm not sure how to perform the match between OrderID and ItemID in VB? Would I have to use SQL?

    Cheers
    Last edited by Plant; Apr 13th, 2007 at 10:32 AM.

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