Search results

  1. H

    Help on a query

    Hello. I have this code: SELECT Table1.Field1, Table1.Field2 FROM Table1 WHERE (((Table1.Field1) In ([Forms]![Form1]![TextBox]))); Inside the textbox is a VBA generated code like this S1502,S1510,S1000If I only put one string (like S1502) it gives me the result but with 2 or more it just don't...
  2. H

    Error on VBA

    Hello! I have a financial database which I'm using to do bank account reconciliations. I'm trying to build a form which only has 4 objects: a ListBox, a TextBox and 2 buttons. The purpose of this form is to retrieve multi-selection items from the ListBox in the TextBox seperated by a comma, in...
  3. H

    Export to excel witha a variable name

    Hello! I'm having a problem with access 2007 so I googled it and I stumbled with this site. I'm trying to export a table form access to excel but I wan't the exported file name to be extracted from one specific cell in the table. I thought about assigning tempvar with a sql query like...
Back
Top Bottom