Recent content by SidRiz

Dear Friends, Thanks for your help, finally I was able to run query with below code. Private Sub LstAddressController_Click() 'On Error Resume Next '.......This section working.. Dim m As String m = "Select Distinct Panel from HrdSch where Address like '" & LstAddressController.Column(0)...

Yes your observation is correct, I have removed it as Address column changed to NUMBER type and this part is working fine. Now I have only problem with second part of the WHERE that is to add... And Controller Like '*" & LstAddressController.Column(1) & "*';" As Controller is short text...

This addition gives me the name of the controller which is TEXT. with datatype as NUMBER for address and only address in WHERE clause gives me 50 records (this is correct). When I add the controller to where query it gives me zero records (it should be 8-20) based on selection :confused...

Tried but no success. I have tried some more stuff. This is something to do with the datatype of the tables. 1: First test without WHERE, it worked fine. 2: Second test with only one WHERE clause Address: No data retrieved. 3: Third test changed the data type of address from SHORT TEXT to...

Yes I have selected on the list, based on selection & click this event sub is triggered. Successful selection executes the SQL query in above section and 3 column content are loaded into the multi-column list. another query brings the name of the panel and it also executes correctly and another...

Error I get is for BOF/EOF.

Record count zero. Tried again with move last. Private Sub LstAddressController_Click() On Error Resume Next '.......This section working.. Dim m As String m = "Select PointType, ObjectName, ExpandedID from HrdSch where Address like '" &...

Dear Friends, I am Indian & Electronics Engineer working as Technical services manager. In my early days learned VB6, my job does not need programming, but as a hobby, I used it all through years by making tools for my team, Many of them in Excel, Visio & MS Access. Appreciate the community...

Dear Friends, SQL query is working with Multi Colum list Rowsource, but not with the ADO Recordset. SELECT without where work fine. I have used Select with 'WHERE' several times but this is the first instance of the problem. Can you guys help me out? ....................... Private Sub...