Perform a comparison based upon information contained in the database where the comparison is to be performed.
Date and Time Constants
Constant
Value
Description
vbSunday
1
Sunday
vbMonday
2
Monday
vbTuesday
3
Tuesday
vbWednesday
4
Wednesday
vbThursday
5
Thursday
vbFriday
6
Friday
vbSaturday
7
Saturday
vbFirstJan1
1
Use the week in which January 1 occurs (default).
vbFirstFourDays
2
Use the first week that has at least four days in the new year.
vbFirstFullWeek
3
Use the first full week of the year.
vbUseSystem
0
Use the date format contained in the regional settings for your computer.
vbUseSystemDayOfWeek
0
Use the day of the week specified in your system settings for the first day of the week.
Date Format Constants
Constant
Value
Description
vbGeneralDate
0
Display a date and/or time. For real numbers, display a data and time. If there is no fractional part, display only a date. If there is no integer part, display time only. Date and time display is determined by your system settings.
vbLongDate
1
Display a date using the long date format specified in your computer's regional settings.
vbShortDate
2
Display a date using the short date format specified in your computer's regional settings.
vbLongTime
3
Display a time using the long time format specified in your computer's regional settings.
vbShortTime
4
Display a time using the short time format specified in your computer's regional settings.
File Input/Output Constants
Constant
Value
Description
ForReading
1
Open a file for reading only. No writing to this file can take place.
ForWriting
2
Open a file for writing. If a file with the same name exists, its previous contents are overwritten.
ForAppending
8
Open a file and write to the end of the file.
String Constants
Constant
Value
Description
vbCr
Chr(13)
Carriage return
vbCrLf
Chr(13) & Chr(10)
Carriage return–linefeed combination
vbFormFeed
Chr(10)
Form feed; not useful in Microsoft Windows
vbLf
Chr(10)
Line feed
vbNewLine
Chr(13) & Chr(10) or Chr(10)
Platform-specific newline character; whatever is appropriate for the platform
vbNullChar
Chr(0)
Character having the value 0
vbNullString
String having value 0
Not the same a zero-length string (""); used for calling external procedures