Results for "Author: matt roberts"

This article attempts to explain the Microsoft Jet collections and how you can use them in really useful ways. If you don't know about Jet collections, this is well worth reading.

Explains the basics of using the Dir() command to get file and folder information.

*REPOST* Sorry all...I left out a form file. This one should be good... Completely formats source code text...(adds white space, blocks). Fully customizable...add new commands, change formatting preferences, etc. Currently set up for VB, but can easily be customized to any language. This is a port from an add-in I wrote last year. Someone was asking about some code that did this that Ulli took off of PSC when he got mad and left. I never saw his code (probably better than mine) but since I had it, I decided to post it. This works surprisingly well. NOTE: This project is for DEMONSTRATION. It is a quick port from a VB add-in. Therfore, it may have some bugs...but I don't know of any.

This is very cool. For those of you who appreciate it, thanks. For those of you who are just looking for something to put down, move along. I don't want the coding award, so you don't need to try to make me look bad. WHAT IT DOES: This code allows you to utilize the Microsoft Word Spellchecker without having to open word. I am constantly typing something on the web (like right now) and I want to do a quick spell check...I have to open word, paste it in, check spelling, copy it, and then paste it back in the browser. This code automates that. Just copy it and run the app. The corrected results will end up in the clipboard ready to paste back in.... ALSO.... If you create a shortcut and place it in your SendTo folder, you can right-click on any text file and check the spelling. The result ends up in the clipboard. A little creativity and you can code a function to save it back in the corrected form. That is a little project for you. This project is a good example of how to use the Word objects from VB. Enjoy

Explains the basics of using collections in Visual Basic. These are a very powerful and often unused feature of VB.

Amazingly easy method for editing flex-grids in place. This is an example that I created to help someone out who needed to edit a flex-grid in place and didn't want to get a third party grid. It is a good starting point for a custom grid control. Good, bad or ugly, comments are always welcome. M@

Explains the basics of using the App Object.

To show the usage of the Chr() function.

Explains how to use the Visual Basic DateAdd() function to add and subtract dates.

Explains how to use the DatePart Function in Visual Basic.

04/28/2001 - Describes the usage of the Choose() function; A really neat but seldom used command in VB.

Automatically rescales a form to keep the layout identical at any size. For those of you out there who lock your forms to a certain size because rescaling is such a pain, give this a try...you will love it! NOTE: Although this code works as is, it is JUST AN EXAMPLE. You should be able to take the same logic and apply it to all of your forms, but please note that this example does not handle every type of control. For special controls (dbGrid, etc.) you will have to write a little code yourself to make it work.

Ever wonder how to create your own custom list of parameters for one of your functions? You know, like the MsgBox options list with items like vbQuestion, vbExclamation, etc? This article shows you how. It is easier than you might think.

This form can be used as a template for creating dynamic "Outlook" style forms in VB. Each frame resizes independently...and best of all, NO OCX!

Explains the concepts of Subs, Functions, and Parameters. If you are a little fuzzy on the difference, take a look.

Newest in the series aimed at teaching newbies (and not so newbies) about the commands that VB has available. This edition gives a basic outline of DateDiff() usage and, as always, some copt-and-paste sample code.

Makes it easy to perform a clean "Shell & Wait" where your applicatoin kicks off an external application and waits for it to return before continuing. Many shell & wait examples I have found tend to overdrive the proccessor in a loop or require you to make API calls. This one uses the Windows Script object to take advantage of it's built-in wait parameter on the .Run method...scripting's version of Shell.

Explains how to create your own custom variable packages that store various data types in one variable and display the elements in the IDE drop-down list while coding. This is a seldom used but very powerful data type in Visual Basic.

Follow up to my first article on User Defined Types. Shows how to really put them to work. If you liked the first one, you will LOVE this one.

Simple API call that tells whether or not a particular form is open. Useful for managing popup forms or a series of forms. Sample usage: If FormIsOpen("Color Picker") Then ' ....Do Something Here Else ' ...Do Something Else Here... End If