Private Declare Function SHEmptyRecycleBin Lib “shell32.dll” Alias _ “SHEmptyRecycleBinA” (ByVal hWnd As Long, ByVal pszRootPath As String, _ ByVal dwFlags As Long) As LongConst SHERB_NOCONFIRMATION = &H1Const SHERB_NOPROGRESSUI = &H2Const

There are techniques for creation of objects (read allocation of memory)widely known as lazy Instantiation and Eager Instantiation.Lazy instantiation is a memory conservation technique, by which, a programdelays the creation

Everyone is getting into XML but most of us have our data in Access or SQL databases. You can dump your data to an XML file in an instant by

It might be useful to garner an enumeration of all thread groups and theirthreads in your running application. The following method shows you how todo that: public void printOutThreadGroups(){ //create

When passing arguments to in-process OLE servers, you can pass everything by reference. This is because the OLE server shares its client Related Posts Using ENUM to Pre-define Column Values

Each MTS component can contain one or more classes which, in MTS terms, are referred to as MTS Objects. Visual Basic 6.0 provides a new property called MTSTransactionMode that can

sp_spaceused can be used to compute the amount of disk space used for data and indexes, and the disk space used by a table in the current database. If no

If you make changes to the SQL Server Registry entries, then you should first back up those entries by using the Regrebld -backup command-line utility. Usage is: Regrebld -backup You

In your apps, do the right thing: Use the computer’s Temp folder to hold your temporary files. To find that location, paste this code into the Declarations section of a

Occasionally you initialize a form but don’t load it. You might do this to read in initial application Registry values. After that, any references to control properties on the form

I needed a printed catalog of GIF images in a directory. So I wrote a routine that creates a new document, and inserts an image for each GIF file in

When you implement the Always on Top feature with VB forms using SetWindowPos and HWND_TOPMOST, message boxes are shown below the topmost form. To overcome this, you can use the

Question: I want to display the “Enter Network Password” box when a user accesses my site. I can display an ActiveX control on my HTML page (ObjectID Tag) but it

Question: How do I strip off leading zeros from data displayed from an ASP page? Answer: Use the FormatNumber function.If value = “0000046” Then FormatNumber(value,0) will result in 46. FormatNumber(value,2)

Question: How do I retrieve all the table names from an Access database using ASP? Answer: Make sure you have an ODBC DSN to point to your database. Then use

Question: I have a date field on my ASP page. I want to restrict the user for entering only the dates in his Windows 95 machine’s date format. How can

Question: When I create an ASP page that gets sent to the browser, if users press the refresh button they get a message asking to repost from old data. How

Question: How can I show a ‘Loading…’ message till my ASP page loads? Answer: Use the following code to create a “pgLoading.asp” page. Pass to it as a parameter the

Question: I am querying an Oracle field that comes back in the format of 25.5. Because this is a currency field, I’d like to manipulate it so that it shows

Question: I have a session variable that keeps track of a user name and is set through a login page. Every page in the application first checks for the session

Question: How do I create a directory in ASP? Answer: Use the ‘CreateFolder’ method of the FileSystemObject object. Set fs = Server.CreateObject(“Scripting.FileSystemObject”)fs.CreateFolder (“foldername”) Obviously, you need to have proper permissions

Question: I have been testing the delivery of ASP pages versus HTML pages and found that there is a considerable difference (ASP = 1 per sec / HTML = 187

Question: How do I generate numbers at the server end? I have an application in which I am accessing data from an Access database and I want to define each