There are a few tricks that you can do with LCase$ and UCase$ functions. I doubt you will be using this tip in all your applications, but here they are

‘ Retrieve a file’s path” Note: trailing backslashes are never included in the resultFunction GetFilePath(FileName As String) As String Dim i As Long For i = Len(FileName) To 1 Step

‘ Return the extension of a file nameFunction GetFileExtension(ByVal FileName As String) As String Dim i As Long For i = Len(FileName) To 1 Step -1 Select Case Mid$(FileName, i,

The standard way to move a captionless form is to execute some tricky code from within the MouseDown event procedure. More advanced VB developers can reach the same result by

‘ Make a complete file name by assemblying its individual parts’ if Extension isn’t omitted, it overwrites any extension held in BaseNameFunction MakeFileName(Drive As String, Path As String, BaseName As

‘ Retrieve a file’s base name’ if the second argument is true, the result include the file’s pathFunction GetFileBaseName(FileName As String, Optional ByVal IncludePath As _ Boolean) As String Dim

One of Internet Explorer 5.0’s new features is AutoComplete. If turned on by the user (it’s off by default) it helps users fill in the frequently used fields–like username, first

Swing’s JComboBox can be used to present a drop-down list, perhaps of status reports from a process, requiring minimal screen space until the user wishes to see the details. But

When architecting a client-server or n-tier application, you should decide on a particular locking technique and accordingly the transaction isolation level and concurrency control strategy for database transactions. This decision

The words argument and parameter are often used interchangeably in the literature, although the C++ Standard makes a clear distinction between the two. An argument is one of the following:

If you turn the mouse pointer into an hourglass (and back to normal) in a routine with error handling, don’t forget to turn the mouse pointer back to normal in

If there is no user-declared constructor in a class, and the class does not contain const or reference data members, the implementation implicitly declares a default constructor for it. An

Beginners often run into permissions problems as soon as they try to write data to a database driven Web site using Access and Internet Information Server (IIS). A common error

To execute a stored procedure in all databases of SQL Server, you should create the candidate stored procedure in the master database and pass it as a parameter to the

The Visual InterDev 6 Style Sheet editor is confusing about the tags that can be edited. For example, the A:hover style is missing from the list of tags. A:hover is

Java does not offer arrays that can be extended at run time, for primitives or Objects, so it is common to use a Vector for a set of elements that

Question: Summary of the problem: Connecting directly to a Microsoft Access database from a Web project developed in Interdev 6.0 fails unless I modify every .Open to use a connection

Question: I need the following simple script. Visitors should be able to enter their e-mail address in a form on my site and the address should be put in a

Question: I have an ActiveX (MyKalender.ocx) and I know the ClassID of, I included it to an ASP-File -> I can see it but how can I get information about

Question: I have built an ASP-based banner system using the Ad Rotator component. How can I log this information into a database (prefer) and retrieve the number of impressions and

Question: I am using a combination of HTML and ASP pages to pull data from a database. I use one HTML page to request the info with a form, which

Question: How can I do a dynamic include, such as:However, I think I know why this doesn’t work– because includes are tossed in before it goes to the parser (asp.dll).

Question: I’ve made an ActiveX-DLL using VB6 with one public and several private functions.How can I use (and call) the public function from an Active Server Page?? Answer: Invoke your

Question: I would like to ask about uploading a file using HTML. I have the code, but the problem is that I can not receive and save the file that

Question: I have a .htm file in which I have the following line of code: The htm pages are both part of my VI6 project.The file IncludeLeftPanel.htm contains only simple

Question: I have an ASP file residing on a Web server. Is there any way that I can execute this file from within my VB application? This should be similar

Visual InterDev 6 offers a quick way to convert tabs to spaces in your HTML code. Select the area of code in which you want to remove the tabs and

You can achieve case sensitive comparison of strings in queries by converting strings to the binary or varbinary datatype. You cannot achieve this with simple string comparisons if you have

On the printed page, people are accustomed to seeing portions that have been marked by a highlighter–you can achieve the same effect with HTML highlight text on your Web page

If you’re using Microsoft Transaction Server technology, opening up MTS explorer and using refresh is an overhead on the system compared to command line options. Instead, you can use “mtxstop”,