Home page
 
 Home 
 ASP 
 PHP 
 SQL 
 HTML 
 JavaScript 
 Search 
 Contact 
 
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.

Privacy Policy

RSS Twitter

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: 166512 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: 79174 Comments: 0

Access: Date Function

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

Tags: ACCESS FUNCTION DATE SYSTEM CURRENT Hits: 63302 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: 62277 Comments: 2

MS Access Connection Strings

MS Access ODBC and OLEDB connection strings More...

Tags: ACCESS ODBC OLEDB CONNECTION STRING Hits: 62236 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: 58984 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: 49120 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: 47526 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: 43250 Comments: 0

Access: Left Function

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

Tags: ACCESS FUNCTION LEFT Hits: 42800 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: 42444 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: 41794 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: 41388 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...

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: 36072 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: 34957 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: 34457 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: 32068 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: 29580 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: 28741 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: 28502 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: 28199 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: 28090 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: 26558 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: 26295 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: 25224 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: 25013 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: 24814 Comments: 0

Access: Str Function

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

Tags: ACCESS FUNCTION STR STRING REPRESENTATION Hits: 24321 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: 22874 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: 22142 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: 21547 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: 21396 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: 21297 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: 19898 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: 19880 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: 19787 Comments: 0

Access: Time Function

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

Tags: ACCESS FUNCTION TIME CURRENT SYSTEM TIME Hits: 19569 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: 19326 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...

Access: LTrim Function

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

Tags: ACCESS FUNCTION LTRIM LEADING SPACE REMOVE Hits: 18118 Comments: 0

Access: IsDate Function

In Access, the IsDate function returns a value indicating whether or not a variant argument can be converted to a date. More...

Tags: ACCESS FUNCTION ISDATE DATE INDICATE Hits: 17578 Comments: 0

Access: IsNumeric Function

In Access, the IsNumeric function returns a value indicating whether or not an expression can be converted to a numeric data type. More...

Tags: ACCESS FUNCTION ISNUMERIC INDICATE VALUE EXPRESSION Hits: 17561 Comments: 0

Access: Weekday Function

In Access, the Weekday function returns an integer between 1 (Sunday) and 7 (Saturday) that represents the day of the week corresponding to the date and the first day of the week provided as arguments. More...

Tags: ACCESS FUNCTION WEEKDAY RANGE REPRESENTATION DATE Hits: 17550 Comments: 0

Access: Len Function

In Access, the Len function returns the length of the specified string. More...

Tags: ACCESS FUNCTION LEN LENGTH STRING Hits: 17427 Comments: 0

Access: MonthName Function

In Access, the MonthName function returns a string containing the specified month. More...

Tags: ACCESS FUNCTION MONTHNAME SPECIFIED MONTH Hits: 17209 Comments: 0

Access: Abs Function

In Access, the Abs funtion returns the absolute value of a number. More...

Tags: ACCESS FUNCTION ABS ABSOLUTE VALUE Hits: 16035 Comments: 0

Access: Rnd Function

In Access, the Rnd function returns a single containing a random number. You can specify the random number to be a value between 2 user-specified numbers. More...

Tags: ACCESS FUNCTION RND RANDOM RANGE Hits: 15606 Comments: 0

Access: Fix Function

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

Tags: ACCESS FUNCTION FIX INTEGER NUMBER Hits: 15042 Comments: 0

Access: RTrim Function

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

Tags: ACCESS FUNCTION RTRIM TRAILING SPACE REMOVE Hits: 14590 Comments: 0

Access: Min function

In Access, the Min function returns the minimum of a set of values contained in a select query. More...

Tags: ACCESS FUNCTION MIN MINIMUM SELECT QUERY Hits: 14525 Comments: 0

Access: Exp Function

In Access, the Exp function returns a double specifying e raised to the nth power. The constant e is approximately 2.718282. More...

Tags: ACCESS FUNCTION EXP EXPONENT CONSTANT Hits: 14514 Comments: 0

Access: TimeValue Function

In Access, the TimeValue function returns the time represented by a string argument. More...

Tags: ACCESS FUNCTION TIMEVALUE REPRESENTATION TIME Hits: 14368 Comments: 1

Access: WeekdayName Function

In Access, the WeekdayName function returns the name of the day of the week corresponding to the date and the first day of the week provided as arguments. More...

Tags: ACCESS FUNCTION WEEKDAYNAME NAME DAY WEEK DATE Hits: 13837 Comments: 0

Access: UCase Function

In Access, the UCase function returns a string in which all letters of an argument have been converted to uppercase. More...

Tags: ACCESS FUNCTION UCASE UPPERCASE Hits: 13835 Comments: 0

Access: CurDir function

In Access, the CurDir function returns a string containing the full path of the specified drive. More...

Tags: ACCESS FUNCTION CURDIR PATH DRIVE Hits: 12280 Comments: 0

Access: Space Function

In Access, the Space function returns a string consisting of the specified number of spaces. More...

Tags: ACCESS FUNCTION SPACE QUANTITY Hits: 12018 Comments: 0

Access: LCase Function

In Access, the LCase function returns a Variant in which all letters of an argument have been converted to lowercase. More...

Tags: ACCESS FUNCTION LCASE LOWERCASE VARIANT CONVERT Hits: 11507 Comments: 0

Access: Hour Function

In Access, the Hour function returns a number between 0 and 23, inclusive, that represents the hour of the day corresponding to the time provided as an argument. More...

Tags: ACCESS FUNCTION HOUR RANGE TIME Hits: 11448 Comments: 0

Access: TimeSerial Function

In Access, the TimeSerial function returns the time for a specific hour, minute, and second. More...

Tags: ACCESS FUNCTION TIMESERIAL TIME SPECIFIC MINUTE SECOND Hits: 11256 Comments: 0

Access: FileDateTime Function

In Access, the FileDateTime function returns the date and time when a file was created or last modified. More...

Tags: ACCESS FUNCTION FILEDATETIME FILE DATE TIME CREATE MODIFY Hits: 11099 Comments: 0

Access: Atn Function

In Access, the Atn function returns a double containing the arctangent of a number. More...

Tags: ACCESS FUNCTION ATN ARCTANGENT Hits: 10694 Comments: 0

Access: Log Function

In Access, the Log function returns the natural logarithm of a number. The natural logarithm is the logarithm to the base e. The constant e is approximately 2.718282. More...

Tags: ACCESS FUNCTION LOG LOGARITHM NATURAL EXPONENT CONSTANT Hits: 9862 Comments: 0

Access: Sqr Function

In Access, the Sqr function returns the square root of a number. More...

Tags: ACCESS FUNCTION SQR SQUARE ROOT Hits: 9203 Comments: 0

Access: Sgn Function

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

Tags: ACCESS FUNCTION SGN VARIANT INDICATE SIGN Hits: 8505 Comments: 0

Access: Second Function

In Access, the Second function returns a number between 0 and 59, inclusive, representing the second of the minute of the hour. More...

Access: Minute Function

In Access, the Minute function returns an Integer specifying a whole number between 0 and 59, inclusive, representing the minute of the hour. More...

Tags: ACCESS FUNCTION MINUTE RANGE REPRESENTATION Hits: 7792 Comments: 0

Access: Cos Function

In Access, the Cos function returns a double containing the cosine of an angle. More...

Tags: ACCESS FUNCTION COS COSINE ANGLE Hits: 7552 Comments: 0

Access: Tan Function

In Access, the Tan function returns the tangent of an angle. More...

Tags: ACCESS FUNCTION TAN TANGENT ANGLE Hits: 6166 Comments: 0

Access: Sin Function

In Access, the Sin function returns the sine of an angle. More...

Tags: ACCESS FUNCTION SIN SINE ANGLE Hits: 6152 Comments: 0



Tags:

Add To: Add to dzone dzone | Digg this digg | Add to del.icio.us del.icio.us | Stumble it stumbleupon

  • Comments





Copyright © 2005-2014             www.WebCheatSheet.com All Rights Reserved.