Results 1 to 2 of 2

Thread: Select from combo box(RESOLVED)

Threaded View

  1. Apr 7th, 2003, 08:32 AM #1
    david maddison
    david maddison is offline

    Thread Starter
    Junior Member
    Join Date
    Jul 2002
    Location
    Newcastle
    Posts
    19

    Select from combo box(RESOLVED)

    The combo1.text box contains table names but some times there is a space in the name and the select query will not work i have tried with and without brackets any ideas thanx


    VB Code
    ________________________________________________
    rs.Open " SELECT * " & _
    " FROM " & (Combo1.Text), _
    cnn, _
    adOpenKeyset, _
    adLockReadOnly, _
    adCmdText
    rs.MoveFirst
    ____________________________________________________End Code
    Last edited by david maddison; Apr 8th, 2003 at 01:46 AM.
    david
    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