MS Access Tutorial: Displaying an alert message when recordset returns no value

Background: To make the user interface more friendly in nature it’s a good approach displaying an Alert Message when MS Access Query returns no value to its corresponding recordset. How To: By using the MS Access RecordsetClone and RecordCount Property we can return a message with an empty recordset. If Me.RecordsetClone.RecordCount <= 0 Then MsgBox (“No records…

WordPress Tutorial: Change WordPress Site URL

Background: It might be needed to change WordPress site URL  for example from http://domain.com to http://www.domain.com and vice versa. Workaround: My test blog’s original site URL was http://tutorial.kaysariqbal.com; intend to prefix the site with www so the site will look like http://www.tutorial.kaysariqbal.com. To make Change WordPress Site URL i had to work on cPanel of…

Oracle Tutorial: Using single-row or multiple-row functions to customize output

This Oracle Tutorial: Using single-row or multiple-row functions contains the lessons mentioned below: Types of SQL Functions Single Row Functions Number Functions Character Functions Date Functions Conversion Functions General Functions Multiple Row/Aggregate Functions Restricting Group results With HAVING Clause Nesting Group Functions Download: Using single-row or multiple-row functions to customize output

Oracle Tutorial: SQL SELECT Statements

I had to arrange training session over Database Management System to my colleagues which used oracle as backend. This “Oracle Tutorial: SQL SELECT Statements” is about basics of DBMS, SQL and SELECT statements. Includes: Types of SQL statement Arithmetic Operators and Precedence Null Values Column Alias Concatenation Operator/Literal Character String Duplicate Rows/DISTINCT keyword Download: SQL Select…