List Files and Subfolders With the VBScript FileSystemObject
This article shows you how to write a VBScript that uses the FileSystemObject to list the files and subfolders in a folder on your computer. More ...
List Drives and Folders with the VBScript FileSystemObject
This article show you how to write a VBScript that uses the FileSystemObject to list the drives and folders on your computer. More ...
Five Common Mistakes Affecting Access Database Optimisation and Performance
Building an Access database requires some time, effort and ideally a good level of database knowledge. The assist tools Microsoft Access provides do not control some of the pitfalls most developers brush aside leading to a slow database. Here are the five common mistakes developers need to be aware of and handle accordingly. More ...
Three Main Principles of OOP (Object Oriented Programming)
Object Oriented Programming (OOP) is actually classified by three main principles: Encapsulation, Inheritance, and Polymorphism. These appear to be frightening terms but are actually fairly easy principles to grasp. More ...
Six Important Points When Importing Data Into An Access Database
Asking general users to import data into an Access database without knowing too muchabout how Microsoft Access works and they will become frustrated within minutes. The most desirable way of using external data is by importing or linking data to an Access table object. Once the data has been imported or linked, you treat it like any other data table and build your queries, forms and reports. More ...
Write Your Own VBScript HTA Text Editor
Because this application is designed for instructional purposes, I didn't design it with the conventional File drop-down menu. In order to show how menu items link to the code that performs each function, I just placed all the menu selections in the main menu. More ...
The Benefits of Microsoft Access Forms to Create a User Friendlier Database
Microsoft Access forms allows the use of data to be presented, managed and controlled in a user-friendly environment making Access more intuitive to use. Designing forms is critical for other users who will be responsible for the day-to-day running of a database and have very little knowledge of the structure of an Access database or its background processes. More ...
Reading and Writing Files with the VBScript FileSystemObject
The example code in this article uses the VBScript FileSystemObject and TextStream Object to read a text file and write a new text file, reformatting the text into lines a maximum of 90 characters long, except when that would break a word, then it extends the line length to include the entire word. More ...
Five Reasons Why You Should Consider Splitting a Microsoft Access Database
In the development and design mode, your Access database runs perfectly. But when you deploy the database, end-users complain that it's slow or it fails to respond. When you have concurrent users accessing your database, you may need to split an Access database and the following five reasons explain why. More ...
Introduction to Visual Basic 2005 Express
Because the Visual Basic Express IDE does so much "hand holding", within minutes of installing Visual Basic Express you where able to create a real, although tiny, Windows application. Building bigger more complex applications is just more of the same. More ...
