The MSFlexGrid tries to automatically determine how to justify text. If the first character is numeric, then that cell will be right-justified. If it is an alphanumeric character, then that
If you usually use DSN-less connections with ADO, you know it can sometimes be a pain to figure out the correct connect string. In that case, you can let the
Sometimes you want to give your DataGrid the ability to edit fields, while the original data in the field is highlighted. Normally, you can click on the field to start
Often you need a data structure similar to a two-dimensioned array or collection, but you need to manipulate it. For example, you need to sort on certain columns, filter certain
If you’re developing multiuser Jet-based applications, you probably know about Microsoft’s msldbusr.dll. It allows you to read the Jet lock files and get the correct number of connected users and
Suppose you have a table with this field: Customer_Code You can retrieve the field in many ways: rs.(0)rs(“Customer_Code”)rs.fields(0)rs.fields(“Customer_Code”)rs.fields.item(0)rs.fields.item(“Customer_Code”) In VBScript, the versions that use field indexes instead of names are
Consider the Data Definition Language statements: “ALTER TABLE [My Table] ADD COLUMN [My New Field] Single” and “ALTER TABLE [My Table] ADD COLUMN [My New Field] Double”. According to Microsoft
Most of my end users use laptops, which can have a wide variety of spreadsheet software installed. I often use this function when working with database tables or queries to
When building SQL statements, use the Tag property to hold the Field Name and Data Format. I use a naming convention of str, int, dat, and so on to determine