Search results

Hello there, I have a form with a ListView ActiveX object. I want the user to be able to double-click on an item in the ListView and edit data related to it. The problem I have is that, unlike the TreeView object, the ListView doesn't have the .SelectedItem property, and I don't know any other...

Hello! I'm using a TreeView and a ListView interactively in a form. When the user clicks on a node in the TreeView control, the ListView fills with items relating to that node, obtained from a table. This follows the model presented in...

Hi there, I've just begun working out how to use a TreeView control. I can fill it with nodes using data in a table, but that's about as far as I've got. I can't find a definitive list of treeview and node properties and methods that can enable me to do other things, like have the user...

Hello all, This question was posed by Webbmi on 7-11-00, but got no response. I guess it's worth another shot, though... Basically, is there any way you can get a subreport to be displayed in columns? If you set columns in the page settings of the subreport, they are displayed when you view...

It's OK! I've solved my own problem by using the IsNull() function instead of If Object Is Null ... I love VBA. I love VBA. I love VBA. I love... ---------------------------------------------------- I have code similar to this in my program: With MyRecordset If .RecordCount > 0 Then _ **...

I have a report that summarises data in a table-like format. This report usually has a large number of rows in it, and can be quite hard to read. In order to make it easier to read, I want to shade alternate records. Is there a way of doing this? For example, if I wanted the background of the...

I have a program that outputs the results of a simulation to a set of tables. Every time the program is rerun, these tables need to be emptied of records before the simulation can proceed. I've tried using a control loop that deletes each record one by one, but as my project creates thousands...

Please help! The following procedure (Access 2000) always comes up with error 13: Type mismatch. "Review Managers" is an existing Table in my database. I've checked for typos. What am I doing wrong? Thanks. Sub Test() Dim dbs As DAO.Database Dim rst As Recordset Set dbs = CurrentDb()...