Core functions

Public Function DateTimeToSQLText(d) As String

Convert a date and time to text suitable for use in an SQL query, including date delimiters. Uses the DbConnect object's SQLStatementFormat setting to determine the correct Jet or MSSQL date delimiters

Public Function DateTimeToSQLTextWithDelimiterFormat(d, AsFormat As xf_SQLStatementFormatEnum) As String

Convert a date and time to text suitable for use in an SQL query, including date delimiters. The user passes an SQLStatementFormat setting to determine the correct Jet or MSSQL date delimiters The date passed is a variant, and a Null value returns the string: NULL

Public Function DateToSQLText(d, Optional DateBoundary As xf_DateBoundaryEnum = 1) As String

Convert a date to text suitable for use in an SQL query, including date delimiters. Returns text dates (eg. 21 Nov 2011) so that the information is unambiguous. JET SQL always assumes U.S. date format (eg. mm/dd/yyyy) even though the query editor will display the date in your regional format.
# is used to delimit dates in JET, and ' in MSSQL The date passed is a variant, and a Null value returns the string: NULL

Public Property Get LastErrWasDuplicateError() As Boolean

Did the last method call throw an error due to a duplicate key value ?

Public Property Get LastMethodCausedError() As Boolean

Did the last method call throw an error ?

Public Function OpenADORecordset(Source As String, Optional RSType As CursorTypeEnum = adOpenUnspecified, Optional LockEdit As LockTypeEnum = adLockUnspecified, Optional OpenRSOptions As Long = -1, Optional SuppressError As Boolean = False) As ADODB.Recordset

Opens an ADO Recordset object against the current database connection.


Public Function OpenDAORecordset(Source As String, Optional RSType As RecordsetTypeEnum = -1, Optional OpenRSOptions As RecordsetOptionEnum = -1, Optional LockEdit As LockTypeEnum = -1, Optional SuppressError As Boolean = False) As DAO.Recordset

Opens a DAO Recordset object against the current database connection.


Public Function ReturnRec(sqlStr As String, Optional DebugOn As Boolean = False, Optional SuppressError As Boolean = False) As Variant

Returns the value from the first column and row of the result set from the passed SQL. Like DLookup, but takes a full SQL statement.


Public Function RunSQL(sqlStr As String, Optional SuppressError As Boolean = False, Optional DebugOn As Boolean = False) As Boolean

Run the passed SQL, returning False if an error occurred.
Uses the database Execute() method, known to be more reliable than the Docmd.RunSQL method, and supports running against databases other than the current one.