devxlogo

The Latest

How do I get the TextBox to display

Question: How do I get the TextBox to display automatically at the end of text, instead of at the begining of the text? Answer: The answer is very simple. All

User ID Scripts

Question: I need to write a script that tells me the last user_id entered on a table and then another script in order to allow me (or a user) to

Problem Using Execute SQL in Microsoft Query

Question: In Microsoft Query I can’t seem to use the Execute SQL function. I’m learning SQL from a book called The ColdFusion 4.0 Web Application Construction Kit (Macmillan, 1998). The

Display the “Shut down Windows” dialog

To programmatically display the “Shut down Windows” standard dialog box you can use the SHShutDownDialog undocumented API function, whose declaration is: Declare Function SHShutDownDialog Lib “shell32” Alias “#60” (ByVal lType

Hide or disable the desktop icons

The Desktop is a window like any other window in the system, so you can hide/show and enable/disable it. The only details you need to know is how to retrieve

Format a drive using an undocumented function

SHFormatDrive is an undocumented but simple API function that allows you to format a drive. This function simply opens “Format Drive” diaolog window. Being undocument you won’t find its Declare

Add pizazz to your apps with an animated cursor

Who said you can’t use an animated cursor with Visual Basic? Actually, it’s so simple! You just have to load your animated cursor through LoadCursorFromFile API function, then you get

Hide or disable the Windows’ application bar

The Windows’ application bar (or Startbar) is a window like any other window in the system, so you can hide/show and enable/disable it. The only thing you need to know

How to apply the flat style to a toolbar

All recent Windows applications use a flat toolbar similar to Internet Explorer ‘s and Microsoft Word’s ones. Visual Basic 6 includes a Toolbar control that supports the flat look, but

Get IP Address Via The Hostname

The class java.net.InetAddress represents an Internet Protocol (IP) address. You can use this class to find the IP address of a host using the hostname. The following code demonstrates this:

Get the Hostname via IP Address

The class java.net.InetAddress represents an Internet Protocol (IP) address. You can use this class to find the hostname of an IP address. The following code demonstrates this: try{ java.net.InetAddress inetAdd

Using URLEncode to Pass Query String Values

Question: I’m passing a string from one ASP template to another. The string may contain spaces so I call URLEncode, which works well as far as preventing the 400 Error

Access Legacy Data on Mainframe

Question: How do you access data on a mainframe using ASP? Answer: It depends on your mainframe application. If there is a way to connect to the data via ODBC

Format a Date as mm/dd/yyyy

Question: I need a VBScript function that will format a date as mm/dd/yyyy. The FormatDateTime function does not give me this option and the CDate function wants to convert everything

Programmatically Force a Save As Dialog Box

Question: Is it possible to force the file download box to appear through ASP? I want to create a file on the fly with the response.write method to fill its

Read Content From a Remote URL

Question: How can I read the content of an HTML page from another URL? I tried using the FileSystemObject by providing the virtual path, but it says http permission is

Read Metadata With OpenSchema

Question: How do I read the names of tables and fields in an Access database? I tried OpenSchema, but I got the error, “The operation requested by the application is

Properly use Underscores with LIKE in a WHERE Clause

Underscores signify a single character in SQL language. Using LIKE for underscores will returns all values for ‘x’ whether they contain an underscore or not. Therefore, usage as shown below

Enumerate a Dictionary Object

Although the Dictionary object does not have an enumerator, it does have an Items method that returns a Variant array. You can use the For…Each construct on the array: Dim

Find the Last Modified Date of a Web Page

Microsoft’s Internet Transfer Control (MSInet.ocx) is a great tool to use to automate the Web. However, how do you know you’re looking at an updated version of a Web page?