Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2010
    Posts
    21

    Unanswered: VBA Query actually but ..

    wrong forum
    Last edited by ben2203; 02-23-10 at 13:35.

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Code:
    Private Sub Label5_Click()
    Dim strsql
    strsql = "SELECT tbl_ShipOrders.receiver_id, " & _
    "Receiver.company AS Receiver_name, " & _
    "FROM tbl_ShipOrders " & _
    "INNER JOIN tbl_Customers AS Receiver " & _
    "ON Receiver.custid = tbl_ShipOrders.Receiver_ID " & _
    "Order By Receiver_Name"
    
    End Sub
    of course this will do nothing since you don't actually use the string.

    This would be better in the Access forum
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

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