It’s easy to add scripting functionality to your VB project, especially if you have been developing through classes all along. The more classes you program, the more objects you can
Microsoft documentation says you can connect to Excel 97 or Excel 2000 using the Microsoft.Jet.OLEDB 4.0 provider. If you use the Microsoft ADO Data Control, however, you will have problems.
Question: How do I change the name of a database? Answer: From another database, maybe sysmaster, type: RENAME DATABASE oldname TO newname.
Question: How do I convert the Unix epoch time into a readable date/time format? Answer: Informix doesn’t have a built-in function that I know of for this. However, a function
You can search a file in all the subdirectories of a given drive in VB using a recursive routine based on the Dir$ function, the FileSystemObject component, or the FindFirstFile/FindNextFile
In a previous Tip of the Day I wrote, I advocated object creations using the tag for efficient server resource use. Another benefit of this approach is that, for the
Editor’s Note: This tip is an update to a previous Tip of the Day. Jai Bardhan claims to have a “better solution” for counting records in a recordset. It is
You can use the Visual Basic split function to convert a comma-separated string to an array. The function allows you to send a string as an IN parameter of a
Prompt is a dynamic property that OLE DB providers can use to allow the user to input customized initialization information, typically through a dialog box. The OLE DB provider may