Search results

  1. J

    Returning a row from SQL and storing in local table

    Hi all! I have a bit of an issue. Im trying to retrieve a row from SQL and insert it into my local DB table. However, when I try and execute the code, I get an error message. The data had not been inserted into my local DB table. Here is the code: strsql = "INSERT INTO EntryDetail_Local...
  2. J

    Stored Procedure Query

    Hi all, Quick question regarding queries. Im working on a project in Access 2002. I want to execute a stored procedure as a SQL Pass-Through Query and pass a variable to it from my code. Im guessing the statment will look something like this: exec get_companylist_search @variable I have...
Back
Top Bottom