Search results for query: *

Yes I did check the references. One class module needs a reference to DAO which exists. The other class module uses late binding and codes against the Cognos Power Play OLE Automation Object. I use late binding since the type library is not installed on other client machines that will use the...

This type of functionality when dealing with large lists is best handled in a database. Use MS Access if you have it. Create two tables and include your customer records. Access has two Query Wizards:- Find Duplicates and Find Unmatched. The wizard will quide you through the mechanics. Hope...

Some very strange things have happened with an Excel 97 spreadsheet I have been developing. I had created two class modules to deal with getting external data. I had code behind a worksheet which handled options selecteted in listboxes embedded in the worksheet. I also had a couple of...

Hope this code helps. Function QueryAndIncrement() As Integer Dim db As Database Dim rst As Recordset Dim strSQL As String strSQL = "Select Field2 from Increment" Set db = CurrentDb() Set rst = db.OpenRecordset(strSQL) QueryAndIncrement = rst.Fields("Field2").Value...

Some very strange things have happened with an Excel 97 spreadsheet I have been developing. I had created two class modules to deal with getting external data. I had code behind a worksheet which handled options selecteted in listboxes embedded in the worksheet. I also had a couple of...

I have written a class in Excel to wrap Poweplay API functionality. I have one method which instantiates an instance of a powerplay report. During testing the visible property was always set to True. Subsequent methods of the class manipulate a Report object which uses the GetObject function to...