I have an Access table and I would like to search for datas matching a certain input field in a Visual Basic 6 form.
Name of the table is A with a1 to a4 as the column names. I've created a data environment and within a command which has the following sql statement
SELECT a1, a2, a3 FROM a WHERE (a2 LIKE inputField)
Unfortunately do I have problems to connect this to a button in VB.
It would be ideal if the result could be stored in another table but I do not know how.
Whenever I run the above command with an exact value like for instance 'test' everything is okay but it doesn't get the variable form the input field. Any idea where the bug is?
Thank you for your support
Kind regards Andreas