Search results

I've found another way to achieve this by, instead of converting the filters to a string, I've used a temp table to put the different. It was much more easy. Thank you all for your help.

But I have to change vba code to achieve "S1502","S1510","S1000"? Can you give me a full example of the code?

yes, that resumes it all!

Anyone?!? Please!!!!

No. It can be one or more item... Normally its 7 characters but I don't want to limit it I have a form with 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 order to use a...

That's exactly what I want...

What I want to do is this: But instead of putting in the specific criteria (S1502,S1510,S1000), I want the query to "fetch" the criteria in a textbox inside a form ([Forms]![Form1]![TextBox]) But isn't working...

I want to do multiple filters on the same field

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...

I've just solved it: I copied everything to a new database and it worked :)

I'm putting it under "Microdoft Office Access Class Objects" in Form_Form1

It gives me immediately the same error...

Any VBA code gives me an error...

I know! I was just giving an example. I keep getting the same error even with the code...

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...

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...