Search results

:banghead: Hi I'm building a query from tables and there is a field i called it: Weight, that should contain the value from the Description field. The Description field is a text field and it always end with the format as --T, with -- as number, and it can be either 1 or 2 digits, no more. For...

It's a mess, at least for me, I'm sorry I don't have much experience in programming. What I was trying to do is use the 4 blank text box as criteria in the WHERE clause in the SQL statement. That's why I tried to build up the myCriteria string. But right now I'm confused again because I might...

Hi all. I'm creating a simple database for managing parts of machines. I have one form, search form with 4 blank textbox for user to enter. I wrote this code to generate the SQL Select statement. How do I display the result? The Access file only have one table: Parts. Structure as below: Parts...