Ngoclong226
New Member
- Joined
- Mar 20, 2019
- Messages
- 5
Hi
I have a database access with “LAL data” table and “Job_no” field.
I have create a userform in excel with input textbox “txt_jobno”
How can i count the number of fields in access table with criteria as textbox input value.
My code of selecting the data in acess:
Const strSQL_c as string = “select count([LAL data].Job_no) as CountofJob_no From [LAL data] Where ([LAL data].Job_no = “”me.txt_jobno.value””)”
But it did not work.
Could anyone help?
I have a database access with “LAL data” table and “Job_no” field.
I have create a userform in excel with input textbox “txt_jobno”
How can i count the number of fields in access table with criteria as textbox input value.
My code of selecting the data in acess:
Const strSQL_c as string = “select count([LAL data].Job_no) as CountofJob_no From [LAL data] Where ([LAL data].Job_no = “”me.txt_jobno.value””)”
But it did not work.
Could anyone help?