Popular Tags on WebCheatSheet

Search

or browse popular tags

Subscription

Sign up for the free email newsletter for new tips, tutorials and more. Enter your email address below, and then click the button.

All pages tagged ACCESS

Access: Format Function

In Access, the Format function returns a string containing an expression formatted according to instructions contained in a format expression. More...

Tags: ACCESS FUNCTION FORMAT EXPRESSION Hits: 166508 Comments: 6

Access: IIF Function

In Access, the IIF function returns one of two arguments depending on the evaluation of an expression. More...

Tags: ACCESS FUNCTION IIF EXPRESSION Hits: 79170 Comments: 0

Access: Date Function

In Access, the Date function returns the current system date. More...

Tags: ACCESS FUNCTION DATE SYSTEM CURRENT Hits: 63298 Comments: 0

ASP: How to connect to database using a connection string

The power of Active Server Pages comes through when we tie databases to our web sites. To connect to a database, ASP uses what is called ActiveX Data Objects, or ADO for short. ADO comes with ASP, and can be used easily from your ASP pages. In this tutorial we will show you how to connect to our Access database and retrieve all the records from the table. More...

Tags: ASP CONNECTION DATABASE ADO ACCESS OLEDB ODBC SQL RETRIEVE PRINT Hits: 62262 Comments: 2

MS Access Connection Strings

MS Access ODBC and OLEDB connection strings More...

Tags: ACCESS ODBC OLEDB CONNECTION STRING Hits: 62232 Comments: 0

Access: DateDiff Function

In Access, the DateDiff function returns the number of time intervals between two dates. More...

Tags: ACCESS FUNCTION DATEDIFF TIME INTERVAL DATE Hits: 58980 Comments: 0

Access: Replace Function

In Access, the Replace function returns a string in which a sequence of characters has been replaced with another set of characters a specified number of times. More...

Tags: ACCESS FUNCTION REPLACE SEQUENCE SET CHARACTERS Hits: 49116 Comments: 4

Access: Count Function

In Access, the Count function calculates the number of records in a select query. More...

Tags: ACCESS FUNCTION COUNT QUANTITY RECORDS SELECT QUEY Hits: 47522 Comments: 0

Access: DatePart Function

In Access, the DatePart function returns the specified part of a given date. More...

Tags: ACCESS FUNCTION DATEPART PART DATE Hits: 43246 Comments: 0

Access: Left Function

In Access, the Left function returns the leftmost n characters of a string. More...

Tags: ACCESS FUNCTION LEFT Hits: 42796 Comments: 0

Access: Sum Function

In Access, the Sum function returns the sum of a set of values in a set of values in a select query. More...

Tags: ACCESS FUNCTION SUM SELECT QUERY VALUE Hits: 42440 Comments: 1

Access: Switch Function

In Access, the Switch function evaluates a list of expressions and returns a Variant value or an expression associated with the first expression in the list that is True. More...

Tags: ACCESS FUNCTION SWITCH LIST VARIANT EXPRESSION Hits: 41786 Comments: 4

Access: DateAdd Function

In Access, the DateAdd function Adds a specified time interval to a date. More...

Tags: ACCESS FUNCTION DATEADD TIME INTERVAL DATE Hits: 41384 Comments: 2

ADO and ADO.NET Connection Strings

Connection strings are string variables which contain database connection information and then passed to ADO which will interpret them and act accordingly. Since there are going to be passed to ADO, they need to be in a comprehensible for ADO format. This tutorial was created as an easy reference of various ADO and ADO.NET connection strings for the most popular database types. More...

Tags: ADO ADO.NET CONNECTION STRING REFERENCE DATABASE ACCESS MYSQL MSSQL ORACLE Hits: 38968 Comments: 0

Access: Mid Function

In Access, the Mid function returns a string containing a specified number of characters from a string. More...

Tags: ACCESS FUNCTION MID SPECIFIED NUMBER Hits: 36068 Comments: 0

Access: Month Function

In Access, the Month function returns an Integer between 1 and 12, inclusive, containing the month part of a date. More...

Tags: ACCESS FUNCTION MONTH RANGE DATE Hits: 34953 Comments: 0

Access: DateValue Function

In Access, the DateValue function returns the date represented by the date of a String argument. More...

Tags: ACCESS FUNCTION DATEVALUE DATE STRING Hits: 34453 Comments: 0

Access: IsNull Function

In Access, the IsNull function returns a boolean value that indicates whether or not an expression contains no valid data (Null). More...

Tags: ACCESS FUNCTION ISNULL VALID Hits: 32064 Comments: 1

PHP: DSN and DSN-less connections

DSN stands for 'Data Source Name'. It is an easy way to assign useful and easily rememberable names to data sources which may not be limited to databases alone. DSN-less connections don't require creation of system level DSNs for connecting to databases and provide an alternative to DSNs. This tutorial will show you how to connect to an Access database with a DSN and without a DSN. More...

Tags: PHP ACCESS DATABASE DSN DSN-LESS ADODB OLEDB DRIVER CONNECTION Hits: 29567 Comments: 0

Access: Int Function

In Access, the Int function returns the integer portion of a number. More...

Tags: ACCESS FUNCTION INT INTEGER NUMBER Hits: 28737 Comments: 0

Access: DateSerial Function

In Access, the DateSerial function returns the date for a specific year, month, and day. More...

Tags: ACCESS FUNCTION DATESERIAL DATE SPECIFIC DAY MONTH YEAR Hits: 28498 Comments: 0

Access: Year Function

In Access, the Year function returns an integer between 100 and 9999, inclusive, that represents the year of a date argument. More...

Tags: ACCESS FUNCTION YEAR RANGE REPRESENTATION DATE Hits: 28195 Comments: 0

Access: Trim Function

In Access, the Trim function returns a copy of a string with leading and trailing spaces removed. More...

Tags: ACCESS FUNCTION TRIM LEADING TRAILING SPACE REMOVE Hits: 28086 Comments: 0

Access: Chr Function

In Access the Chr function returns the character associated with the specified ANSI code. More...

Tags: ACCESS FUNCTION CHR ANSI CODE Hits: 26554 Comments: 0

Access: First Function

In Access, the First function return a field value from the first record in the result set of a query. More...

Tags: ACCESS FUNCTION FIRST RECORDSET RESULT Hits: 26291 Comments: 1

Access: Choose Function

In Access, the Choose function selects and returns a value from a list of arguments based on a given position. More...

Tags: ACCESS FUNCTION CHOOSE LIST ARGUMENTS Hits: 25220 Comments: 0

Access: StrConv FunctionAccess: StrConv Function

In Access, the StrConv function convert a string to upper case, lower case, proper case, or several other formats. More...

Tags: ACCESS FUNCTION STRCONV UPPERCASE LOWERCASE FORMAT CONVERT Hits: 25009 Comments: 0

Access: Max function

In Access, the Max function returns the maximum of a set of values in a select query. More...

Tags: ACCESS FUNCTION MAX MAXIMUM SELECT QUERY Hits: 24810 Comments: 0

Access: Str Function

In Access, the Str function returns string representation of a number. More...

Tags: ACCESS FUNCTION STR STRING REPRESENTATION Hits: 24317 Comments: 0

Access: Val Function

In Access, the Val function returns a variant indicating the sign of a number. More...

Tags: ACCESS FUNCTION VAL VARIANT INDICATE Hits: 22870 Comments: 0

Access: Right function

In Access, the Right function returns the rightmost n characters of a string. More...

Tags: ACCESS FUNCTION RIGHT CHARACTERS Hits: 22138 Comments: 0

Microsoft Access Specifications and Limitations

Just as any application, MS Access has specifications and limitations that should be remembered. The following tables specify the maximum sizes and numbers of various objects defined in Microsoft Access databases. More...

Tags: ACCESS SPECIFICATIONS LIMITATIONS NUMBER SIZE LENGTH Hits: 21543 Comments: 2

Access: Day Function

In Access, the Day function returns an integer between 1 and 31, inclusive, that represents the day of the month corresponding to the date provided as an argument. More...

Tags: ACCESS FUNCTION DAY INCLUSIVE RANGE Hits: 21392 Comments: 0

Access: Last Function

In Access, the Last function return a field value from the last record in the result set of a query. More...

Tags: ACCESS FUNCTION LAST RESULT RECORDSET QUERY Hits: 21293 Comments: 0

Access: Asc Function

In Access, the Asc function returns an integer representing the ANSI code corresponding to the first character in a string. More...

Tags: ACCESS ASC FUNCTION ANSI CODE Hits: 19894 Comments: 0

Access: Round Function

In Access, the Round function returns a number rounded to a specified number of decimal places. More...

Tags: ACCESS FUNCTION ROUND SPECIFIED DECIMAL Hits: 19876 Comments: 1

Access: Now Function

In Access, the Now function returns the current date and time according your computer's system date and time. More...

Tags: ACCESS FUNCTION NOW CURRENT DATE TIME SYSTEM Hits: 19783 Comments: 0

Access: Time Function

In Access, the Time function returns the current system time. More...

Tags: ACCESS FUNCTION TIME CURRENT SYSTEM TIME Hits: 19565 Comments: 0

Access: Avg function

In Access, the Avg function calculates the arithmetic mean of a set of values in a select query. More...

Tags: ACCESS FUNCTION AVG ARITHMETIC_MEAN SELECT QUERY Hits: 19322 Comments: 0

ASP: How to connect to database with a DSN

DSN stands for 'Data Source Name'. It is an easy way to assign useful and easily rememberable names to data sources which may not be limited to databases alone. In this tutorial we will show you how to connect with a DSN to an Access database called 'examples.mdb' and retrieve all the records from the table. More...

Tags: ASP CONNECTION DATABASE DSN ACCESS RECORDS TABLE ADODB SERVER.CREATEOBJECT RECORDSET Hits: 19277 Comments: 2