Recent content by ImoBase

  1. I

    Using VBA and SQL - mismatch error

    Thanks both. Rat1Sully, you are correct. The code worked after this amend, remarkable that I missed it. Appreciated. mdlueck, thanks for the links. Using values - the code isn't completed, I am building it up, albeit slowly, to do something more than it is doing now and the values will be...
  2. 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...
  3. I

    Paasing parameters to a query

    Thanks both. Didn't know I couldn't pass conditional operators (very good to know) and the tutorial worked a treat. Appreciated.
  4. I

    Paasing parameters to a query

    Thanks for explanation, Spike. SQL on the fly? I'm not sure how to do this within a query, controlled by a form. Could you point me to a tutorial or explanation?
  5. I

    Paasing parameters to a query

    Thanks for the reply, Paul. I have a form that specifies the search criteria in a query. It passes info to a global variable that can be accessed by the form (setting the variable) and the query (that can get the variable for the search criteria) In a global module I have written the following...
  6. 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...
  7. I

    Problem with query accessing VBA function

    Solved...! It would appear that the variable that is passed into my function has a preceding space. Put into a query, designed for an exact match without a leading space, the query of course failed. Thanks again.
  8. I

    Problem with query accessing VBA function

    Thanks for the reply, appreciated. Didn't work, I'm afraid. Any other thoughts?
  9. 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...
See more
Back
Top Bottom