Thai
Jun 9th, 2000, 12:20 PM
Hello,
1. I tried to write a query in MS Access with a criteria that displayed all the records that contained a string that was all CAPS. The criteria used was Ucase([Table1]![Field1]) but it still shows ALL the records. I guess MS Access' queries don't differentiate caps and non caps, is there a way to make this work?
2. I have used the listview control in VB6 so I tried to place one in an MS ACCESS form and everything seemed to go fine until I tried to manipulate it through code. In vb6 I would use the Listview1.Listitems.Add to add items, but there is not Listitems property in the Listview. How do you add items to the Listview control in ms access?
Thanks!
Thai
1. I tried to write a query in MS Access with a criteria that displayed all the records that contained a string that was all CAPS. The criteria used was Ucase([Table1]![Field1]) but it still shows ALL the records. I guess MS Access' queries don't differentiate caps and non caps, is there a way to make this work?
2. I have used the listview control in VB6 so I tried to place one in an MS ACCESS form and everything seemed to go fine until I tried to manipulate it through code. In vb6 I would use the Listview1.Listitems.Add to add items, but there is not Listitems property in the Listview. How do you add items to the Listview control in ms access?
Thanks!
Thai