Search results

  1. I

    Using VBA and SQL - mismatch error

    Hi, When I run this code (from a button on a form, in relation to a subform record) I receive this error: Run-time error '13': Type mismatch When I debug.print the SQL and put it into a blank query, the query runs and appends a new record to the appropriate table. I am perplexed. Anyone...
  2. I

    Paasing parameters to a query

    I am having a problem passing information to a query from VBA. I can pass criteria that is simplistic e.g. strAttending = "Attended" SetResultAttending strAttending (this passes my information to a global variable) And I then get a query result returned based on this...
  3. I

    Problem with query accessing VBA function

    I have written some MS ACCESS 2003 VBA that allows a variable to be passed to a query, using a form to harvest criteria for the query. Unfortunately, the variable does not seen to be passed on to the query, although the query function call is triggering the VBA - it just dosn't seem to be...
Back
Top Bottom