var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Sql query in vb
i have a query like
qu1 = "Select Deptname from Depart where Deptno= "
where i want to display the depart name in a text box while entering deptno in other text box
so with above query i want to concatenate the text box value after =
where the entering string is of data type text
can anyone help???????????????????
thnx in advance
Sql query in vb
You may write a Dlookup() Function (not an sql statement) in the Text Box's Control Source property to display the Department Name in the Textbox.
=Dlookup("DeptName","Depart","DeptNo = " & me![DeptNo])
(Learn MS-Access Tips & Tricks)
Learn Advanced MS-Access Programming with sample VBA Code.
All responses are based on Access 2003/2007