Recent content by maro009

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

thx PHV i'm talking about MS Acess 2003 pro if i set the columnCount property from the that means i will have fix amount of columns , but as i said i want set the counts depends on the result so i have to set it in vb is there is any code to set the columnCount of listBox

hi all "i'm new to vb programming" i created empty list box in form with columncount 1 no i have 3 different select statemnt the will have different column result , is there is any way to set the columncount here is the method 'customerNameCB = comboBox 'SearchB = Button 'productsCB =...

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...