Command

Category

Discription

Abs

maths function

Absolute value

Add method

Collection Object

Adds item to collection Object

Beep

Miscellaneous

makes a beep on PC Speaker

Boolean

Variable Types

Byte

Variable Types

case

Program Flow Control Case

Condition in case for switching

CByte

Conversion Functions Byte

convert to a Byte

CCur

Conversion Functions Currency

convert to Currenct

Cdbl

Conversion Functions

CDbl

Conversion Functions Double

convert ti double floating point

Cdec

Conversion Functions Decimal

Convert to decimal

ChDir

File Directory Functions

Changes default directory

ChDrive

File Directory Functions

Change default selected drive

Choose

Program Flow Control

Returns a value from a list

Chr

String Functions

returns a character

chr$(

String Functions

returns a character

Cint

Conversion Functions Integer

Convert given expression to integer

Clng

Conversion Functions

CLng

Conversion Functions Long

Convert to Long Integer

Close #n

Sequential Files

Close file

Command

Program Flow Control

returns commands passed to VB when executed

CommitTrans

Database Functions

Commit transcaction to database

Count Property

Collection Object

Returns Number of items in the collection

CSng

Conversion Functions Single (float)

Convert to a single prescision floating point number

Cstr

Conversion Functions

CStr

Conversion Functions String

Convert expression to a string

CurDir

File Directory Functions

Return the current path for a file

Currency

Variable Types

Cvar

Conversion Functions Variant

Convert to Variant

CVDate

Date Functions

Convert expression to Date type

Date

Date Functions

Returns the current date of system

Date

Date Functions

Sets the current Date of system

Date

Variable Types

DateAdd

Date Functions

Adds an amount to date

DateDiff

Date Functions

Determins the difference between two dates

DatePart

Date Functions

returns part of the date secified by interval string

DateSerial

Date Functions

Returns a date type for specified values

DateValue

Date Functions

Converts an expression to date type

Day

Date Functions

returns day value from a date argument

Dim

Arrays

Sets the size of the array

Dim

Collection Object

Dim

Variable Properties

defines a variable

Dir

File Directory Functions

returns the name of file or path specified by pattern

Do

Program Flow Control Do Loop

Start of Do loop

Do until

Program Flow Control Do Until Loop

Start of Do until loop

Double

Variable Types

Else

Program Flow Control If

start of alternative condition in if structure)

End

Program Flow Control

Halts execution of program

End For All

Program Flow Control For Loop

end of for all loop

End Function

Procedures Function

The end of the function

end select

Program Flow Control Case

End of the case switch

End Sub

Procedures Sub

The end of a subroutine

End Type

User defined Types (records)

Endif

Program Flow Control If

end of if

Environ

Miscellaneous

returns info on current enviroment

EOF

Sequential Files

returns true if End Of File found

Eqv

Math Functions

performs a bitwise AND on two numeric expressions

Erase

Arrays

Clears the current array

Err object

Error Handling

Contains info about error

Error

Error Handling

returns error message

Exit

Program Flow Control

terminates the current operation before conditions complete

Exp

Math Functions

Exponent (Natural Log)

False

Math Functions

a value returned if condition is false

FileAttr

File Directory Functions

returns the modeof a file

FileCopy

File Directory Functions

copies a file to the destination path

FileDateTime

File Directory Functions

returns date time when file was last modified

FileLen

File Directory Functions

returns the length of a file in bytes

Fix

Conversion Functions

returns an integer of passed value

For .. To

Program Flow Control For Loop

Start of For loop

For All

Program Flow Control For Loop

start of for all loop

Format

Date Functions

returns a formatted date/time

Function

Procedures Function

The definition of the function

Get

Sequential Files

retrieves from open file

Get #n,4,emp1

Random Files

get filenr recnr varname

GetAttr

File Directory Functions

returns the attributes of a given file

Hide

Form Functions

Hour

Date Functions

returns the hour portion of the date and time valie

If

Program Flow Control If

start of if

IIf

Program Flow Control

if expression true return firstvalue else return second value

Imp

Math Functions

A bitwise comparison between two values

input #n

Sequential Files

reads a single line from a sequential file

Inputbox

User prompt

prompt user for input

InStr

String Functions

returns position of search string in string tested

Integer

Variable Types

IsDate

Tests for date

returns true if value contains date

IsEmpty

Tests for empty variable

determins if a variable is empty

IsNull

Tests for empty string

determins if a variable contains a Null

IsNumeric

Tests If Numeric

determins if a variable contains a Numeric value

Item method

Collection Object

Returns an item from the collection

Kill

File Directory Functions

deletes a specified file

KillPath

File Directory Functions

LBound

Arrays

Returns the lowest subscript in an array

Lcase

String Functions

Returns a all lower string

Left

String Functions

returns the left portion of a string

Len

String Functions

Returns the length of a string

LenB

String Functions

Returns the length of a string in Bytes

Like

String Functions

Compares a string to a pattern

Line Input #n

Sequential Files

reads a single line from a sequential file

Load

Form Functions

Loc

Random Files

sets the current read write position of an open file

Lock..Unlock

Random Files

locks access to part of a file for other processes

LOF

Sequential Files

Returns the length of open file

Log

Math Functions

return natural log of argument

Long

Variable Types

Loop

Program Flow Control Do Until Loop

End of do until loop

Lset

String Functions

Left justifies a string filling remainder with spaces

Ltrim

String Functions

returns a string with left leading spaces removed

Me

Form Functions

Returns current active form

Mid

String Functions

returns a substring of a string

Minute

Date Functions

Returns the minute portion of the date

MkDir

File Directory Functions

creates a directory

Mod

Maths Functions

return the Modulus of an argument

Month

Date Functions

returns the month portion of the date part

MsgBox

User prompt

Displays a message box

Msgbox

User prompt

Message prompt to user (can also be used as a prompt)

Name

File Directory Functions

rename file or directory

Next ..

Program Flow Control For Loop

end of for loop

Now

Date Functions

Returns current date & time

Now

Date Functions

returns the current date & time of system

Object

Variable Types

Database, Recordset

Oct

Conversion Functions Octal

converts an expression to octal

On Error

Error Handling

traps errors to a error handler

On Gosub

Program Flow Control

conditional call subroutine

On Goto

Program Flow Control

conditional jumps

Open

Sequential Files

opens a file

Open … for input/append… Shared as #n

Sequential Files

opens a file

Open … for random… as #n

Random Files

opens a random file for read & write

Option Base

Arrays

sets the default lowerbound of an array

Option Compare

String Functions

sets the comparison method for strings

Option Explicit

Variable Properties

requires that all variables be explicitly defined

Partition

String Functions

returns a string denoting where the passed number occurs within the ranges

Print #n

Sequential Files

writes to a sequential file

Print #n

Sequential Files

Private Function

Procedures Function

The definition of the Private function

Private Static Sub

Procedures Sub

The definition of a static subroutine

Private Sub

Procedures Sub

The definition of a Private subroutine

Private Type

User defined Types (records)

Public Function

Procedures Function

The definition of the Public function

Public Sub

Procedures Sub

The definition of a Public subroutine

Public Type

User defined Types (records)

Put Put #n

Sequential Files

writes a variable to current file

put #n

Random Files

writes variable to disk

QBColor

Colour functions

returns a long colour value

Randomize

Math Functions

initialize a random number seed

Redim

Arrays

redimentions a dynamic array

Redim Preserve

Arrays

Re-sizes the array keeping existing data

Remove method

Collection Object

Removes an item from the collection

Reset

Sequential Files

closes all open files

Resume

Program Flow Control

resume execution after error trapping

Return

Program Flow Control

returns for a gosub within a subroutine

RGB

Colour functions

returns a long value representing the RGB values

Right

String Functions

returns a substring of a string

Rmdir

File Directory Functions

removes a directory

Rnd

Math Functions

returns a random number

Rollback

Database Functions

Aborts or un-commits a database transaction

Rset

String Functions

Right justifies a string filling remainder with spaces

Rtrim

String Functions

returns a string with right leading spaces removed

SavePictures

Miscellaneous

saves the graphic stored in a picture

Second

Date Functions

returns the second portion of the date

Seek

Random Files

returns the current position of an open file

Seek #n,4

Random Files

seek filenr recnr

Select Case

Program Flow Control Case

Defines the case switch

SendKeys

Form Functions

sends keystrokes to the active windows

SetAttr

Sequential Files

sets the attributes of a file

SetDataAccess

Database Functions

Sets the location of the current workgroup setting for a database

SetDefaultWorkspace

Miscellaneous

sets the default user name and password for accessing secure database

Sgn

Math Functions

returns the sign of a number -1 or +1 or 0

Shell

Program Flow Control

executes a command at the command prompt

Show

Form Functions

makes current window visible

Show

Form Functions

Sin

Math Functions

Sine of an angle (in radians)

Single

Variable Types

Space

String Functions

returns a string with a number of spaces

Spc

String Functions

adds spaces for formatting

Sqr

Math Functions

square root

Static

Variable Properties

makes a variable persistent after procedure has completed

Stop

Program Flow Control

stops execution of a program

Str

Conversion Functions String

converts to a string

Str

String Functions

returns a string from a value

StrComp

String Functions

compares two strings

string

Conversion Functions

creates a repeting string of specified character

String

Variable Types

String *

Variable Types

Fiixed length string

StrReverse

String Functions

Tab

String Functions

adds a tab to format a string

Time

Date Functions

returns time

Time

Date Functions

sets the current system time

Timer

Miscellaneous

returns the number of seconds since midnight

TimeSerial

Date Functions

returns a time based on serial parameters passed to it

TimeValue

Date Functions

creates a date type holding a specified time

Trim

String Functions

strips leading & trailing spaces

UBound

Arrays

returns the highest subscript available in an array

Ucase

String Functions

Returns a all upper string

Unload

Form Functions

Val

Conversion Functions Value

returns the value of a string

Variant

Variable Types

Weekday

Date Functions

returns the weekday portion of the passed data type

Wend

Program Flow Control While loop

end of while loop

While

Program Flow Control Do Loop

End of Do loop

While

Program Flow Control While loop

Start of while loop

Width #n

Sequential Files

sets a width for the output file

Write #n

Sequential Files

writes data to a specified open file

Year

Date Functions

returns the year portion of the date type