FDemers wrote:

The card-waving ones, I play poker with when I am low on beer money. They get an expensive but valuable lesson in Probabilities and Applied Psychology.

On a related note, I believe Howard Lederer[^] is a Mensan.

Andrew Stampor wrote: I am spoiled by my VC++ macros...is there a way to create and use macros in VB 6? Not directly. VB6 "addins" are the way to go to execute custom code integrated to the IDE and handle many mundane tasks. For example, our company wrote a VB addin that does some standards checking when forms are saved. Addins have a bit of a learning curve to be properly implemented. I've had problems because I wasn't careful about properly handling the life cycle of my addin.

Anonymous wrote: findSQL = "SELECT Price.ProductCode, Product.Description, Price.Price " & _ " FROM ProductType INNER JOIN (Product INNER JOIN (PriceDescription INNER JOIN Price ON PriceDescription.PriceCode = Price.PriceCode) ON Product.Code = Price.ProductCode) ON ProductType.TypeCode = Product.TypeCode " & _ " WHERE (((PriceDescription.PriceDesc) = '" & strDesc & "') AND ((ProductType.Description)='" & strType & "'))" You are selecting data from the Price and Product tables. Which colunns are being edited? To update the Description, you need the primary key of the Product table to be included in the data. To update the ProductCode or Price columns, you need the primary key of the Price table in the data. Without the primary key columns in the data, the proper row can't be located for updating.

mcm wrote: having performed an update in a datagrid, i get this message box: " insufficient key column information for updating or refreshing" (even though the table in the database updates successfully) There could be a number of reasons for your problem. One of the most common reasons is that your data was retrieved from multiple tables. The other tables would like to try updating, but they can't because the primary key is not available in the retrieved data. If you could provide more specifics, you might get a more useful response. For example, what kind of data are you retrieving (Access, SQL, Oracle)? Are you using ADO, ODBC, or something else to get the data? We need enough information to "debug" the problem.