Search results

  1. M

    Storing a SQL String Result into a Recordset

    strSql = "SELECT tblUsers.UserID FROM TBLUSERS WHERE tblUsers.UserID = strUSERID" 'Set the source query defInItIon to get the current records In curSourceQueryDef Set rsResult = dbs.Execute(strSql, dbOpenDynaset) The last line in this code is not working in VBA. Can anyone help me with...
  2. M

    TransferSpreadsheet command in a macro

    I have a simple two step macro that is designed to transfer the information (qryOutput) to an excel spreadsheet (and then tell the user it is done). The first time it was run, it worked like a charm. The second time that I run it, Access gives me an error message that the Table qryOutput already...
  3. M

    Error Message - Record Currently Locked

    We have a very simple database (1 form, 1 table, 2 queries) stored on our network. We have had no problems with it for months, but today some of the phone reps are receiving an error message when trying to enter data into the form. The message states "Could not update; Currently locked by admin...
  4. M

    'Too Few Parameters' Error

    I am creating a log-in form for a database and am running into a 'Too few parameters' error when trying to login. I am using the login form to determine which form should be opened (based on a user's department) and to use the login ID as a parameter in a query. Here is the code I am using on...
Top Bottom