Category

Command

Discription

Miscellaneous

Beep

makes a beep on PC Speaker

Miscellaneous

Environ

returns info on current enviroment

Miscellaneous

SavePictures

saves the graphic stored in a picture

Miscellaneous

SetDefaultWorkspace

sets the default user name and password for accessing secure database

Miscellaneous

Timer

returns the number of seconds since midnight

Arrays

Dim

Sets the size of the array

Arrays

Erase

Clears the current array

Arrays

LBound

Returns the lowest subscript in an array

Arrays

Option Base

sets the default lowerbound of an array

Arrays

Redim

redimentions a dynamic array

Arrays

Redim Preserve

Re-sizes the array keeping existing data

Arrays

UBound

returns the highest subscript available in an array

Collection Object

Add method

Adds item to collection Object

Collection Object

Count Property

Returns Number of items in the collection

Collection Object

Dim

Collection Object

Item method

Returns an item from the collection

Collection Object

Remove method

Removes an item from the collection

Colour functions

QBColor

returns a long colour value

Colour functions

RGB

returns a long value representing the RGB values

Conversion Functions

Cdbl

Conversion Functions

Clng

Conversion Functions

Cstr

Conversion Functions

Fix

returns an integer of passed value

Conversion Functions

string

creates a repeting string of specified character

Conversion Functions Byte

CByte

convert to a Byte

Conversion Functions Currency

CCur

convert to Currenct

Conversion Functions Decimal

Cdec

Convert to decimal

Conversion Functions Double

CDbl

convert ti double floating point

Conversion Functions Integer

Cint

Convert given expression to integer

Conversion Functions Long

CLng

Convert to Long Integer

Conversion Functions Octal

Oct

converts an expression to octal

Conversion Functions Single (float)

CSng

Convert to a single prescision floating point number

Conversion Functions String

CStr

Convert expression to a string

Conversion Functions String

Str

converts to a string

Conversion Functions Value

Val

returns the value of a string

Conversion Functions Variant

Cvar

Convert to Variant

Database Functions

CommitTrans

Commit transcaction to database

Database Functions

Rollback

Aborts or un-commits a database transaction

Database Functions

SetDataAccess

Sets the location of the current workgroup setting for a database

Date Functions

CVDate

Convert expression to Date type

Date Functions

Date

Returns the current date of system

Date Functions

Date

Sets the current Date of system

Date Functions

DateAdd

Adds an amount to date

Date Functions

DateDiff

Determins the difference between two dates

Date Functions

DatePart

returns part of the date secified by interval string

Date Functions

DateSerial

Returns a date type for specified values

Date Functions

DateValue

Converts an expression to date type

Date Functions

Day

returns day value from a date argument

Date Functions

Format

returns a formatted date/time

Date Functions

Hour

returns the hour portion of the date and time valie

Date Functions

Minute

Returns the minute portion of the date

Date Functions

Month

returns the month portion of the date part

Date Functions

Now

Returns current date & time

Date Functions

Now

returns the current date & time of system

Date Functions

Second

returns the second portion of the date

Date Functions

Time

returns time

Date Functions

Time

sets the current system time

Date Functions

TimeSerial

returns a time based on serial parameters passed to it

Date Functions

TimeValue

creates a date type holding a specified time

Date Functions

Weekday

returns the weekday portion of the passed data type

Date Functions

Year

returns the year portion of the date type

Error Handling

Err object

Contains info about error

Error Handling

Error

returns error message

Error Handling

On Error

traps errors to a error handler

File Directory Functions

ChDir

Changes default directory

File Directory Functions

ChDrive

Change default selected drive

File Directory Functions

CurDir

Return the current path for a file

File Directory Functions

Dir

returns the name of file or path specified by pattern

File Directory Functions

FileAttr

returns the modeof a file

File Directory Functions

FileCopy

copies a file to the destination path

File Directory Functions

FileDateTime

returns date time when file was last modified

File Directory Functions

FileLen

returns the length of a file in bytes

File Directory Functions

GetAttr

returns the attributes of a given file

File Directory Functions

Kill

deletes a specified file

File Directory Functions

KillPath

File Directory Functions

MkDir

creates a directory

File Directory Functions

Name

rename file or directory

File Directory Functions

Rmdir

removes a directory

Form Functions

Hide

Form Functions

Load

Form Functions

Me

Returns current active form

Form Functions

SendKeys

sends keystrokes to the active windows

Form Functions

Show

makes current window visible

Form Functions

Show

Form Functions

Unload

Math Functions

Eqv

performs a bitwise AND on two numeric expressions

Math Functions

Exp

Exponent (Natural Log)

Math Functions

False

a value returned if condition is false

Math Functions

Imp

A bitwise comparison between two values

Math Functions

Log

return natural log of argument

Math Functions

Randomize

initialize a random number seed

Math Functions

Rnd

returns a random number

Math Functions

Sgn

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

Math Functions

Sin

Sine of an angle (in radians)

Math Functions

Sqr

square root

maths function

Abs

Absolute value

Maths Functions

Mod

return the Modulus of an argument

Procedures Function

End Function

The end of the function

Procedures Function

Function

The definition of the function

Procedures Function

Private Function

The definition of the Private function

Procedures Function

Public Function

The definition of the Public function

Procedures Sub

End Sub

The end of a subroutine

Procedures Sub

Private Static Sub

The definition of a static subroutine

Procedures Sub

Private Sub

The definition of a Private subroutine

Procedures Sub

Public Sub

The definition of a Public subroutine

Program Flow Control

Choose

Returns a value from a list

Program Flow Control

Command

returns commands passed to VB when executed

Program Flow Control

End

Halts execution of program

Program Flow Control

Exit

terminates the current operation before conditions complete

Program Flow Control

IIf

if expression true return firstvalue else return second value

Program Flow Control

On Gosub

conditional call subroutine

Program Flow Control

On Goto

conditional jumps

Program Flow Control

Resume

resume execution after error trapping

Program Flow Control

Return

returns for a gosub within a subroutine

Program Flow Control

Shell

executes a command at the command prompt

Program Flow Control

Stop

stops execution of a program

Program Flow Control Case

case

Condition in case for switching

Program Flow Control Case

end select

End of the case switch

Program Flow Control Case

Select Case

Defines the case switch

Program Flow Control Do Loop

Do

Start of Do loop

Program Flow Control Do Loop

While

End of Do loop

Program Flow Control Do Until Loop

Do until

Start of Do until loop

Program Flow Control Do Until Loop

Loop

End of do until loop

Program Flow Control For Loop

End For All

end of for all loop

Program Flow Control For Loop

For .. To

Start of For loop

Program Flow Control For Loop

For All

start of for all loop

Program Flow Control For Loop

Next ..

end of for loop

Program Flow Control If

Else

start of alternative condition in if structure)

Program Flow Control If

Endif

end of if

Program Flow Control If

If

start of if

Program Flow Control While loop

Wend

end of while loop

Program Flow Control While loop

While

Start of while loop

Random Files

Get #n,4,emp1

get filenr recnr varname

Random Files

Loc

sets the current read write position of an open file

Random Files

Lock..Unlock

locks access to part of a file for other processes

Random Files

Open … for random… as #n

opens a random file for read & write

Random Files

put #n

writes variable to disk

Random Files

Seek

returns the current position of an open file

Random Files

Seek #n,4

seek filenr recnr

Sequential Files

Close #n

Close file

Sequential Files

EOF

returns true if End Of File found

Sequential Files

Get

retrieves from open file

Sequential Files

input #n

reads a single line from a sequential file

Sequential Files

Line Input #n

reads a single line from a sequential file

Sequential Files

LOF

Returns the length of open file

Sequential Files

Open

opens a file

Sequential Files

Open … for input/append… Shared as #n

opens a file

Sequential Files

Print #n

writes to a sequential file

Sequential Files

Print #n

Sequential Files

Put Put #n

writes a variable to current file

Sequential Files

Reset

closes all open files

Sequential Files

SetAttr

sets the attributes of a file

Sequential Files

Width #n

sets a width for the output file

Sequential Files

Write #n

writes data to a specified open file

String Functions

Chr

returns a character

String Functions

chr$(

returns a character

String Functions

InStr

returns position of search string in string tested

String Functions

Lcase

Returns a all lower string

String Functions

Left

returns the left portion of a string

String Functions

Len

Returns the length of a string

String Functions

LenB

Returns the length of a string in Bytes

String Functions

Like

Compares a string to a pattern

String Functions

Lset

Left justifies a string filling remainder with spaces

String Functions

Ltrim

returns a string with left leading spaces removed

String Functions

Mid

returns a substring of a string

String Functions

Option Compare

sets the comparison method for strings

String Functions

Partition

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

String Functions

Right

returns a substring of a string

String Functions

Rset

Right justifies a string filling remainder with spaces

String Functions

Rtrim

returns a string with right leading spaces removed

String Functions

Space

returns a string with a number of spaces

String Functions

Spc

adds spaces for formatting

String Functions

Str

returns a string from a value

String Functions

StrComp

compares two strings

String Functions

StrReverse

String Functions

Tab

adds a tab to format a string

String Functions

Trim

strips leading & trailing spaces

String Functions

Ucase

Returns a all upper string

Tests for date

IsDate

returns true if value contains date

Tests for empty string

IsNull

determins if a variable contains a Null

Tests for empty variable

IsEmpty

determins if a variable is empty

Tests If Numeric

IsNumeric

determins if a variable contains a Numeric value

User defined Types (records)

End Type

User defined Types (records)

Private Type

User defined Types (records)

Public Type

User prompt

Inputbox

prompt user for input

User prompt

MsgBox

Displays a message box

User prompt

Msgbox

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

Variable Properties

Dim

defines a variable

Variable Properties

Option Explicit

requires that all variables be explicitly defined

Variable Properties

Static

makes a variable persistent after procedure has completed

Variable Types

Boolean

Variable Types

Byte

Variable Types

Currency

Variable Types

Date

Variable Types

Double

Variable Types

Integer

Variable Types

Long

Variable Types

Object

Database, Recordset

Variable Types

Single

Variable Types

String

Variable Types

String *

Fiixed length string

Variable Types

Variant