global $DB; $viewed_time = COption::GetOptionString("sale", "viewed_time", "90"); $viewed_time = IntVal($viewed_time); $strSql = "DELETE ". "FROM b_sa… Read More

Introduction.A very useful Command to transfer data between Microsoft Access and Excel using the Import/Export Options.  Here, we will concentrate on the Export aspect and what challeng… Read More

Problem : More fun with Client Access ODBC I have a table that causes the following error when I select more than 5187 records. Connectivity error: [IBM][Client Access Express ODBC Driver (3… Read More

Introduction.I hope you found, last week’s tutorial on ImageCombo Control  useful for your Microsoft Access Projects.  With the TreeView ImageCombo Control we could create a… Read More

Here, we will build a Class Module for data processing task, by passing a DAO.Recordset Object to our Custom Class Object.  Since it is an Object that is passing to our Custom Class we… Read More

Beginners of Microsoft Access can get confused with the usage of RUNSQL Action in Macro and DoCmd.RUNSQL method of Visual Basic for Applications (VBA). Whether you run this Action in Macro o… Read More

SELECT * FROM ES202_RUN_LKP WHERE EndDate BETWEEN CAST('01/01/2005' AS DATETIME) AND CAST('01/11/2008' AS DATETIME) SELECT DISTINCT * INTO ##temp3 from ##temp2 --Use this if I want to INS… Read More

php simple paging example======================The below code is self explanatory for a coder<?function Connect() { $hostname = "localhost"; $database = "mmm";… Read More