Results 1 to 7 of 7

Thread: How can I get this to work?

Threaded View

  1. Aug 28th, 2012, 12:56 PM #7
    DataMiser
    DataMiser is offline
    PowerPoster
    Join Date
    Feb 2012
    Location
    West Virginia
    Posts
    14,206

    Re: How can I get this to work?

    Ok So what exactly is the value of text2.Text when it gets to the line to open the recordset?

    If it is like what shows in your error message then there are several issues msotly resulting from the fact that you can not put code into a text box and expect it to execute. Whatever ends up in the text box has to be a valid SQL query it needs to have the value of the textbox not the works textbox and the & signs and quotes all of that is a problem if it is in the textbox when the rs.open is called.
    Last edited by DataMiser; Aug 28th, 2012 at 01:00 PM.
    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