Hello, i am making a code using VBA into access 2010.
I am making a search code, that get data from a form and create a select using this data to search a register in a table.
Ok, the problem is in a combo box that have the options yes and no that return 1 and 0, i can make VBA understand that this a boll Variable, but since my access is in Portuguese instead of returning "True" or "False" it's is returning "Verdadeiro" or "Falso" (it's the translation of true and false).
The problem is that it's creating the string that i an using to create the SELECT with "Verdadeiro" or with "Falso" and since SQL don't recognize this my code it's not working.
In other words, the Access (or the VBA) is translating the booleans values to the language that access it's installed (in this case, into portuguese).
Someone have seem something like that before? I have no idea what to do and i searched all the web for a solution, if i can't solve this i will have to change my boolean values to small int and do a lot of workarounds