Weekday()
Returns a value 1–7 representing the day of the week. The optional firstdayofweek argument specifies the first day of the week; the default is Sunday. The firstdayofweek option in IDEAScript does not seem to work.
- Read more about Weekday()
- Log in or register to post comments
FormatDateTime(Date, NamedFormat)
Date is the date expression to be formatted. NamedFormat is an optional constant that specifies how the date is formatted.
- Read more about FormatDateTime(Date, NamedFormat)
- Log in or register to post comments
Static Arrays
A static array has a fixed size or number of elements. You specify the array size when you declare it, and the size cannot change during program execution. The size will be one more than n because VBA array indexes start by default at 0.
You can use an integer variable or constant as the index.
- Read more about Static Arrays
- 2 comments
- Log in or register to post comments
Dynamic Arrays
A dynamic array does not have a fixed size. It can be enlarged or shrunk as needed by code during program execution. A dynamic array is declared by using empty parentheses in the Dim statement.
Before using the array, you must set its size using the ReDim statement.
- Read more about Dynamic Arrays
- 6 comments
- Log in or register to post comments
Display the filename in a text field
This function will update a text field with a file name selected from within a custom menu.
- Read more about Display the filename in a text field
- 4 comments
- Log in or register to post comments
Populate Primary field List
This function will populate an array with information that can be used in a field list for a custom menu.
- Read more about Populate Primary field List
- Log in or register to post comments
Verify if integer
This if ... then statment will verify if a string inputed from a custom function is an integer
- Read more about Verify if integer
- Log in or register to post comments
Get the field name
This function will get a field name of a field given its location within the database. If the location is -1 it will default to the last field name.
I have updated the script, it now uses 0 to find the last entry and negative numbers to find the field name starting from the right.
- Read more about Get the field name
- Log in or register to post comments
Check if field name exists
This routine will check to see if a field name exists and if it the field name already exists then it will return a field name that does not exist by adding a 1 to the end of the field name.
- Read more about Check if field name exists
- 7 comments
- Log in or register to post comments
Get no of records
This function will get the number of records in a database.
- Read more about Get no of records
- Log in or register to post comments