Search results

combo14.rowsource = "select field5, field6, field7, to field11 from table1 where field1=combo14.value " my apology about the where clause. actually is pointed to the PK in the table. Yep, they are able to split into the textboxes. however, whenever i selected "I" in the listbox the error...

you're right.. what im trying to achieve.. i have a rowsource of 6 columns each column of which is a string which can be split into an array. so whenever i select an item in listbox, the rest of the textboxes will populate the value accordance to listbox index where .list0.listindex comes into...

To all experts in VBA, Can help to find what wrongs with my code ??? keep giving me run time error 9. What is the solutions to prevent this kind of things to happen again ?? I'm trying populate each of the textbox base on the individuals index selected in the listbox. however, when i...

Not In i wanted to write a sql that select field1 from table1 where field1 not in select field1,field2,field3 from table2. anyone can help ? SELECT RoomNo FROM table1 AS r WHERE RoomType ="Suite" and ViewPreference="pref" and RoomStatus="status" and SmokingRoom="option" and RoomNo Not IN...