Search results

hi i want to add very large selece statement into a string in vba , how can i do this the selesct statement has 800 char when i try to add it to string it addes he first 256 char only any idea thx

hi i have a combobox row source is : SELECT Customer.Customer_id, Customer.CustomerName FROM Customer ORDER BY [CustomerName]; now how can i return the customer_id from the selected row example combobox customerID | customername 1 | mike 2 | Kyle 3...

thx Bodisathva can you give me an example plz thx

>>Look at the format tab for your listbox and see what your column count is...change accordingly. column count should be dynamic not static depands of the select statement.... ?????

hi i have a simple query that will select from 2 tables how can i display the result in list box what i did is Private Sub SearchB_Click() Dim qry As String qry ="Select Student.name , Student.address , Course.name , Course.proff From Student , Course Where Student.id =...

i think my question was not clear the combobox will not execute any query 1- combobox (list of customer id's) 2- searchButton (execute query) what should happen is, first select user id from the combobox and click on search button, here i add click event on the click button Private Sub...

Hi first i want to say i'm new in this vb micros things, but i have some back ground in othe programming langauges ... any way i have form with 2 combo boxes, one text box and one search button the first combo box "CustomerCB" display list of customer names " the second combo box "productsCB"...