To remove the read-only checkbox from a common dialog control, add the following constant declaration to the module: Global Const OFN_HIDEREADONLY = &H4& Then, while calling the common dialog, write

If a virtual function in a base class has a default argument that is overridden in the derived class, at run time the value in the base class is always

This is a great tip for DBAs. If you ever end up removing a variable-length column (varchar) or text column from one of your tables, a certain amount of wasted

If a class data frame’s size goes above 64K (65536 bytes), the Java compiler rejects the compilation. The compiler’s limitation is due to its ability to handle the larger data

Most Web-based Perl applications use more than five .cgi Perl scripts. Instead of typing all the DBI information in the script, I created a function you can use that gets

Did you know you can start a job from the Query Analyzer? Here’s how you do it: exec msdb.dbo.sp_start_job @job_name = ‘My SQL job’

The WshShell Exec method can be used to launch a process. It returns an object that can be used to monitor execution and to access the stdin and stdout streams.

Sometimes, filenames may contain characters like “.” and file-extensions may not necessarily be always 3 characters long. This code provides a handy way to get file attributes in a foolproof

You may have noticed the auto completion feature in the edit controls in Microsoft’s file dialog boxes. You enter a few letters/words of the file path/file name, the edit control

You may have noticed that running a process from Java using Runtime.exec() sometimes hangs the process. This is true especially in those cases where the process runs in the background.